连接数据库
...
$sql="insert into 表 (字段1,字段2,...,字段x) values ('值1','值2',...,'值x')";
$result=mysql_query($sql);
就ok了。
...
$sql="insert into 表 (字段1,字段2,...,字段x) values ('值1','值2',...,'值x')";
$result=mysql_query($sql);
就ok了。
用create procedure proc_name()
begin
语句
end
给你一个网址
http://www.bc-cn.net/Article/Search.asp?Field=Title&ClassID=&keyword=%B4%E6%B4%A2%B9%FD%B3%CC&Submit=+%CB%D1%CB%F7+
BEGIN
DECLARE done INT DEFAULT 0;
DECLARE a CHAR(16);
DECLARE cur1 CURSOR FOR SELECT data FROM test.t1;
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;OPEN cur1;REPEAT
FETCH cur1 INTO a;
set c = c+a+'#';
UNTIL done END REPEAT;CLOSE cur1;
END