DB: MySql
Problem:
create table aaa(
id int primary key,
phone varchar(100),
name varchar(50)
)
insert into aaa values(000101,'111','jackie');
insert into aaa values(000102,'222','milk');
insert into aaa values(000103,'111','lucy');
insert into aaa values(0001 ......
ÎÒÒѾ°²×°mysqlÁË£¬ÉèÖõĿª»ú²»Æô¶¯£¬µ«ÔÚÎҵĵçÄÔ'->'¹ÜÀí'->'·þÎñºÍÓ¦ÓóÌÐò'->·þÎñÖÐÕÒ²»µ½mysql£¬ÕâÑù¾Íû·¨Æô¶¯ÁË£¬ÎÒÏëѯÎÊÒ»ÏÂÕâµ½µ×ÊÇÔõô»ØÊ£¬ÏÈллÁË
ÓкöàµØ·½ÄØ
×¢²á±í
Æô¶¯Îļþ¼ÐµÈ
nÄã˵µÄÊÇ·þÎñ°É
ÓÐÕâ¸ö·þÎñô¡£¡£¡£ÃüÁîÐÐÆô¶¯
²»Ã÷°×ÕâÊÇÔõô»ØÊ£¡·þÎñÀïÔõôûÓУ¬¸Õ×°ÍêʱÓУ ......
ÏÖÔÚÎÒµÄmysqlÔÚlinuxÏÂÅÜ£¬µ«ÊÇËüµÄÆðʼʱ¼ä×ֶκÍ×îºóʱ¼ä×ֶζ¼ÊÇutc ʱ¼ä´Á£¬ÄÇÎÒÔõôÅжÏÁ½ÕßÖ®¼äʱ¼äÖ®²îСÓÚ5·ÖÖÓÄØ£¿
ÎÒoutÁË :-)
LSµÄÐÖµÜÃǶ¼ÊǸßÊÖ¡£
ÄǸö¼Ó5·ÖÖÓµÄд·¨ºÃÏñ»¹ÊDz»ÐУ¬±¨´í£¡
ÒýÓÃÄǸö¼Ó5·ÖÖÓµÄд·¨ºÃÏñ»¹ÊDz»ÐУ¬±¨´í£¡¹À¼ÆÄãд´íÁË¡£
ÍêÕûµÄ¸´ÖÆÌù³öÄãµÄÓï¾äºÍ´íÎóÐÅÏ¢¡£
²»ºÃ ......
sp ³ÌÐò
delimiter //
create procedure ma()
begin
declare i int default 0;
while i<11 do
set i=i+1;
select i;
end while;
end //
delimiter ;
1+2+...+9+10
ΪʲôÕâ¸ö³ÌÐòÎÞ·¨ÊµÏÖÀÛ¼ÓЧ¹û
//Çë˵Ã÷Õâ¸ö³ÌÐòµÄȱÏݺ͸Ľø·½·¨¡£¡£Ð»Ð»¸÷λ´ó¸ç
SQL code:
mysql> call ma();
+------+
| j ......
ÎÒ֮ǰ°²×°µÄÊÇwamp¼¯³É°ü ¿ª·¢phpÓÃµÄ ÏÖÔÚÏëÊÖ¶¯´î½¨¸ö»·¾³ ÔÚmysql°²×°µ½×îºóÒ»²½ÊdzöÏÖ
ûÓÐÏìÓ¦
Çë¸÷λ´óÏÀ²»Áߴͽ̣¡
ÊDz»ÊÇ»úÆ÷µÄÔÒò°¡£¬ÎҼǵÃÒÔÇ°ÔÚÄÄÀï¿´¹ýÕâÖÖÇé¿ö£¬²»¹ýÄÇÊǺܾÃÒÔÇ°µÄÊÂÇéÁË
ÖØÆôµçÄÔÔÙ°²×°ÊÔÊÔ....
Â¥Ö÷£¬ÒªÊÇÅäÖõ½×îºóÒ»²½³öÏÖ²»ÄÜÆô¶¯·þÎñµÄ´íÎóµÄ»°£¬Äǹ ......
±íproduct
ÓÐ×Ö¶Î
record_id pro_no
1 1AD00001
2 1AD00002
3 1AD00003
4 1AD00004
.
mysqlÓï¾ä ÈçºÎʵÏÖ ²éѯpro_no ´Ó1AD00001 µ½1AD00003µÄ¼Ç¼{{ ......
×ܼǼÊý:1662; ×ÜÒ³Êý:277; ÿҳ6 Ìõ;
Ê×Ò³ ÉÏÒ»Ò³ [6] [7] [8] [9] 10
[11] [12] [13] [14] [15] ÏÂÒ»Ò³ βҳ