But that understanding sql book has no information about which tables they are working on and also which schema etc are being used, any book that gives complete information on which table is being workd upon, which schema is being used in each chapter?

|
piterden 2020-10-05 13:16:55
2020-10-05 13:15:03
i knew from this telegram

Suggest you to learn how to write a few your minds in one message and keep using of columns for MySQL

2020-10-05 13:17:41
piterden 2020-10-05 13:16:55
Suggest you to learn how to write a few your minds in one message and keep using of columns for MySQL

i dint get this? are u saying to write message in 1 line?

piterden 2020-10-05 13:19:55
2020-10-05 13:17:41
i dint get this? are u saying to write message in 1 line?

Where wouldn’t you been, try to notice what people are doing and how they are doing that and try to do a similar things. I helps usually…

2020-10-05 13:25:32
u mean google?
piterden 2020-10-05 13:26:30
I meant never mind
2020-10-05 13:31:29
ok bro
2020-10-05 13:31:34
both of us have bad english tbh
2020-10-05 13:31:42
so it is good that whatever we say we won’t get hurt
2020-10-05 14:02:07
mysql_en-6119.jpg

Ganesh 2020-10-05 14:02:15
Okay
2020-10-05 14:02:27
i need to show bname,author only for publication=”Ekta”.
2020-10-05 14:02:31
using subqueries.
2020-10-05 14:02:37
how do i do it?
2020-10-05 14:03:02
select bid,bname from book where publication IN (select publication from booklist where publication=”Ekta”;
2020-10-05 14:03:11
i tried this, but this resutted error
2020-10-05 14:03:39
i need a way to connect bid,bname from “book” to “booklist” how to do that, without join?
2020-10-05 14:05:37
done
2020-10-05 14:05:53
select * from book where bname in (select name from booklist where publication=”Ekta”);
MasterZiv 2020-10-05 14:47:46
2020-10-05 13:31:34
both of us have bad english tbh

If you write something, write one long lengthy message instead of a series of 10+ sorry messages

2020-10-05 14:48:20
i see
2020-10-05 14:49:15
but that understanding sql book has no information about which tables they are working on and also which schema etc are being used, any book that gives complete information on which table is being workd upon, which schema is being used in each chapter? instead of asking to read the book from first page to the last?
MasterZiv 2020-10-05 14:49:35
2020-10-05 14:02:07

BTW, where is bid in book list table? Missing?

MasterZiv 2020-10-05 14:50:55
2020-10-05 14:49:15
but that understanding sql book has no information about which tables they are working on and also which schema etc are being used, any book that gives complete information on which table is being workd upon, which schema is being used in each chapter? instead of asking to read the book from first page to the last?

Any book is kind of that, you need to read it through, completely

MasterZiv 2020-10-05 14:51:41
2020-10-05 14:03:02
select bid,bname from book where publication IN (select publication from booklist where publication=”Ekta”;

Here the syntax is wrong

2020-10-05 14:53:44
oh i already solved that, if there are books that don’t require me to read the whole book to understand 1 topic. for eg-: book recommended by u, need me to read whole book to understand about subqueries, not because i don’t have concepts right, but because it doesn’t meantions about the schemas properly
2020-10-05 14:55:28
if there are any such books, please respond. i finsihed the assignment late today(after 1.5 hr) but i need to learn this subquery topic..what are some good sources to learn it? any websites would be graeat..i learnt a great deal from sqlbolt.com. but that was only for basics, it was such a great website…now i feel kind of directionless…what resources should i follow? so that i can learn in less amount of time….i know google has everything….but i need a resources that will take me least amount of time to grasp the material…i will very highly appreciate yours help in finding me such resources…
MasterZiv 2020-10-05 14:55:37
2020-10-05 14:53:44
oh i already solved that, if there are books that don’t require me to read the whole book to understand 1 topic. for eg-: book recommended by u, need me to read whole book to understand about subqueries, not because i don’t have concepts right, but because it doesn’t meantions about the schemas properly

But you don’t know concepts any need to read all anyway…

2020-10-05 14:55:48
MasterZiv 2020-10-05 14:55:37
But you don’t know concepts any need to read all anyway…

i know concepts

2020-10-05 14:55:58
read my above reply (long one)
MasterZiv 2020-10-05 14:56:54
2020-10-05 14:55:48
i know concepts

I doubt. If you know concepts you know all

2020-10-05 15:42:16
MasterZiv 2020-10-05 14:56:54
I doubt. If you know concepts you know all

no i know upto the point i have done my assignments. i have already finished sqlbolt.com thrice. i am confident about it.

2020-10-05 15:42:28
but if you have better ideas/books/resources, do share
2020-10-05 15:42:34
i won’t mind it.
2020-10-05 16:47:45
sqlzoo.net
2020-10-05 16:47:48
is also great
jacob_joelin 2020-10-06 08:33:01
Hello!
jacob_joelin 2020-10-06 08:34:15
I got the project on mysql connectivity with python on billing software so anyone could help me with it !?
jacob_joelin 2020-10-06 08:34:38
Its my first project so i wann sm help
MasterZiv 2020-10-06 08:47:49
jacob_joelin 2020-10-06 08:34:15
I got the project on mysql connectivity with python on billing software so anyone could help me with it !?

Ask questions

jacob_joelin 2020-10-06 08:55:55
Sorry!
omiikharkar 2020-10-06 10:20:04
mysql_en-6161.jpg

omiikharkar 2020-10-06 10:20:09
omiikharkar 2020-10-06 10:20:04

Hi everyone I am facing this problem from last 30 minutes…

omiikharkar 2020-10-06 10:20:24
Does it take this much time
piterden 2020-10-06 11:11:20
omiikharkar 2020-10-06 10:20:24
Does it take this much time

Use linux

omiikharkar 2020-10-06 11:58:49
piterden 2020-10-06 11:11:20
Use linux

I don’t have linux

piterden 2020-10-06 12:10:26
omiikharkar 2020-10-06 11:58:49
I don’t have linux

It is free

omiikharkar 2020-10-06 12:10:55
piterden 2020-10-06 12:10:26
It is free

My pc doesn’t support linux…

omiikharkar 2020-10-06 12:11:03
I’m using windows
2020-10-06 12:11:53
omiikharkar 2020-10-06 10:20:24
Does it take this much time

😂😂😂 CAN’T EVEN SET UP PROPERLY. lol FOLLOW ANY YOUTUBE VIDEO SPEND SOME MINUTES. there was 1 good indian dude’s video that i watched. everything is just click the default, default, default(i.e as it is)

piterden 2020-10-06 12:13:24
omiikharkar 2020-10-06 12:10:55
My pc doesn’t support linux…

It can’t be true

|