所以說這是什麼地方

--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