Studying note 1 of mysql
来源:互联网 发布:阿里云企业邮箱格式 编辑:程序博客网 时间:2024/05/16 06:30
1.Start the server:
shell>mysqld
or
shell>mysqld --console : The server will continue to write to the console any further dianostic output it produces.
2.Shutdow the server
shell>mysqladmin -h -u -p shutdown
such as shell>mysqladmin -h 192.168.12.252 -u root -p shutdown :the server in 192.168.12.252
shell>mysqladmin -u root -p shutdown :the server in localhost
3.Start mysql as a window service.
shell>msyqld --install serviceName --defaults-file
such as shell>mysqld --install
shell>mysqld --install mmgg
shell<mysqld --install mmgg --defaults-file=c:/mmgg
4.Remove a server that is installed as a service.
shell>mysqld --remove serviceName
such as shell>mysqld --remove
shell>mysqld --remove MySQL
5.Connect to the server.
shell>mysql -h -u -p
such as shell>mysql -h 192.168.12.252 -u root -p
shell>mysql -u root -p
6.Disconnect from the server.
mysql>quit(/q)
7.Show all databases.
mysql>show databases;
9.Chanage database.
mysql>use database;
10.Show all tables of one database.
mysql>show tables;
11.Describe one table.
mysql>describe tableName.
12.Load data into a table.
mysql>LOAD DATA LOCAL INFILE 'fileName' INTO TABLE tableName;
such as mysql>LOAD DATA LOCAL INFILE 'd:/mysql/data/user.txt' INTO TABLE user;
13.Show the selected database.
mysql>select database();
14.Describe table.
mysql>describe tableName;
such as describe user;
shell>mysqld
or
shell>mysqld --console : The server will continue to write to the console any further dianostic output it produces.
2.Shutdow the server
shell>mysqladmin -h -u -p shutdown
such as shell>mysqladmin -h 192.168.12.252 -u root -p shutdown :the server in 192.168.12.252
shell>mysqladmin -u root -p shutdown :the server in localhost
3.Start mysql as a window service.
shell>msyqld --install serviceName --defaults-file
such as shell>mysqld --install
shell>mysqld --install mmgg
shell<mysqld --install mmgg --defaults-file=c:/mmgg
4.Remove a server that is installed as a service.
shell>mysqld --remove serviceName
such as shell>mysqld --remove
shell>mysqld --remove MySQL
5.Connect to the server.
shell>mysql -h -u -p
such as shell>mysql -h 192.168.12.252 -u root -p
shell>mysql -u root -p
6.Disconnect from the server.
mysql>quit(/q)
7.Show all databases.
mysql>show databases;
9.Chanage database.
mysql>use database;
10.Show all tables of one database.
mysql>show tables;
11.Describe one table.
mysql>describe tableName.
12.Load data into a table.
mysql>LOAD DATA LOCAL INFILE 'fileName' INTO TABLE tableName;
such as mysql>LOAD DATA LOCAL INFILE 'd:/mysql/data/user.txt' INTO TABLE user;
13.Show the selected database.
mysql>select database();
14.Describe table.
mysql>describe tableName;
such as describe user;
- Studying note 1 of mysql
- Studying note 2 of mysql--user account manager
- android note of studying-----DataBase
- Studying note of GCC-3.4.6 source (1)
- Studying note of GCC-3.4.6 source (139 - cont 1)
- Studying note of GCC-3.4.6 source (141 - cont 1)
- Studying note of GCC-3.4.6 source (147 - cont 1)
- Studying note of GCC-3.4.6 source (2)
- Studying note of GCC-3.4.6 source (3)
- Studying note of GCC-3.4.6 source (4)
- Studying note of GCC-3.4.6 source (5)
- Studying note of GCC-3.4.6 source (6)
- Studying note of GCC-3.4.6 source (7)
- Studying note of GCC-3.4.6 source (8)
- Studying note of GCC-3.4.6 source (9)
- Studying note of GCC-3.4.6 source (10)
- Studying note of GCC-3.4.6 source (10 cont1)
- Studying note of GCC-3.4.6 source (10 cont2)
- 解读《sdrcMwau:formgenerator 》-01
- ASP.NET开发三层结构应用程序
- Linux下用vsftp建立个人ftp站点(一)
- Linux下用vsftp建立个人ftp站点(二)
- Java的内存泄漏
- Studying note 1 of mysql
- Linux性能调优
- 2004年度暴欠扁短信集锦
- HtmlTextWriter和相关的枚举类型
- 驱动程序备份专家 --- http://61.158.10.15/soft/system/WinDrvExpert.zip
- 网络游戏外挂编写初级教程
- 〔转载〕中国的科技能超越美国吗?
- 一个计算个人所得税的例子
- 能上QQ,不能上网的解决方法