Difference between revisions of "Mysql"
From MyWiki
(15 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
+ | [[ Altering column ]]<br> | ||
+ | [[ Column types ]]<br> | ||
+ | [[ Creating a mysql user ]]<br> | ||
+ | [[ Creating users ]] <br> | ||
+ | [[ Determine which storage engine is being used ]] <br> | ||
+ | [[ Find duplicates ]]<br> | ||
+ | [[ Find the size of mysql database ]]<br> | ||
[[ Selecting into a csv file ]]<br> | [[ Selecting into a csv file ]]<br> | ||
[[ Indexes ]]<br> | [[ Indexes ]]<br> | ||
− | [[ | + | [[ Selecting a table from a mysqldump file ]]<br> |
− | [[ | + | [[ PHP mysqli_real_escape_string() Function ]]<br> |
− | [[ | + | [[ mysqldump to file with line terminations ]] <br> |
+ | [[ mysqldump selecting tables only ]]<br> | ||
+ | [[ Preventing database hanging when using mysqldump ]] <br> | ||
[[ Regular expressions ]]<br> | [[ Regular expressions ]]<br> | ||
− | |||
− | |||
[[ Setting a prinary key ]]<br> | [[ Setting a prinary key ]]<br> | ||
− | [[ | + | [[ Setting the root password ]]<br> |
[[ Test db for user creation ]]<br> | [[ Test db for user creation ]]<br> | ||
+ | [[ Update two columns ]]<br> | ||
+ | [[ Users ]]<br> | ||
+ | [[ Insert ignore to avoid updating existing record ]] <br> | ||
+ | [[ Enable MySQL’s slow query log without a restart ]]<br> | ||
+ | [[ Securing mysql with a script ]]<br> |
Latest revision as of 12:15, 28 August 2017
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
Insert ignore to avoid updating existing record
Enable MySQL’s slow query log without a restart
Securing mysql with a script