Advertise your Business Here      Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new    Refer this Site               Login  |  Sign Up                             Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   HERE

Categories  >>  Software  >>  Databases  >>  MySQL        Suggest New Category      Question  Asked @ Answers Views     select   The 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? Afixi   3  1545 Explain MySQL optimization?  1  892 What are the differences between MySQL_fetch_array(), MySQL_fetch_object(), MySQL_fetch_row()?  2  2041 How would you backup and restore a big MySQL database? What are the advantages of the approach which you have taken over the others?  2  1891 For 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  353 A 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  372 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?  3  3451 What are the differences between drop a table and truncate a table?  6  3654 How can we change the name and data type of a column of a table? Google  3  3160 How can we change the name of a column of a table?  4  1775 How can we know the number of days between two given dates using MySQL? Webworks   2  2061 How to load data from a text file into a table? Sasaa  4  2257 What is the difference between char and varchar data types?  3  4122 What is the difference between GROUP BY and ORDER BY in Sql? Renault-Nissan   4  6381 What are the advantages and disadvantages of MySQL? Satyam  0  511 E-Mail New Answers        Answer Selected Questions        Post New MySQL Question   Prev    1   2   3   4    [5]   6   7   8   9    Next         Oracle Interview Questions     SQL Server Interview Questions     MS Access Interview Questions     MySQL Interview Questions     Postgre Interview Questions     Sybase Interview Questions     DB Architecture Interview Questions     DB Administration Interview Questions     DB Development Interview Questions     SQL PLSQL Interview Questions     Databases AllOther Interview Questions       Un-Answered Questions    Question Views Asked at   Select   How can you plan the logshipping before processing? 183 ACC How to enable or disable a row of a table using MySQL in struts? 207   mazimum size of a database in mysql? when we create a table then how many tables actually created? write there name? 25   HOW TO FIND display the total number of weeks in the year of 1998 IN EMP TABLE 58   Can anyone help me to create a good mysql database schema with an example. Thanks, Sekar.jr 101   what is the advantage of stored procedures, triggers and indexing in mysql 35   suppose data is copie to oracle to sql by using DTS. Actully it taken 2 hours. suppose some day distribute the server in the middle of 2 hours. after how can i get the data ? 159 ACC all the queries used in sql 223   how we can find nth max salary from an employe table by using my sql? 11   How can you get your MySQL root password, if you lost it? 261 PCS Have you ever used MySQL Administrator and MySQL Query Browser? Describe the tasks you accomplished with these tools? 323 TCS 1)for snapshot replication which agents used? 2)for Transcation replication which agents used? 3)for merge replciation which agents used? 171 ACC how many fields can be updated using set in a mysql query? 36   i made a table whih contain a column "Photo" with image data type and i want to insert the byte of a picture present in my hardisk using insert statement in that colum... so what will be my insert statement? 237   how many table created when we create a table in mysql? 38   How to set the time zone for MySQL to particular country time? 309   maximum size of a database in mysql? 63   what is mysql optimization in brief? 47   E-Mail New Answers        Answer Selected Questions

Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |            Copyright © 2007  ALLInterview.com.  All Rights Reserved. ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com