what are the optimization techniques for Query optimization performance issues and faster execution of queries
2 11686what are the main differences between MyISAM and InnoDB table storage structures ? what are the advantages and disadvantages in usage of these ?
10 40961in 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 3040if 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 4066Ondelete clause is specified with a.)Drop table b.)Delete command c.)Create table d.)Select command
5 7583How we can copy one table data into another table whose name same as table but in differ database
8 15714please give me the answer for this: query which generates the second highest integer in the table?
8 6733
What is a join? Explain the different types of mysql joins.
Which statement is used to delete a table in MySQL.
Can't connect mysql server on localhost?
What port is mysql running on?
How to use mysqldump to create a copy of the database?
What is timestamp in mysql?
What are triggers mysql?
What is a blob datatype?
What is cursor in mysql?
How can we convert between Unix & MySQL timestamps?
What is mysql procedure?
What are ddl statements in mysql?
What are Heap tables?
What is difference between mysql_connect and mysql_pconnect?
What is the difference between truncate and delete?