mysql更新表中資料的儲存過程，程式碼如下：

mysql>CREATETABLEEmployee(//建立表

->idint,

->first_nameVARCHAR(15),

->last_nameVARCHAR(15),

->start_dateDATE,

->end_dateDATE,

->salaryFLOAT(8,2),

->cityVARCHAR(10),

->descriptionVARCHAR(15)

->);

QueryOK,0rowsaffected(0.01sec)

--//匯入資料

mysql>insertintoEmployee(id,first_name,last_name,start_date,end_Date,salary,City,Description)

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

QueryOK,1rowaffected(0.00sec)