TPhYg5gf

1### FIND + REPLACE
2
3```
4UPDATE `table_name` SET `mycolumn` = REPLACE(`mycolumn`,'target','replacement');
5```
6
7### UPDATE USER PASSWORD MANUALLY
8
9```
10> my
11> use mysql
12UPDATE mysql.user SET Password=PASSWORD(..) WHERE USER='username' AND Host='localhost';
13```
14
15### UPLOAD LARGE SQL FILES
16
17```
18> my
19> use db_name;
20> source /var/www/mydatabaseexport.sql
21```
22
23### CREATE USERS IN MYSQL
24
25```
26CREATE USER 'davidsword'@'localhost' IDENTIFIED BY '**********';
27GRANT ALL PRIVILEGES ON databasename.* TO 'davidsword'@'localhost';
28FLUSH PRIVILEGES;
29```
30
31### WORDPRESS UNABLE TO INSERT, AUTO_INCREMENT ERROR
32
33```
34# if IDs dont matter 
35ALTER TABLE `problem_table` DROP PRIMARY KEY;
36ALTER TABLE `problem_table` DROP COLUMN `id`;
37ALTER TABLE `problem_table` ADD  `id` INT( 11 ) NOT NULL  PRIMARY KEY AUTO_INCREMENT FIRST;

38
39# if IDs matter
40ALTER TABLE `problem_table` DROP PRIMARY KEY;
41DELETE FROM problem_table WHERE id = 0;
42ALTER TABLE problem_table MODIFY id int NOT NULL PRIMARY KEY AUTO_INCREMENT;
43```
44
45### DROP
46
47```
48drop table if exists tableName;
49```