Difference between revisions of "Mysql"
From MyWiki
| Line 1: | Line 1: | ||
| + | [[ Altering column ]]<br> | ||
| + | [[ Column types ]]<br> | ||
| + | [[ Creating users ]] <br> | ||
| + | [[ Determine which storage engine is being used ]] <br> | ||
[[ Selecting into a csv file ]]<br> | [[ Selecting into a csv file ]]<br> | ||
[[ Indexes ]]<br> | [[ Indexes ]]<br> | ||
| − | + | ||
| − | + | ||
| − | + | ||
[[ Regular expressions ]]<br> | [[ Regular expressions ]]<br> | ||
| − | + | ||
| − | + | ||
[[ Setting a prinary key ]]<br> | [[ Setting a prinary key ]]<br> | ||
[[ Find duplicates ]]<br> | [[ Find duplicates ]]<br> | ||
| Line 15: | Line 19: | ||
[[ 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> | ||
| + | [[ Setting the root password ]]<br> | ||
| + | [[ Users ]]<br> | ||
Revision as of 13:01, 10 September 2015
Altering column
Column types
Creating users
Determine which storage engine is being used
Selecting into a csv file
Indexes
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
Preventing database hanging when using mysqldump
Setting the root password
Users
