what are the optimization techniques for Query optimization performance issues and faster execution of queries
2 12218what are the main differences between MyISAM and InnoDB table storage structures ? what are the advantages and disadvantages in usage of these ?
10 42493in a master-master replication with two masters and alternate slaves running on two systems.can i have a script or any mysql command to know which one is right now acting as master.
1 3385if we want to load data from a text file into a mysql table, but the columns in table are 1st: code(int) and 2nd: city(varchar), but in text file the format is 1st cityname and then code separeted by delimeters. how to load?
2 4498Ondelete clause is specified with a.)Drop table b.)Delete command c.)Create table d.)Select command
5 8369How we can copy one table data into another table whose name same as table but in differ database
8 16738please give me the answer for this: query which generates the second highest integer in the table?
8 7697
What is default schema in mysql?
How to check server status with 'mysqladmin'?
What are the difference between now and current_date in mysql?
What is the use of count function in mysql?
What is a scalar function?
How many rows can mysql hold?
Is the syntax correct? Explain the meaning of the syntax given below: $dbc = mysqli_connect('data.aliensabductedme.com', 'owen', 'aliensrool', 'aliendatabase');
How do you restart mysql?
What are the similarities between a function and a procedure?
How do I install mysql?
How set mysql root password?
Why use stored procedures in mysql?
How can you make a database as your current database?
How can I see mysql database?
Write command to import an mysql file?