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

Post New Answer

More MySQL Interview Questions

What is myisamchk?

0 Answers  


What is the use of concat() in mysql?

0 Answers  


Are stored procedures precompiled?

0 Answers  


What is cursor in mysql?

0 Answers  


How do I export mysql query results to excel?

0 Answers  






What is row level locking in mysql?

0 Answers  


how to search second maximum(second highest) salary value(integer)from table employee (field salary)in the manner so that mysql gets less load?

0 Answers  


What does mysql_query return?

0 Answers  


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

4 Answers   Covansys,


How does triggers work in mysql?

0 Answers  


What do ddl, dml, and dcl stand for?

0 Answers  


Can we write procedure in mysql?

0 Answers  


Categories