Interested to Buy Any Domain ? << Click Here >> for more details...
A select query over a large table runs very slow because of the growing number of entries in that table. What different measures could be taken to improve speed?
5 14887A company wants to store their invoices in a database. They already have their customers and articles in that database. Both customer and article are each identified by an unique integer value. Please create the SQL statements for creating the necessary table(s) for storing the invoices in a MySQL database. An invoice should hold information like invoice number, customer, date, article(s) and quantity etc.
1 4517For the database from the previous question, please give an SQL query which returns the invoice number of all invoices which contain the article with the number ?1234?. The query should be able to run under a MySQL 4.0 database.
1 3772How would you backup and restore a big MySQL database? What are the advantages of the approach which you have taken over the others?
4 11048What are the differences between MySQL_fetch_array(), MySQL_fetch_object(), MySQL_fetch_row()?
2 8422The table tbl_sites contains the following data: ----------------------------------------------------- Userid sitename country ------------------------------------------------------ 1 sureshbabu indian 2 PHPprogrammer andhra 3 PHP.net usa 4 PHPtalk.com germany 5 MySQL.com usa 6 sureshbabu canada 7 PHPbuddy.com pakistan 8. PHPtalk.com austria 9. PHPfreaks.com sourthafrica 10. PHPsupport.net russia 11. sureshbabu australia 12. sureshbabu nepal 13. PHPtalk.com italy Write a select query that will displayed the duplicated site name and how many times it is duplicated?
4 9781
What are date and time data types in mysql?
What is ntext?
How do I create a schema in mysql?
What are the reasons for selecting lamp (linux, apache, mysql, php) instead of combination of other software programs, servers and operating systems?
How do I start and stop mysql server?
How can you filter the duplicate data while retrieving records from the table?
How to load data files into tables with 'mysqlimport'?
What is a delimiter in mysql?
Suppose you have to collect the first name, middle name and the last name of students from the below table. But, you observe that there few missing values either in the first name, middle name and the last name columns. How will you return the first non-null values?
What is the current root password of mysql?
How do I create a mysql username and password?
How large can a mysql table be?
What is the use of procedure in mysql?
What is MySQL?
How many ways to get the current time?
