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

mysql ÖÐµÄ autocommit ±äÁ¿

mysql> show variables like "autocommit";
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| autocommit | ON |
+---------------+-------+
1 row in set (0.00 sec)
mysql>
ÉèÖÃÍêÖ®ºó¿´¿´¸ÃÖµ
ÄãÒª¿ªÆôÒ»¸öÊÂÎñ£¬Ö±½Ó·¢ËÍbegin ¡£¡£¡£¡£commit¾Í¿ÉÒÔ£¬ºÎ±ØÒªÈ¥¶¯ÓÃÕâ¸ö²ÎÊý¡£
mysqlµÄºóÃæ°æ±¾Ò»Ö±²»ÌᳫÐÞ¸ÄÕâ¸ö²ÎÊý¡£
postgresqlÉõÖÁÈ¡ÏûÁËÕâ¸ö²ÎÊý£¬ÒòΪËüÈÏΪÊÂÎñ¿ØÖÆÓ¦¸ÃÓɿͻ§¶ËÀ´¾ö¶¨


Ïà¹ØÎĵµ£º

mySQL¼òµ¥´´½¨Êý¾Ý¿â¡¢±í¡¢¸Ä±äÊý¾Ý¿â·¾¶

´´½¨Êý¾Ý¿â£º
mysql>create database test;
Query OK, 1 row affected (0.02 sec)
´´½¨Êý¾Ý¿â±í£º
mysql>use test;
Database changed
´´½¨Êý¾Ý¿â±í£º
myaql>create table user(SID VARCHAR(11), name VARCHAT(6) );
Query OK, 0 rows affected (0.08 sec)
²åÈë¼Ç¼£º
mysql>insert int use ......

mysqlµÄÈýÖÖ°²×°·½Ê½

°²×°µÄOSΪSolaris10,mysql °æ±¾ÊÇ5.1.38
Ò»¡¢Ê¹ÓÃRPM°ü½øÐа²×°

    Ê×ÏÈ¿ÉÒÔ´Ó°²×°¹âÅÌÖлòÕßµ½mysqlµÄÍøÕ¾ÉÏÏÂÔØ¶ÔÓ¦°æ±¾µÄrpm°üÈçÏ£º
MySQL-server-community-5.1.38-0.rhel5.i386.rpm
MySQL-client-community-5.1.38-0.rhel5.i386.rpm
    ½Ó×ÅÎÒÃÇ¿ÉÒÔʹÓÃrpmÃü ......

mysqlÏà¹ØÃüÁî

Ò»¡¢ÊÂÎñ´¦Àí£¨myisamÒýÇæ²»Ö§³ÖÊÂÎñ£¬innodbÒýÇæÖ§³ÖÊÂÎñ£©
£¨1£©start transaction
£¨2£©commit
£¨3£©rollback£¬rollback to [savepoint name]
£¨4£©savepoint [savepoint name]
£¨5£©set autocommit=0 or 1
£¨6£©release savepoint [savepoint name]
×¢Ò⣺create¡¢dropµÈ²Ù×÷£¬²»ÄÜ»ØÍË
¶þ¡¢×Ö·û¼¯
1.×Ö·û±àÂë ......

MYSQLÍâ¼ü(Foreign Key)µÄʹÓÃ

ÔÚMySQL 3.23.44°æ±¾ºó£¬InnoDBÒýÇæÀàÐ͵ıíÖ§³ÖÁËÍâ¼üÔ¼Êø¡£
Íâ¼üµÄʹÓÃÌõ¼þ£º
1.Á½¸ö±í±ØÐëÊÇInnoDB±í£¬MyISAM±íÔÝʱ²»Ö§³ÖÍâ¼ü£¨¾Ý˵ÒÔºóµÄ°æ±¾ÓпÉÄÜÖ§³Ö£¬µ«ÖÁÉÙĿǰ²»Ö§³Ö£©£»
2.Íâ¼üÁбØÐ뽨Á¢ÁËË÷Òý£¬MySQL 4.1.2ÒÔºóµÄ°æ±¾ÔÚ½¨Á¢Íâ¼üʱ»á×Ô¶¯´´½¨Ë÷Òý£¬µ«Èç¹ûÔÚ½ÏÔçµÄ°æ±¾ÔòÐèÒªÏÔʾ½¨Á¢£»
3.Íâ¼ü¹ØÏµµÄÁ½¸ö± ......

jspÁ¬½Ómysql¶ÔÊý¾Ý¿â½øÐвÙ×÷ÂÒÂëµÄ½â¾ö


Èç¹ûjsp²åÈëmysqlÊý¾Ý¿â³öÏÖÂÒÂ룬mysqlÊý¾Ý¿â°²×°Ê±±àÂëÉèΪutf8£¬ÔÚÖ´ÐвåÈëÓï¾äµÄÇ°Ãæ£¨½ô°¤×ÅÖ´ÐÐÓï¾ä£©Ìí¼ÓתÂëÓï¾ä£ºString na="";
                  try{
          &nbs ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ