Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 ɾ³ýÖ÷¼ü³öÏÖ´íÎó£¡

 
mysql> select * from a;
+----+------+----------+
| id | name | password |
+----+------+----------+
| 1 | a | NULL |
| 2 | a | NULL |
| 3 | a | NULL |
| 4 | a | NULL |
+----+------+----------+
4 rows in set (0.00 sec)
mysql> alter table a drop ......

mysqlÅúÁ¿¶à±íupdate¼ÆËãÎÊÌâ

´ó¼ÒºÃ£¬Çë½ÌÒ»¸öÎÊÌ⣺лл
ÕË»§±í
userid,×Ü×ʽð,Ïû·Ñ×ܶî
---------------------------
1 , 2000 , ?
2 , 5000 , ?
......
¼Û¸ñ±í
¼Û¸ñ,ÉÌÆ·,É̼Ò
-----------------------------
100 ,¸Ö±Ê,A³§
109 ,¸Ö±Ê,B³§
60 ,Ǧ±Ê,C³§
58 ,Ǧ±Ê,D³§
...........
¶©µ¥±í
id,¼Û¸ñ,ÉÌÆ·,É̼Ò,userid£¬ÊýÁ ......

MYSQL ·ÖÒ³´íÎóÁË

mysql> select * from b;
+------+------+-------+
| id | name | bumen |
+------+------+-------+
| 2400 | a | 1 |
| 2300 | b | 1 |
| 2200 | a | 2 |
| 2200 | b | 2 |
+------+------+-------+
4 rows in set (0.00 sec)
mysql> select top 2 * from b order by id; ......

ÎÞ·¨ÏÔʾmysqlÀïµÄͼƬ

Ò»ÏÂÊÇÎҵĴúÂ룺
upf1.html
<html>
 <head>
 <title>ÉÏ´«Í¼Æ¬</title>
 </head>
 <body>
 <form method="post" action="upf2.php" enctype="multipart/form-data"><center><br><br>< ......

ÎÒµÄmysql°²×°³öÎÊÌâÁË£¡£¡£¡ÇóÖú

mysql²»ÄÜʹÓÃlocalhost×÷ΪÖ÷»úÃû½øÐÐÁ¬½Ó£¬Ö»ÄÜʹÓÃ127.0.0.1½øÐÐÁ¬½Ó£¬ÕâÑù±¾»úµÄphpmyadmin¾Íû°ì·¨Ê¹Ó㬻òÕßÊÇÒª½øÐÐÐ޸ġ£
¸ÃÔõô°ì£¿
apache¿ÉÒÔ´ò¿ªhttp://localhost/ Ö»ÊÇmysql²»ÄÜÓÃlocalhost½øÐÐÁ¬½Ó¡£ÊDz»ÊÇÓ¦¸Ã¶Ômysql½øÐÐÉèÖã¬ÒªÔõôÉèÖã¿
Ë­½Ì½ÌÎÒ£¡
ÔÚmysql.cnfÀïÃæÕÒÕҹؼü×Ösock£¬¿´¿´ÊÇʲôÑù×Ó¡ ......

mysql´æ´¢¹ý³Ì»ñµÃ²åÈëÊý¾ÝµÄ×ÔÔö³¤ID

CREATE DEFINER=`root`@`localhost` PROCEDURE `chat_user_adduer`(
in UN varchar(45),
in Psw varchar(50),
in NM varchar(45),
in se tinyint,
out Result int
)
BEGIN
insert into t_b_chatuser(username,password,name,sex)
values(UN,Psw,NM,se);
select Result=last_insert_id();
END
ΪʲôResultµÄÖµÊ ......
×ܼǼÊý:1662; ×ÜÒ³Êý:277; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [33] [34] [35] [36] 37 [38] [39] [40] [41] [42]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ