Mysql 备忘

[hsipeng]

mysql

#mysql

抓取 MySQL Table auto_increment 的最大值

直接由 information_schema 找 MySQL Table auto_increment 的最大值, 有下述兩種情況:

• 此 Table name 於整個 MySQL DB 中是唯一的:

SELECT TABLE_ROWS FROM information_schema.tables WHERE table_name='YOUR_TABLE_NAME';

• 此 Table name 於整個 MySQL DB 中有多個, 需要指定 DB Name:

SELECT TABLE_ROWS FROM information_schema.tables WHERE table_name='YOUR_TABLE_NAME' AND table_schema = 'YOUR_DB_NAME';

或下述:
use YOUR_DB_NAME; // 抓取自己現在的 Database name 可用: SELECT DATABASE();

SELECT TABLE_ROWS FROM information_schema.tables WHERE table_name='YOUR_TABLE_NAME' AND table_schema = DATABASE();

开启权限

开启远程访问权限

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'IDENTIFIED BY ‘!123456’ WITH GRANT OPTION;

// 刷新权限
FLUSH PRIVILEGES;