use information_schema select * from columns where table_name='表名';
顺便记下:
show databases;
use 数据库名;
show tables;
ALTER [IGNORE] TABLE tbl_name alter_spec [, alter_spec ...]
alter_specification:
ADD [COLUMN] create_definition [FIRST | AFTER column_name ]
or ADD INDEX [index_name] (index_col_name,...)
or ADD PRIMARY KEY (index_col_name,...)
or ADD UNIQUE [index_name] (index_col_name,...)
or ALTER [COLUMN] col_name {SET DEFAULT literal | DROP DEFAULT}
or CHANGE [COLUMN] old_col_name create_definition
or MODIFY [COLUMN] create_definition
or DROP [COLUMN] col_name
or DROP PRIMARY KEY
or DROP INDEX index_name
or RENAME [AS] new_tbl_name
or table_options
Connect to Database:
mysql -h 10.19.90.52-u username -p
mysql create database databaseName;
grant all privileges on *.* to 'root'@'%' identified by 'passwd';
Privillege :
show grants for 'username'@'%';
set password for 'username'@'%' = PASSWORD('newpwd');
Create User :
GRANT ALL PRIVILEGES ON . TO 'uesrname'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
FLUSHPRIVILEGES;