mysqlÍâ¼üµÄʹÓÃ
ÏñMySQLÕâÑùµÄ¹ØϵÐÍÊý¾Ý¿â¹ÜÀíϵͳ£¬ËüÃǵĻù´¡ÊÇÔÚÊý¾Ý¿âµÄ±íÖ®¼ä´´½¨¹ØϵµÄÄÜÁ¦¡£Í¨¹ý·½±ãµØÔÚ²»Í¬±íÖн¨Á¢¼Ç¼µ½¼Ç¼µÄÁªÏµ£¬RDBMS¿ÉÒÔÀûÓò»Í¬µÄ·½·¨·ÖÎöÊý¾Ý£¬Í¬Ê±±£³ÖÊý¾Ý¿âÒÔϵͳµÄ·½Ê½¡¢×îСµÄÈßÓà½øÐÐ×éÖ¯¡£
¼òµ¥ÃèÊö£º
ÕâЩ¹Øϵ»ù±¾ÉÏÒÀ¿¿Íâ¼ü½øÐйÜÀí£¬ÔÚ¹ØϵÖÐËùÓбíÖоßÓÐÏàͬº¬ÒåµÄ×Ö¶Î×÷Ϊ¹«¹²²¿·ÖÀ´Á¬½Ó²»Í¬±íÖеļǼ¡£Íâ¼ü¿ÉÒÔÊÇÒ»¶ÔÒ»µÄ£¬Ò»¸ö±íµÄ¼Ç¼ֻÄÜÓëÁíÒ»¸ö±íµÄÒ»Ìõ¼Ç¼Á¬½Ó£¬»òÕßÊÇÒ»¶Ô¶àµÄ£¬Ò»¸ö±íµÄ¼Ç¼ÓëÁíÒ»¸ö±íµÄ¶àÌõ¼Ç¼Á¬½Ó¡£
MySQLÖГ¼ü”ºÍ“Ë÷Òý”µÄ¶¨ÒåÏàͬ£¬ ËùÒÔÍâ¼üºÍÖ÷¼üÒ»ÑùÒ²ÊÇË÷ÒýµÄÒ»ÖÖ¡£²»Í¬µÄÊÇMySQL»á×Ô¶¯ÎªËùÓбíµÄÖ÷¼ü½øÐÐË÷Òý£¬µ«ÊÇÍâ¼ü×ֶαØÐëÓÉÓû§½øÐÐÃ÷È·µÄË÷Òý¡£ÕâºÍһЩ·â½¨Ë¼Ïë±È½Ï³ÁÖصļÒÍ¥ÊÇÒ»ÑùµÄ£¬ÍâÀ´µÄº¢×Ó(¶ùϱ¸¾£¬µ¹²åÃÅÅ®Ðö)Ò»°ã¶¼ÊDz»ÊÜÖØÊӵġ£
µÍË×ʾÀý£º
±í¼äÒ»¶ÔÒ»¹ØϵʾÀý£º
ÓÐÁ½ÕÅ±í£¬µÚÒ»ÕűíÊǼǼ¹«Ë¾ÓжàÉÙÈË£¬¶¼ÓÐË£¬Ò²¾ÍÊÇÔ±¹¤±àºÅ¼°Ô±¹¤ÐÕÃûÕâЩ»ù±¾±í¡£ÁíÒ»Õűí¼Ç¼ÿ¸öÔ·¢¸øÓû§¶àÉÙ¹¤×Ê£¬Ëùν¹¤×ʱíÊÇÒ²¡£
µ«Êǹ¤×ʱíÀïÃæ²»ÄÜÒÔÔ±¹¤ÐÕÃûΪÖ÷¼ü£¬Í¬ÑùҪͨ¹ýÔ±¹¤id£¬ÒòΪԱ¹¤µÄÐÕÃûÊÇ¿ÉÄÜÖظ´µÄ°¡¡£²¿ÃžÀí½ÐÕÅÈý£¬Ð¡µÜÒ²½ÐÕÅÈý£¬ÄÇÕâÁ©ÕÅÈýµÄ¹¤×ÊÄÜÒ»ÑùÂ𣿲¢ÇÒÔ±¹¤±íÀïÃæµÄÿ¸öÈ˶¼Óй¤×Ê£¬·ñÔòËÒ²²»¸øÄã¸É»î£¬ÇÒÒ»¸öÈËÖ»ÄÜÓÐÒ»·Ý¹¤×Ê£¬·ñÔòÀÏ°åÒ²²»Í¬ÒâÁË¡£ËùÒÔÔ±¹¤±íºÍ¹¤×ʱíÊÇͨ¹ýÔ±¹¤id½øÐйØÁªµÄÒ»¶ÔÒ»¹Øϵ¡£
²»¹ýÎÒÃÇÒªÓÐÒ»¸öºÃµÄ¼ÛÖµ¹Û£¬ÎÒÃÇÉϰ಻ÄÜΪÁËÇ®£¬ÎÒÃÇÊÇΪÁËѧ֪ʶ£¬Ñ§ÎÄ»¯£¬ÎªÔçÈÕʵÏÖËĸöÏÖ´ú»¯(±ðÎÊÎÒÊÇɶ£¬Ò²±ðÎÊÎÒµ½µ×ʵÏÖûÓÐ)¶øŬÁ¦·Ü¶·¡£ËùÒÔÔÚ¹¤×ʱíÀïÈç¹ûûÓÐÄãÒ²²»ÒªÂÒº°¡£àÅ¡£
/*
½¨Á¢Ô±¹¤±í
*/
create table employees (
id int(5) not null auto_increment ,
name varchar(8) not null,
primary key (id)
)
type£½innodb;
/*
½¨Á¢¹¤×ʱí
*/
create table payroll(
id int(5) not null,
emp_id int(5) not null,
name varchar(8) not null,
payroll float(4,2) not null,
primary key(id),
index emp_id (emp_id),
foreign key (emp_id) references employees (id)
)
type = innodb;
±í¼äÒ»¶Ô¶à¹ØϵʾÀý£º
ÓÐÁ½¸ö±í£¬Ò»¸öÊÇÌ°¹Ù±í£¬ÓÐÌ°¹ÙµÄidºÍÃû×Ö¡£ÁíÓÐÒ»ÕÅÌ°¹ÙÇ鸾±í£¬×¢ÒâÒ»¸öÌ°¹Ù²»Ò»¶¨Ö»ÓÐÒ»¸öÇ鸾£¬ÆäÓиö¶þÈýËÄÎåÄÌÊǺÜÕý³£µÄ£¬ËùÒÔÔÚÌ°¹Ù±íÀïÃæµÄÒ»ÌõÊý¾Ý£¬¶ÔÓ¦Ç鸾±íÀï¿ÉÄܾÍÓжàÌõ¼Ç¼£¬ÕâÊÇͨ¹ýÌ°¹Ùid½øÐйØÁªµÄÒ»¶Ô¶à¹Øϵ¡£
²ÎÕÕÍêÕûÐÔ
Ïà¹ØÎĵµ£º
ÓÅ»¯MySQL·þÎñÆ÷µÄÅäÖòÎÊý£¬¿ÉÒÔÌá¸ßMySQLÊý¾Ý¿âµÄÐÔÄÜ£¬µ«ÊǶÔÓÚÅäÖýϵ͵ķþÎñÆ÷À´Ëµ£¬ÄãÎÞÂÛÔõôÓÅ»¯ÅäÖ㬶¼²»»áµÃµ½ÀíÏëµÄЧ¹û£¬ÄǾÍÖ»ÄÜÌá¸ßÄãÓ²¼þÅäÖã¬À´³¹µ×ÓÐЧµØ¸ÄÉÆ·þÎñÆ÷µÄÐÔÄÜ¡£
¾ßÌåµÄ·½·¨ÈçÏ£º
Ò»¡¢ÔÚÉèÖÃMySQL ʱ£¬Ó¦¸ÃÅäÖÃÆäʹÓþ²Ì¬¿â¶ø²»Êǹ²Ïí¿â¡£Ê¹Óù²Ïí¿âµÄ¶¯Ì¬¶þ½øÖÆϵͳ¿É½ÚÊ¡´ÅÅ̿ռ䣬µ«¾² ......
1.Ç°ÃæһƪÎÄÕÂÏêϸ½éÉÜÁËÈçºÎÔÚWindowsÏÂÕûºÏapache+mysql+php+tomcat,ºÜ¼òµ¥£¬µ«ÊÇÔÚLinuxϾÍûÕâôÈÝÒ×ÁË£¬ÐèÒªÊÖ¹¤µÄȥдÅäÖÃÎļþ£¬ÍøÉϵÄ×ÊÁÏÓкܶ࣬µ«ÊÇÎÒ¸ù¾ÝËûÃǵÄд·¨£¬Ò»²½Ò»²½µÄÅäÖû¹ÊÇûÄÜsuccess!£¨¿ÉÄÜÊÇÎÒ¸öÈ˵ÄÔÒò£¬²»¹ý£¬ÎÞÂÛÔÚGoogle»¹ÊÇbaiduËѵ½µÄÎÄÕ¾ÍÄÇô¼¸Æª£¬Õâ¸öתһÏ£¬ÄǸöתһÏ£¬×îºó¶¼² ......
жÔØMysql
[root@localhost ~]# rpm -qa | grep mysql
mysql-3.23.58-9
php-mysql-4.3.4-11
mod_auth_mysql-20030510-4.1
mysql-server-3.23.58-9
˵Ã÷£ºrpm –qa | grep mysql ÃüÁîÊÇΪÁË°ÑmysqlÏà¹ØµÄ°ü¶¼ÁгöÀ´£¬Ð¶Ôض¼´Ó×îÏÂÃæµÄÒ»¸ö°ü¿ªÊ¼£¬Ö±µ½Ð¶ÔصôµÚÒ»¸öΪֹ¡£Ö´ÐÐrpm -q php£¬Èç¹û·µ»Øphp°æ±¾£¬ ......
·µ»ØÒ»¸ö½á¹ûÈ«ÊÀ½ç¶¼ÖªµÀÔõô´¦Àí£¬¹Ø¼üÊÇ·µ»Ø¶à¸ö½á¹û¼¯¾Í²»ºÃ°ìÁË£¬ÏÂÃæÓÐÒ»½â¾ö°ì·¨
´æ´¢¹ý³Ì´úÂë
DELIMITER $$;
DROP PROCEDURE IF EXISTS `test`.`sp_test`$$
CREATE PROCEDURE `test`.`sp_test` ()
BEGIN
select * from `user`.`user` limit 0, 50;
select coun ......
Ê×ÏÈ·ÅÖúÃjdbcÇý¶¯³ÌÐò£¬ÔÚ java\jre6\lib\ext\Ï£¬java\jdk1.6\jre\libµÈµØ·½¶¼·ÅÆðÀ´£¬ÒòΪ²»È·¶¨ÔÚÄÄÀïÓÐÓ÷··
Class.forName("com.mysql.jdbc.Driver").newInstance();
String url = "jdbc:mysql://localhost/DATABASENAME?user=USERNAME&password=PASSWORD&useUnicode=tru ......