mysql repeat 游标_mysql循环结构 Repeat ... until循环中使用游标

mysql中repeat...until循环结构及游标的用法举例。

代码：

mysql> CREATE TABLE Employee( //创建数据表

-> id int,

-> first_name VARCHAR(15),

-> last_name VARCHAR(15),

-> start_date DATE,

-> end_date DATE,

-> salary FLOAT(8,2),

-> city VARCHAR(10),

-> description VARCHAR(15)

-> );

Query OK, 0 rows affected (0.03 sec)

mysql> insert into Employee(id,first_name, last_name, start_date, end_Date, salary, City, Description)

-> values (1,'Jason', 'Martin', '19960725', '20060725', 1234.56, 'Toronto', 'Programmer');

Query OK, 1 row affected (0.00 sec)

mysql>

mysql> insert into Employee(id,first_name, last_name, start_date, end_Date, salary, City, Description)

-> values(2,'Alison', 'Mathews', '19760321', '19860221', 6661.78, 'Vancouver','Tester');

Query OK, 1 row affected (0.00 sec)

mysql>

mysql> insert into Employee(id,first_name, last_name, start_date, end_Date, salary, City, Description)

-> values(3,'James', 'Smith', '19781212', '19900315', 6544.78, 'Vancouver','Tester');

Query OK, 1 row affected (0.00 sec)

mysql>

mysql> insert into Employee(id,first_name, last_name, start_date, end_Date, salary, City, Description)

-> values(4,'Celia', 'Rice', '19821024', '19990421', 2344.78, 'Vancouver','Manager')