Can you post the DDL part of you database?

There is no publication field in your schema, as far as I can see…

What is command for taking dump of only functions

Mysqldump

Mysqldump -uroot -p — no- data –functions <database> ..right ?

–routines not functions. It will include both sp and functions.

Ok thanks

Yes, kind of

i could use join

i got confused

such a silly confusion

i solved it with inner join

but i can’t understand in detail about joins? any good resources to learn about joins in greater depth?

Can you post the DDL part of you database?

wat

bro

i am solving assignments

I mean CREATE statements of your tables, or better full database with all data

wait bro

i will do that soon

how to write this using a subquery

select ename, faculty from employee where dateofemployee=”2020-01-01″

There is no way to do it and there isn’t join in query

true man

i don’t know why my teachers give these crazy assignemnts

they don’t prepare at all.

Where do you study?

nepal

are u from russia?

School? University? What direction?

Yes

If you aren’t ready, why do you go to study there?

what ready?

Your problem is easier than simple. It is googling with one query only

And I had already showed you queries to google which you need

select bname, author from book inner join booklist on book.bname=booklist.name where publication=”shajha prakashan”

need to convert this to sub query.

i am trying it

frm google

Martin Gruber introduction to SQL

If you want to be a programmer, you should be ready to solve such issues without any help from outside.

yes

i solve it myself

i don’t need big help

i have learnt how to learn

but i learn little bit slowly

that is my only dis

this book is a gem

i knew from this telegram

Yes