Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ : mysql

MYSQL ²éÕÒ³öÖظ´ÁÐÖµ - MS-SQL Server / ÒÉÄÑÎÊÌâ

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ÎÊÌâ - MS-SQL Server / ·Ç¼¼Êõ°æ

ÎÒÒѾ­°²×°mysqlÁË£¬ÉèÖõĿª»ú²»Æô¶¯£¬µ«ÔÚÎҵĵçÄÔ'->'¹ÜÀí'->'·þÎñºÍÓ¦ÓóÌÐò'->·þÎñÖÐÕÒ²»µ½mysql£¬ÕâÑù¾Íû·¨Æô¶¯ÁË£¬ÎÒÏëѯÎÊÒ»ÏÂÕâµ½µ×ÊÇÔõô»ØÊ£¬ÏÈллÁË
ÓкöàµØ·½ÄØ
×¢²á±í
Æô¶¯Îļþ¼ÐµÈ

nÄã˵µÄÊÇ·þÎñ°É

ÓÐÕâ¸ö·þÎñô¡£¡£¡£ÃüÁîÐÐÆô¶¯

²»Ã÷°×ÕâÊÇÔõô»ØÊ£¡·þÎñÀïÔõôûÓУ¬¸Õ×°ÍêʱÓУ ......

mysqlʱ¼ä´Á - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql

ÏÖÔÚÎÒµÄmysqlÔÚlinuxÏÂÅÜ£¬µ«ÊÇËüµÄÆðʼʱ¼ä×ֶκÍ×îºóʱ¼ä×ֶζ¼ÊÇutc ʱ¼ä´Á£¬ÄÇÎÒÔõôÅжÏÁ½ÕßÖ®¼äʱ¼äÖ®²îСÓÚ5·ÖÖÓÄØ£¿

ÎÒoutÁË :-)

LSµÄÐÖµÜÃǶ¼ÊǸßÊÖ¡£

ÄǸö¼Ó5·ÖÖÓµÄд·¨ºÃÏñ»¹ÊDz»ÐУ¬±¨´í£¡

ÒýÓÃÄǸö¼Ó5·ÖÖÓµÄд·¨ºÃÏñ»¹ÊDz»ÐУ¬±¨´í£¡¹À¼ÆÄãд´íÁË¡£
ÍêÕûµÄ¸´ÖÆÌù³öÄãµÄÓï¾äºÍ´íÎóÐÅÏ¢¡£

²»ºÃ ......

mysql ÀÛ¼ÓÔËËã - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql

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 ......

mysqlûÓÐÏìÓ¦ - PHP / »ù´¡±à³Ì

ÎÒ֮ǰ°²×°µÄÊÇwamp¼¯³É°ü ¿ª·¢phpÓÃµÄ ÏÖÔÚÏëÊÖ¶¯´î½¨¸ö»·¾³ ÔÚmysql°²×°µ½×îºóÒ»²½ÊdzöÏÖ
ûÓÐÏìÓ¦ 
  Çë¸÷λ´óÏÀ²»Áߴͽ̣¡
ÊDz»ÊÇ»úÆ÷µÄÔ­Òò°¡£¬ÎҼǵÃÒÔÇ°ÔÚÄÄÀï¿´¹ýÕâÖÖÇé¿ö£¬²»¹ýÄÇÊǺܾÃÒÔÇ°µÄÊÂÇéÁË


ÖØÆôµçÄÔÔÙ°²×°ÊÔÊÔ....

Â¥Ö÷£¬ÒªÊÇÅäÖõ½×îºóÒ»²½³öÏÖ²»ÄÜÆô¶¯·þÎñµÄ´íÎóµÄ»°£¬Äǹ ......

mysql ²éѯ - MS-SQL Server / Ó¦ÓÃʵÀý

±í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]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ