--updated 2014 04 15
-- login myserver
mysql -h 0.0.0.0 -u username -p
-- show databases
show databases;
-- create database
careate database databasename;
-- change database
use databasename;
-- create new table
create table tablename (sn int not null auto auto_increment, var1 nvarchar(100), primary key (sn));
-- show table cols
describe tablename;
-- alter table
alter table tablename change var1 var nvarchar(50);
alter table tablename add (var2 int);
alter table tablename drop var2;
-- copy database to another server
--from localhost to other
mysqldump -h localhost -u ACCOUNT -pPASSWORD DATABASE_NAME | mysql -h FORIGN_HOST -u ACCOUNT2 -pPASSWORD2 TARGET_DATABSE_NAME
全站熱搜
留言列表