what are the optimization techniques for Query optimization performance issues and faster execution of queries
2 12798what are the main differences between MyISAM and InnoDB table storage structures ? what are the advantages and disadvantages in usage of these ?
10 44237in 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 3756if 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 5070Ondelete clause is specified with a.)Drop table b.)Delete command c.)Create table d.)Select command
5 9445How we can copy one table data into another table whose name same as table but in differ database
8 17972please give me the answer for this: query which generates the second highest integer in the table?
8 8998
What is dump in mysql?
Why MySQL is used?
Consider you have a composite index of three columns. Now, you have to provide the value of two columns in the where clause of a select query. Do you think index can be used for the operation?
Why we use mysql workbench?
Is mysql a odbc?
What is the purpose of using timestamp data type?
How big is a blob mysql?
How you will Show unique records.
How would you enter characters as hex numbers?
How to add a new column to an existing table in mysql?
What is a left join mysql?
How can you see all indexes defined for a table?
How to Set a root password if there is on root password.
What is relational database in mysql?
How to enable or disable a row of a table using MySQL in struts?