MySQL Getting Started

MySQL

下载：http://www.mysql.com
版本：mysql-5.5.23 GA
目录：d:\software\mysql-5.5.23-winx64\bin\

启动服务器：
mysqld
停止服务器：
mysqladmin -u root shutdown

启动客户端：
mysql -u root -p
create database jason;
use jason;
create table x(id int, name varchar(30));
insert into x values(1,'Jason');
insert into x values(2,'Jobs');
commit;
select * from x;

show databases;

show tables;
exit

DELIMITER //
CREATE PROCEDURE GetAllProducts()
  BEGIN
  SELECT *  FROM x;
  END //
DELIMITER ;