mysql»ù´¡ÖªÊ¶
1. MySQLÊÇÒ»¸öСÐ͹ØÏµÐÍÊý¾Ý¿â¹ÜÀíϵͳ
2. MySQLµÄÊý¾ÝÀàÐÍ£º
ÕûÊýÐÍ£ºTINYINT£¬SMALLINT£¬INT£¬BIGINT
СÊýÐÍ£ºFLOAT£¬DOUBLE£¬DECIMAL(M,D)
×Ö·ûÐÍ£ºCHAR£¬VARCHAR
ÈÕÆÚÐÍ£ºDATETIME £¬DATE£¬TIMESTAMP
±¸×¢ÐÍ£ºTINYTEXT £¬TEXT £¬LONGTEXT
£¨°´php100µÄ½Ì³ÌÀï·ÖµÄ£©
3.MySQLµÄ»ù±¾Óï¾ä
´´½¨Êý¾Ý¿â CREATE DATABASE Êý¾Ý¿âÃû
ɾ³ýÊý¾Ý¿â DIOP DATABASE Êý¾Ý¿âÃû
´´½¨Êý¾Ý±í CREATE TABLE ±íÃû
ɾ³ýÊý¾Ý±í DROP TABLE ±íÃû
ÐÞ¸ÄÒ»¸ö×Ö¶ÎÃû³Æ RENAME TABLE `Ô×Ö¶ÎÃû`TO`ÐÂ×Ö¶ÎÃû`;
ɾ³ýÒ»¸ö×Ö¶Î ALTER TABLE `±í`DROP`Ô×Ö¶Î`;
²åÈëÒ»¸ö×Ö¶Î ALTER TABLE `±í`ADD`ÐÂ×Ö¶Î`...AFTER`Ô×Ö¶Î`;
4.²éѯÓï¾ä ²åÈëÓï¾ä ¸üÐÂÓï¾ä ɾ³ýÓï¾ä
²éѯÓï¾ä
SELECT ²éѯ×Ö¶Î from ±íÃû WHERE Ìõ¼þ
²éѯ×ֶΣº¿ÉÒÔʹÓÃͨÅä·û* ¡¢×Ö¶ÎÃû¡¢×ֶαðÃû
±íÃû£ºÊý¾Ý¿â.±íÃû£¬±íÃû
³£ÓÃÌõ¼þ£º = µÈÓÚ¡¢<>²»µÈÓÚ¡¢in °üº¬¡¢ not in ²»°üº¬¡¢ like Æ¥Åä
BETWEENÔÚ·¶Î§¡¢ not BETWEEN²»ÔÚ·¶Î§< ¡¢>
Ìõ¼þÔËË㣺 and ¡¢ or ¡¢ ( )
²åÈëÓï¾ä
insert into ±íÃû (×Ö¶Î…,…) values(Öµ…,…)
¸üÐÂÓï¾ä
UPDATE ±íÃû SET ×Ö¶Î=Öµ WHERE Ìõ¼þ limit
³£ÓÃÌõ¼þ£º = µÈÓÚ¡¢<>²»µÈÓÚ¡¢in °üº¬¡¢ not in ²»°üº¬¡¢ like Æ¥Åä
BETWEENÔÚ·¶Î§¡¢ not BETWEEN ²»ÔÚ·¶Î§
ɾ³ýÓï¾ä
DELETE from ±íÃû WHERE Ìõ¼þ limit
³£ÓÃÌõ¼þ£º = µÈÓÚ¡¢<>²»µÈÓÚ¡¢in °üº¬¡¢ not in ²»°üº¬¡¢ like Æ¥Åä
BETWEENÔÚ·¶Î§¡¢ not BETWEEN ²»ÔÚ·¶Î§
Ïà¹ØÎĵµ£º
1.´´½¨Ò»¸öjava projectÏîÄ¿pooling
2.ΪÏîÄ¿Ìí¼ÓMySQLÁ¬½ÓÇý¶¯
3.ΪÏîÄ¿Ìí¼ÓÒ»¸öÅäÖÃÎļþdbpool.proprerties
Code
driverClassName=com.mysql.jdbc.Driver
username=root
password=
url=jdbc:mysql://localhost:3306/work
poolSize=10
4.·Ö±ð´´½¨Ò»¸öÁ¬½ÓÀàConnectionPool.javaºÍÒ»¸ö²âÊÔÀàConnectionPoo ......
·Ò룺
InnoDB±í»á°üº¬Ò»¸ö¾Û¼¯Ë÷Òý£¨Êý¾Ý±íµÄÎïÀí´æ´¢Ë³ÐòºÍ±íµÄÂß¼´æ´¢Ë³ÐòÒ»Ö£©
Ò»°ãÊǰ´ÕÕÏÂÃæµÄ¹æÔòÀ´É趨¾Û¼¯Ë÷ÒýµÄ£º
1£¬¼ÙÈç±í°üº¬PRIMARY KEY£¬InnoDBʹÓÃËü×÷Ϊ¾Û¼¯Ë÷Òý
2£¬¼ÙÈç±íûÓж¨ÒåPRIMARY KEY£¬InnoDB½«µÚÒ»¸öÖ»°üº¬NOT NULLÊôÐÔÁеÄUNIQUE index×÷ΪÖ÷¼ü²¢ÇÒ½«ËüÉèÖÃΪ¾Û¼¯Ë÷Òý
3£¬Ç°Á½Õß¶¼²»Âú× ......
TINYINT 1 ×Ö½Ú
SMALLINT 2 ¸ö×Ö½Ú
MEDIUMINT 3 ¸ö×Ö½Ú
INT 4 ¸ö×Ö½Ú
INTEGER 4 ¸ö×Ö½Ú
BIGINT 8 ¸ö×Ö½Ú
FLOAT(X) 4 Èç¹û X < = 24 »ò 8 Èç¹û 25 < = X < = 53
FLOAT 4 ¸ö×Ö½Ú
DOUBLE 8 ¸ö×Ö½Ú
DOUBLE PRECISION 8 ¸ö×Ö½Ú
REAL 8 ¸ö×Ö½Ú
DECIMAL(M,D) M×Ö½Ú(D+2 , Èç¹ûM < D)
NUMERIC(M,D) M×Ö½Ú(D ......
conn.php
<?php
/*
* Created on 2010-1-6
* Author:CHAUVET
* Function:Á¬½Ó×Ö·û´®
*/
$conn=@mysql_connect("localhost","root","")or die("Á¬½ÓÊý¾Ý¿â³ö´í£¡");
mysql_select_db("newdb",$conn);
mysql_query("set names 'gb2312'");
function ReplaceSom ......