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µÄÖµÊ ......
hql = "select left('adfsadfasgsadgagsda',2)";
¾ÍÓÃÕâ¾äÓï¾ä ÔÚÊý¾Ý¿âÖÐÖ´ÐÐ
µ«ÊÇÔÚjava´úÂëÖÐ ÓÃHibernate Ö´ÐÐ ¾Í²»ÄÜÖ´ÐÐ £¿
ÕâÊÇʲôÎÊÌ⣡£¡£¡
ÎÒÒѾ֪µÀÁË£¡
ÔÚHqlÖÐ ÊDz»ÓÃÕâЩº¯ÊýµÄ£¡
......
code1:½¨±í
create talbe if not exsits disk.t_directories
(
id int(11) not null auto_increment,
user varchar(25) not null,
path varchar(255) not null,
parent_path varchar(255) not null,
dir varchar(20) not null,
create_time datetime not null,
primary key(id),
unique key user (user,p ......