Difference between revisions of "Mysql"
From MyWiki
| Line 16: | Line 16: | ||
[[ mysqldump to file with line terminations ]] <br> | [[ mysqldump to file with line terminations ]] <br> | ||
[[ Determine which storage engine is being used ]] <br> | [[ Determine which storage engine is being used ]] <br> | ||
| + | [[ Preventing database hanging when using mysqldump ]] <br> | ||
Revision as of 15:31, 2 September 2015
Selecting into a csv file
Indexes
Users
Column types
Altering column
Regular expressions
Setting the root password
Creating users
Setting a prinary key
Find duplicates
Test db for user creation
Update two columns
Selecting a table from a mysqldump file
Creating a mysql user
PHP mysqli_real_escape_string() Function
mysqldump to file with line terminations
Determine which storage engine is being used
Preventing database hanging when using mysqldump
