How to check if mysql database exists
If you just need to know if a db exists so you won’t get an error when you try to create it, simply use (From here):
MySQL
How can I rebuild indexes and update stats in MySQL innoDB?
This is done with Read more about it here. ANALYZE TABLE analyzes and stores the key distribution for a table. During the analysis, the table is locked with a read lock for MyISAM, BDB, and InnoDB. This statement works with MyISAM, BDB, InnoDB, and NDB tables.
Dump all tables in CSV format using ‘mysqldump’
I need to dump all tables in MySQL in CSV format. Is there a command using mysqldump to just output every row for every table in CSV format?
importing a CSV into phpmyadmin
In phpMyAdmin, click the table, and then click the Import tab at the top of the page. Browse and open the csv file. Leave the charset as-is. Uncheck partial import unless you have a HUGE dataset (or slow server). The format should already have selected “CSV” after selecting your file, if not then select it … Read more
#1214 – The used table type doesn’t support FULLTEXT indexes
I’m getting an error saying that the table type doesn’t support FULLTEXT indices. How can I achieve this? Here’s my table: *
Get the new record primary key ID from MySQL insert query?
You need to use the LAST_INSERT_ID() function: http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#function_last-insert-id Eg: This will get you back the PRIMARY KEY value of the last row that you inserted: The ID that was generated is maintained in the server on a per-connection basis. This means that the value returned by the function to a given client is the first … Read more
How to create a foreign key in phpmyadmin
You can do it the old fashioned way… with an SQL statement that looks something like this This assumes the keys already exist in the relevant table
How can I search (case-insensitive) in a column using LIKE wildcard?
I looked around some and didn’t find what I was after so here goes. This works fine, but not if the tree is named Elm or ELM etc… How do I make SQL case insensitive for this wild-card search? I’m using MySQL 5 and Apache.
MySQL Workbench Dark Theme
How can I change MySQL Workbench settings so that it uses a dark theme?
MySQL: What’s the difference between float and double?
They both represent floating point numbers. A FLOAT is for single-precision, while a DOUBLE is for double-precision numbers. MySQL uses four bytes for single-precision values and eight bytes for double-precision values. There is a big difference from floating point numbers and decimal (numeric) numbers, which you can use with the DECIMAL data type. This is … Read more