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

MySQLѧϰ±Ê¼Ç

Ò»¡¢MySQL»ù±¾ÃüÁºÏ£º
1¡¢  create database mydata£»//´´½¨Êý¾Ý¿â
2¡¢  use mydata; //ÔÚmydataÕâ¸öÊý¾Ý¿âϹ¤×÷
3¡¢  create table dept    //ÔÚmydataÊý¾Ý¿âÏ´´½¨±ídept
(
deptno int primary key,
dname varchar(14),
loc varchar(13)
);
 
create table emp  //ÔÚmydataÊý¾Ý¿âÏ´´½¨±íemp
(
empno int primary key,
ename varchar(10),
job varchar(10),
mar int,
hiredate datetime,
sal double,
comm double,
deptno int,
foreign key (deptno) references dept(deptno)
);
4¡¢  show databases£»//ÏÔʾÊý¾Ý¿â
5¡¢  show tables£»//ÏÔʾ±í
6¡¢  desc dept£»//ÏÔʾdept±íµÄ½á¹¹
7¡¢  insert into dept values£¨10, ‘A’, ‘A’£©£»//Ïòdept±íÖÐÌí¼Ó¼Ç¼
   insert into dept values£¨20, ‘B’, ‘B’£©£»
   insert into dept values£¨30, ‘C’, ‘C’£©£»
   commit£» //Ìá½»
8¡¢  select * from dept£»//²éѯ¼Ç¼
select * from dept order by deptno desc limit 3,2£»//ÏÔʾ¼Ç¼
¶þ¡¢MySQLµÄ×Ô¶¯µÝÔö£º
create  table article          //´´½¨×Ô¶¯µÝÔö±í
(
Id int primary key auto_increment,
Title varchar(255)
);
Insert into article values(null,’a’);
Insert into article values(null,’b’);
Insert into article(title) values(‘c’);
Èý¡¢MySQLµÄÈÕÆÚʱ¼ä£º
1¡¢  select now£¨£©£»//ÏÔʾµ±Ç°Ê±¼ä
2¡¢  select date_format(now( ),’%y-%m-%d  %H£º%i£º%s’)£»//ÏÔʾָ¶¨¸ñʽµÄʱ¼ä
ËÄ¡¢MySQL_jdbcÁ¬½Ó£º
import java.sql.*;
public class TestMysqlConnection {
    public static void main(String[] args) {
       Connection conn = null;
       Statement stmt = null;
       ResultSet rs = null;
       try {
           Class.forName("com.mysql.jdbc.Driver");
 &nb


Ïà¹ØÎĵµ£º

MySQLÓÅ»¯

MySQLÓÅ»¯
ͬʱÔÚÏß·ÃÎÊÁ¿¼ÌÐøÔö´ó£¬¶ÔÓÚ1GÄÚ´æµÄ·þÎñÆ÷Ã÷ÏԸоõµ½³ÔÁ¦ÑÏÖØÊ±ÉõÖÁÿÌì¶¼»áËÀ»ú£¬»òÕßʱ²»Ê±µÄ·þÎñÆ÷¿¨Ò»Ï£¬Õâ¸öÎÊÌâÔø¾­À§ÈÅÁËÎÒ°ë¸ö¶àÔ¡£MySQLʹÓÃÊǺܾßÉìËõÐÔµÄËã·¨£¬Òò´ËÄãͨ³£ÄÜÓúÜÉÙµÄÄÚ´æÔËÐлò¸øMySQL¸ü¶àµÄ±»´æÒԵõ½¸üºÃµÄÐÔÄÜ¡£
°²×°ºÃmysqlºó£¬ÅäÖÆÎļþÓ¦¸ÃÔÚ/usr/local/mysql/share/mysql ......

Mysql´æ´¢¹ý³Ì£¨ËÄ£©——Òì³£´¦Àí

ÓÐʱºò£¬²»Ï£Íû´æ´¢¹ý³ÌÅ׳ö´íÎóÖÐÖ¹Ö´ÐУ¬¶øÊÇÏ£Íû·µ»ØÒ»¸ö´íÎóÂë¡£
Mysql
Ö§³ÖÒì³£´¦Àí£¬Í¨¹ý¶¨Òå
CONTINUE/EXIT
Òì³£´¦ÀíµÄ
HANDLER
À´²¶»ñ
SQLWARNING/NOT FOUND/SQLEXCEPTION
£¨¾¯¸æ
/
ÎÞÊý¾Ý
/
ÆäËûÒì³££©¡£ÆäÖУ¬
FOR
ºóÃæ¿ÉÒÔ¸ÄΪ
SQLWARNING,
NOT FOUND, SQLEXCEPTION
À´Ö¸Ê¾ËùÓÐÒì³£¶¼´¦Àí£¬Ïൠ......

LinuxÏÂMySQL5.1µÄ°²×°

×î½üÏëÔÚ·þÎñÆ÷ÉÏÊÔÊÔMySQL5.1µÄ·ÖÇø£¬ÓÚÊǾÍÏë×Å×°¸öMySQL5.1£¬¾­¹ýÍ´¿àµÄÒ»¶Î¾­Àúºó£¬ÖÕÓÚÕÒ¸öÏÂÃæ×°¸öºÜºÃµÄ½Ì³Ì£¬ÌûÉÏÀ´±¸Íü¡£
1¡¢MySQLÃâ°²×°°æ/¶þ½øÖưæÈí¼þ£¬²»ÓñàÒ룬ÏÂÔØµØÖ·£º
     http://dev.mysql.com/downloads/
     Îļþ¸ñʽ£ºMYSQL-VERSION-OS.tar.gz
2¡¢´ ......

EMS SQL Manager for Mysql°ïÁËÎ񵀾£¬²¿·ÖÁеIJÙ×÷

 
ÓÉÓÚµ±³õ±íÉè¼ÆµÄ²»ºÏÀí£¬ÂýÂýµÄ·¢ÏÖÀË·ÑÐí¶à¿Õ¼ä£¬ÇÒ¶ÔÀ©Õ¹²»Àû¡£¾ö¶¨²»°ÑͬÀàÐÍÄÚÈݲ¢ÅÅÁб£´æ£¬ËùÒÔ½ñÌì°Ñ¶àÓàµÄÁмôµô£¬²¹ÔÚ±£ÁôµÄÁÐÏÂÃæ¡£
 
 
 
ÔÚ±íÃûµãÓÒ¼ü£¬Êý¾Ý²Ù×÷£¬µ¼³öSQL½Å±¾Êý¾Ý¡£ÕÕÌáʾ²Ù×÷£¬ÕâÀïÎÒϲ»¶µÄÊÇ¿ÉÒÔÖ¸¶¨Áе¼³ö¡£
 
È»ºó°Ñ²»ÐèÒªµÄ¿ÕÁÐɾµô£¬¸ÄһϲåÈëµÄÁÐ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ