How can you change the name of any existing table by using the sql statement?
No Answer is Posted For this Question
Be the First to Post Answer
What is myisamchk?
What is the use of concat() in mysql?
Are stored procedures precompiled?
What is cursor in mysql?
How do I export mysql query results to excel?
What is row level locking in mysql?
how to search second maximum(second highest) salary value(integer)from table employee (field salary)in the manner so that mysql gets less load?
What does mysql_query return?
SQL: 1. Write a queryto retrieve the author who was published a book at the youngest age? 2. write a query to retrieve the no. of books published a each year in various languages? 3. write a query to retrieve no. of books published by them only those authors who have published more than 1 book? 4. write a query to retrieve who has not published any books during the year 2006? 5. write a query to retrieve the authors who has published any books during the birth date write this query in 2 ways 1)joins 2)sub query 6. write a query to retrieve all the books which was published during jan 2007 & title containing India or published in the language hindi? 1. table name is liberary managemnt and two column is there one is authors and another one is books . 2.four fields will comes under authours like nationality, birthdate ,first-language,second-language 3.four fields will comes under books like authour,title ,language,publish date to write query using this details
How does triggers work in mysql?
What do ddl, dml, and dcl stand for?
Can we write procedure in mysql?