Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

mysqlÁªºÏÖ÷¼ü - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql

ÇëÎÊÒ»ÏÂÊDz»ÊǰÑÁ½¸ö×Ö¶ÎÉèΪÁªºÏÖ÷¼ü ÔÚ²åÈëÊý¾Ýʱ¾Í²»¿ÉÒÔ²åÈëÖØ¸´µÄÊý¾Ý¡£¶ÔÂð£¿

ÎÒÒª½¨Ò»¸ö±í
 ×Ö¶ÎÓÐ id current_user_id user_id content_id

ÇëÎÊÈçºÎÉè¼Æ±í½á¹¹ÄÜʹuser_idºÍcontent_id×ֶβ»³öÏÖÖØ¸´µÄÊý¾Ý¡£

ÇëÖ¸½Ì£¡

¹ØÓÚcreate table µÄÓ﷨˵Ã÷ºÍÖ÷¼ü£¬UNIQUEË÷ÒýµÈ´´½¨£¬Çë²Î¿¼MYSQL¹Ù·½Êֲᡣ

MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc/refman/5.1/zh/index.html

SQL code:
create table tbs
(
id int,
current_user_id int,
`user_id` int,
content_id int,
unique (`user_id`,content_id)
);


Ò²¿ÉÒÔͨ¹ýÓÃUNIQUEÔ¼Êø½øÐÐΨһÐÔµÄÔ¼Êø
µ±È»Ö÷¼üÒ²ÊÇ¿ÉÒÔµÄ

ÕâÑùÉè¼Æ£¬¿ÉÒÔ£¡

SQL code:
create table tbs
(
id int,
current_user_id int,
`user_id` int,
content_id int,
primary key(id),
unique (`user_id`,content_id)
);



лл¥Éϵļ¸Î»´ó¸ç£¡ÇëÎÊÒª°ÑÊý¾Ý½á¹¹Ð´ÔÚJavaµÄʵÌåÀàÀïÓ¦¸ÃÔõôд°¡£¿

ÒýÓÃÇëÎÊÒª°ÑÊý¾Ý½á¹¹Ð´ÔÚJavaµÄʵÌåÀàÀïÓ¦¸ÃÔõôд°¡£¿
javaµÄÎÊÌ⽨Òéµ½ java°æ¿éÈ¥ÎÊһϡ£


Ïà¹ØÎÊ´ð£º

netbeans Á¬mysql - Web ¿ª·¢ / HTML(CSS)

ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ
javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test
ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......

mysqlÊý¾Ý¿â - Java / JavaÏà¹Ø

CREATE DATABASE ADDRESSLIST;
USE ADDRESSLIST;
DROP TABLE IF EXISTS FRIEND;
CREATE TABLE FRIEND
  (FRIEND_ID INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY ,
FRIEND_NAME VARCHAR(20) NOT N ......

mysqlÁ¬½ÓÎÊÌâ - VB / Êý¾Ý¿â(°üº¬´òÓ¡£¬°²×°£¬±¨±í)

×î½ü³öÏÖÒ»¸öºÜÆæ¹ÖµÄÎÊÌ⣬ÓÃADOÁ¬½ÓMYSQL£¬½«Á¬½ÓOPENµÄʱºò£¬Èç¹ûMYSQLÆô¶¯Ê±¾ÍÁ¬½Ó´íÎó£¬Í¬Ê±×Ô¶¯¹Ø±ÕMYSQL·þÎñ£»ÈôMYSQLûÓÐÆô¶¯¾Í¿ÉÒÔÕý³£OPEN¡£
Ò²¾ÍÊÇÿÁ½´ÎÔËÐбØÈ»»á³ö´íÒ»´Î£¬µ«Ã¿Á½´ÎÔËÐÐÒ²±ØÈ»³É¹¦Ò»´ ......

PHP+MYSQLÊý¾Ý¼¯´¦Àí - PHP / »ù´¡±à³Ì

1¡¢ÊDz»ÊÇPHPÖÐÖ»ÄÜʹÓÃmysql_query("update user_aa set money=money2-".$bpanmm." where uid=".$userppp);¸üÐÂÊý¾Ý£¿£¿£¿
2¡¢PHP¸üÐÂmysql_fetch_row($res)Óëmysql_fetch_array($res)ÖеÄÊý¾ ......

mysqlÇøÃ»¸ßÊÖ - MS-SQL Server / »ù´¡Àà

ÎÒ¾õµÃmysqlºÍsqlserverÓй²Í¬µÄµØ·½£º
ÓиöÎÊÌâÊǹØÓÚ±íµÄËøÎÊÌ⣺
½ø³ÌA ½ø³ÌB
select * from user where id in lock share mode£¨¹²ÏíËø)
&nb ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ