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 ......
´ó¼ÒºÃ£¬Çë½ÌÒ»¸öÎÊÌ⣺лл
ÕË»§±í
userid,×Ü×ʽð,Ïû·Ñ×ܶî
---------------------------
1 , 2000 , ?
2 , 5000 , ?
......
¼Û¸ñ±í
¼Û¸ñ,ÉÌÆ·,É̼Ò
-----------------------------
100 ,¸Ö±Ê,A³§
109 ,¸Ö±Ê,B³§
60 ,Ǧ±Ê,C³§
58 ,Ǧ±Ê,D³§
...........
¶©µ¥±í
id,¼Û¸ñ,ÉÌÆ·,É̼Ò,userid£¬ÊýÁ ......
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;
......
Ò»ÏÂÊÇÎҵĴúÂ룺
upf1.html
<html>
<head>
<title>ÉÏ´«Í¼Æ¬</title>
</head>
<body>
<form method="post" action="upf2.php" enctype="multipart/form-data"><center><br><br>< ......
mysql²»ÄÜʹÓÃlocalhost×÷ΪÖ÷»úÃû½øÐÐÁ¬½Ó£¬Ö»ÄÜʹÓÃ127.0.0.1½øÐÐÁ¬½Ó£¬ÕâÑù±¾»úµÄphpmyadmin¾Íû°ì·¨Ê¹Ó㬻òÕßÊÇÒª½øÐÐÐ޸ġ£
¸ÃÔõô°ì£¿
apache¿ÉÒÔ´ò¿ªhttp://localhost/ Ö»ÊÇmysql²»ÄÜÓÃlocalhost½øÐÐÁ¬½Ó¡£ÊDz»ÊÇÓ¦¸Ã¶Ômysql½øÐÐÉèÖã¬ÒªÔõôÉèÖã¿
˽̽ÌÎÒ£¡
ÔÚmysql.cnfÀïÃæÕÒÕҹؼü×Ösock£¬¿´¿´ÊÇʲôÑù×Ó¡ ......
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µÄÖµÊ ......