MySQLÁÙʱ±í½¨Á¢
MySQL½¨Á¢ÁÙʱ±íµÄÓï¾äÈçÏÂ:
CREATE TEMPORARY TABLE tmp (
article INT(4) UNSIGNED ZEROFILL DEFAULT '0000' NOT NULL,
price DOUBLE(16,2) DEFAULT '0.00' NOT NULL);
--LOCK TABLES article read;
--ÏȲåÈëÊý¾Ýµ½ÁÙʱ±í
INSERT INTO tmp SELECT article, MAX(price) from shop GROUP BY article;
--²éѯÁÙʱ±íÊý¾Ý
SELECT article, dealer, price from shop, tmpWHERE shop.article=tmp.articel AND shop.price=tmp.price;
--UNLOCK TABLES;
DROP TABLE tmp;
Ïà¹ØÎĵµ£º
ÔÚ
oracle
ÖУ¬
sequence
Ìṩ¶à±í¶à×ֶοɹ²ÓÃÒ»¸ö²»Öظ´Öµ¡£
Mysql
ÖдæÔÚ×ÔÔöÁУ¬»ù±¾¿ÉÒÔÂú×ã
PK
µÄÒªÇó¡£µ«×ÔÔöÁдæÔÚÏÞÖÆ£º
a.
Ö»ÄÜÓÃÓÚ±íÖеÄÒ»¸ö×ֶΣ¬Ò»ÕŲ»ÄÜͬʱ´æÔÚÁ½¸öÒÔÉϵÄ×ÔÔöÁÐ
;
b.
×ÔÔöÁбØÐë±»¶¨ÒåΪ
key
£¨
PK
»ò
FK
£©
;
c.
×ÔÔöÁв»Äܱ»¶à¸ö±í¹²ÓÃ
;
d.
µ±
insert
Óï¾ä² ......
tomcat+jdk+mysqlÃâ°²×°µÄÕûºÏÐÎʽ
Ò»£º tomcat+jdk Ãâ°²×°
ºÜ¾ÃÒÔÇ°¾Í¿ªÊ¼Óà tomcat µÄÃâ°²×°°æ(zip ½âѹ°æ)¡£Ö±½ÓÔËÐÐ bin/startup.bat µÄ·½Ê½ÔËÐУ¬ÓÐÒ»¸ö²»ºÃµÄµØ·½¾ÍÊÇ×¢ÏúµÇ¼Óû§³ÌÐò¾ÍÍ˳öÁË¡£±ÈÈç windows 2003 server °æÖÐÔËÐÐ tomcat ÒÔÌṩ¶ÔÍâ·þÎñ£¬ºÜ¿ÉÄܹÜÀíÔ±Æô¶¯ÁË tomcat ºó¾ÍÍ˳ö windows 200 ......
Ò» UNIONÓï·¨
´úÂë ¸´ÖÆ´úÂë
SELECT ...
UNION [ALL | DISTINCT]
SELECT ...
[UNION [ALL | DISTINCT]
SELECT ...]
SELECT ... UNION [ALL | DISTINCT] SELECT ... [UNION [ALL | DISTINCT] SELECT ...]
UNIONÓÃÓÚ°Ñ ......
ÎÒ¾¹ýÕ⼸ÌìÑо¿·¢ÏÖmod_perlÌṩµÄ³ÖÐøÁ¬½Ó²¢²»ÖÇÄÜ£¨Ò²ÐíÊÇÎÒ»¹Ã»ÓÐÕÒµ½¸ü
ºÃµÄ½â¾ö·½°¸£©£¬Èç¹û½Å±¾ÖеIJÎÊýºÍ³õʼ»¯µÄ²ÎÊý²»Ò»Ñù£¬ÔÚÄÚ´æÖлá³öÏÖÁ½¸ö
¾ä±ú¡£
Apache::DBI->connect_on_init("DBI:mysql:mysql:localhost","root","root",
{
PrintError => 1,
RaiseError => 0,
AutoCommit => ......
show tables»òshow tables from database_name;
½âÊÍ£ºÏÔʾµ±Ç°Êý¾Ý¿âÖÐËùÓбíµÄÃû³Æ
show databases;
½âÊÍ£ºÏÔʾmysqlÖÐËùÓÐÊý¾Ý¿âµÄÃû³Æ
show processlist;
½âÊÍ£ºÏÔʾϵͳÖÐÕýÔÚÔËÐеÄËùÓнø³Ì£¬Ò²¾ÍÊǵ±Ç°ÕýÔÚÖ´ÐеIJéѯ¡£´ó¶àÊýÓû§¿ÉÒԲ鿴
ËûÃÇ×Ô¼ºµÄ½ø³Ì£¬µ«ÊÇÈç¹ûËûÃÇÓµÓÐprocessȨÏÞ£¬¾Í¿ÉÒԲ鿴ËùÓÐÈ˵Ľø ......