What is database clustering in mysql?
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
What is the difference between mysql_fetch_assoc and mysql_fetch_array?
What is difference between mysql_connect and mysql_pconnect?
how can you test for null values in a database? : Mysql dba
Explain the difference between mysql and mysqli interfaces in PHP?
How we can copy one table data into another table whose name same as table but in differ database
What is mysql cursor?
What is a mysql view?
How can you export the table as an xml file in mysql?
What is inner join in mysql?
Fname Lname City Pin ramesh kumar salem 365241 Query to generate a code having the firstletter of Fname,Lname & 3letter of city Last 3letter of pin,all in capital letters
What is 'mysqlshow'?