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