mysql »ù´¡
Ò» . °²×°ÓëÅäÖÃMYSQL
¶þ . ³£ÓÃmysqlÃüÁîÐÐÃüÁî
1 .mysqlµÄÆô¶¯ÓëÍ£Ö¹
Æô¶¯MYSQL·þÎñ net start mysql
Í£Ö¹MYSQL·þÎñ net stop mysql
2 . netstat –na | findstr 3306 ²é¿´±»¼àÌýµÄ¶Ë¿Ú , findstrÓÃÓÚ²éÕÒºóÃæµÄ¶Ë¿ÚÊÇ·ñ´æÔÚ
3 . ÔÚÃüÁîÐÐÖеǽMYSQL¿ØÖÆÌ¨ , ¼´Ê¹Óà MYSQL COMMEND LINE TOOL
Óï·¨¸ñʽ mysql –user=root –password=123456 db_name
»ò mysql –u root –p123456 db_name
4 . ½øÈëMYSQLÃüÁîÐй¤¾ßºó , ʹÓÃstatus; »ò\s ²é¿´ÔËÐл·¾³ÐÅÏ¢
5 . Çл»Á¬½ÓÊý¾Ý¿âµÄÓï·¨ : use new_dbname;
6 . ÏÔʾËùÓÐÊý¾Ý¿â : show databases;
7 . ÏÔʾÊý¾Ý¿âÖеÄËùÓбí : show tables;
8 . ÏÔʾij¸ö±í´´½¨Ê±µÄÈ«²¿ÐÅÏ¢ : show create table table_name;
9 . ²é¿´±íµÄ¾ßÌåÊôÐÔÐÅÏ¢¼°±íÖи÷×ֶεÄÃèÊö
Describe table_name; ËõдÐÎʽ : desc table_name;
Èý ¡£ MySqlÖеÄSQLÓï¾ä
1 . Êý¾Ý¿â´´½¨ : Create database db_name;
Êý¾Ý¿âɾ³ý : Drop database db_name; ɾ³ýʱ¿ÉÏÈÅжÏÊÇ·ñ´æÔÚ£¬Ð´³É : drop database if exits db_name
2 . ½¨±í : ´´½¨Êý¾Ý±íµÄÓï·¨ : create table table_name (×Ö¶Î1 Êý¾ÝÀàÐÍ , ×Ö¶Î2 Êý¾ÝÀàÐÍ);
Àý : create table mytable (id int , username char(20));
ɾ±í : drop table table_name; Àý : drop table mytable;
8 . Ìí¼ÓÊý¾Ý : Insert into ±íÃû [(×Ö¶Î1 , ×Ö¶Î2 , ….)] values (Öµ1 , Öµ2 , …..);
Èç¹ûÏò±íÖеÄÿ¸ö×ֶζ¼²åÈëÒ»¸öÖµ,ÄÇÃ´Ç°Ãæ [ ] À¨ºÅÄÚ×Ö¶ÎÃû¿ÉдҲ¿É²»Ð´
Àý : insert into mytable (id,username) values (1,’zhangsan’);
9 . ²éѯ : ²éѯËùÓÐÊý¾Ý : select * from table_name;
²éѯָ¶¨×ֶεÄÊý¾Ý : select ×Ö¶Î1 , ×Ö¶Î2 from table_name;
Àý : select id,username from mytable where id=1 order by desc;¶à±í²éѯÓï¾ä------------²ÎÕÕµÚ17ÌõʵÀý
10 . ¸üÐÂÖ¸¶¨Êý¾Ý , ¸üÐÂijһ¸ö×ֶεÄÊý¾Ý£¨×¢Ò⣬²»ÊǸüÐÂ×ֶεÄÃû×Ö£©
Update table_name set ×Ö¶ÎÃû=’ÐÂÖµ’ [, ×Ö¶Î2 =’ÐÂÖµ’ , …..][where id=id_num] [order by ×ֶΠ˳Ðò]
Àý : update mytable set username=’lisi’ where id=1;
OrderÓï¾äÊDzéѯµÄ˳Ðò , Èç : order by id desc(»òasc) , ˳ÐòÓÐÁ½ÖÖ : de
Ïà¹ØÎĵµ£º
MySQLÓжàÖÖ´æ´¢ÒýÇæ£º
MyISAM¡¢InnoDB¡¢MERGE¡¢MEMORY(HEAP)¡¢BDB(BerkeleyDB)¡¢EXAMPLE¡¢FEDERATED¡¢ARCHIVE¡¢CSV¡¢BLACKHOLE¡£
MySQLÖ§³ÖÊý¸ö´æ´¢ÒýÇæ×÷Ϊ¶Ô²»Í¬±íµÄÀàÐ͵Ĵ¦ÀíÆ÷¡£MySQL´æ´¢ÒýÇæ°üÀ¨´¦ÀíÊÂÎñ°²È«±íµÄÒýÇæºÍ´¦Àí·ÇÊÂÎñ°²È«±íµÄÒýÇæ£º
¡ô MyISAM¹ÜÀí·ÇÊÂÎñ±í¡£ËüÌṩ¸ßËÙ´æ´¢ºÍ¼ìË÷£¬ÒÔ¼°È«ÎÄËÑË÷ÄÜÁ¦¡ ......
package com.wxpn.tutorial.db;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.SQLWarning;
import java.sql.Statement;
import java.util.Date;
/**
* ÃèÊö: Êý¾Ý¿âÁ¬½Ó³ØÀà
*
*
&n ......
ÍøÕ¾µÄÊý¾Ý¿âÊǵ÷ÓÃÔ¶³Ì·þÎñÆ÷ÉϵÄ,²»ÊDZ¾»úµÄ.ÍøÕ¾´ò¿ª±È½ÏÂý.ÔÚÍøÉÏËÑË÷ÁË·½·¨,Õâ¸ö·½·¨¿ÉÒÔ½â¾ö,µ«ÊÇÓÐÁíÍâµÄÎÊÌâ³öÏÖ:
-----------------------------------------------------------------------
ÔÚ¾ÖÓòÍøÄÚÁ¬½ÓÆäËû»úÆ÷µÄMYSQL,·¢ÏÖËÙ¶ÈÂýµÄºÜ,²»ÖªµÀʲôÔÒò,×ÜÓм¸ÃëµÄÑÓ³Ù.
ºóÀ´ÔÚÍøÉÏ·¢ÏÖ½â¾ö·½·¨,my.iniÀïÃæÌ ......
°²×°JDBCÇý¶¯£º
½âѹËõmysql-connector-java-3.1.10.zip
½«ÒªÊ¹ÓõÄÊÇmysql-connector-java-3.1.10-bin-g.jarºÍmysql-connector-java-3.1.10-bin.jar
ÅäÖÃ
ÔÚC:\Program Files\JavaĿ¼Ï½¨Á¢mysqlforjdbc×ÓĿ¼£¬½øÈë¸ÃĿ¼½«mysql-connector-java-3.1.10-bin.jarµ½¸ÃĿ¼ÏÂ
½øÈëC:\Program Files\Java\jdk1.5.0_04\l ......
Ò»¡¢°²×°JDK ¡¡¡¡Ê×ÏÈÏÂÔØJDK 5.0£¨JDK 5.0µÄÏÂÔØÒ³ÃæÎª£ºhttp://java.sun.com/j2se/1.5.0/download.jsp£©£» È»ºóÔËÐÐJDK 5.0°²×°³ÌÐòjdk-1_5_0_06-windows-i586-p.exe£¬°²×°¹ý³ÌÖÐËùÓÐÑ¡Ïî±£³ÖĬÈÏ£»×îºóÅäÖÃJDKµÄ»·¾³±äÁ¿£ºÔÚ“ÎҵĵçÄÔ”ÉϵãÓÒ¼ü—>“ÊôÐÔ”—>“¸ß¼¶”& ......