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