ÀûÓÃMySQLµÄÒ»¸öÌØÐÔʵÏÖMySQL²éѯ½á¹ûµÄ·ÖÒ³ÏÔʾ
ÔÚmysqlÖÐÀûÓÃselectÓï¾äµÄÒ»¸öÌØÐԾͿÉÒԺܷ½±ãµØÊµÏÖ²éѯ½á¹ûµÄ·ÖÒ³£¬selectÓï¾äµÄÓï·¨£º
SELECT [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [HIGH_PRIORITY]
[DISTINCT | DISTINCTROW | ALL]
select_expression,...
[INTO OUTFILE 'file_name' export_options]
[from table_references
[WHERE where_definition]
[GROUP BY col_name,...]
[HAVING where_definition]
[ORDER BY {unsigned_integer | col_name | formula} [ASC | DESC] ,...]
[LIMIT [offset,] rows]
[PROCEDURE procedure_name] ]
LIMIT×Ó¾ä¿ÉÒÔÓÃÀ´ÏÞÖÆÓÉSELECTÓï¾ä·µ»Ø¹ýÀ´µÄÊý¾ÝÊýÁ¿£¬ËüÓÐÒ»¸ö»òÁ½¸ö²ÎÊý£¬Èç¹û¸ø³öÁ½¸ö²ÎÊý£¬
µÚÒ»¸ö²ÎÊýÖ¸¶¨·µ»ØµÄµÚÒ»ÐÐÔÚËùÓÐÊý¾ÝÖеÄλÖ㬴Ó0¿ªÊ¼£¨×¢Òâ²»ÊÇ1£©£¬µÚ¶þ¸ö²ÎÊýÖ¸¶¨×î¶à·µ»ØÐÐ
Êý¡£ÀýÈ磺
select * from table LIMIT 5,10; #·µ»ØµÚ6-15ÐÐÊý¾Ý
select * from table LIMIT 5; #·µ»ØÇ°5ÐÐ
select * from table LIMIT 0,5; #·µ»ØÇ°5ÐÐ
Ïà¹ØÎĵµ£º
Ò»¡¢¸ÅÊö
¡¡¡¡Ê¼þµ÷¶ÈÆ÷ÊÇÔÚ MySQL 5.1 ÖÐÐÂÔöµÄÁíÒ»¸öÌØÉ«¹¦ÄÜ£¬¿ÉÒÔ×÷Ϊ¶¨Ê±ÈÎÎñµ÷¶ÈÆ÷£¬È¡´ú²¿·ÖÔÏÈÖ»ÄÜÓòÙ×÷ϵͳÈÎÎñµ÷¶ÈÆ÷²ÅÄÜÍê³ÉµÄ¶¨Ê±¹¦>ÄÜ¡£ÀýÈ磬Linux ÖÐµÄ crontabe Ö»Äܾ«È·µ½Ã¿·ÖÖÓÖ´ÐÐÒ»´Î£¬¶ø MySQL µÄʼþµ÷¶ÈÆ÷Ôò¿ÉÒÔʵÏÖÿÃëÖÓÖ´ÐÐÒ»¸öÈÎÎñ£¬ÕâÔÚһЩ¶ÔʵʱÐÔÒª>Çó½Ï¸ßµÄ»·¾³Ï¾ͷdz£ÊµÓÃÁ ......
ÒÔǰÓùßÁËMSSQL£¬VC++ÓÐÇ¿´óµÄADOÖ§³Ömssql£¬·½±ã°¡£¬²»¹ÜÊÇÁ¬½Ó£¬²Ù×÷µÈ¶¼ÊÇÀÊÀÊÉÏÊÖ°¡¡£µ«ÊÇÏÖÔÚͻȻҪÓÃMySqlÁË£¬¿ªÊ¼Ã»ÓÐmssqlÄÇÑùµÄ²Ù×÷½çÃæ£¬ÎÒÕæÓеãÅų⡣°¥£¬Ã»°ì·¨£¬¹«Ë¾ÒªÇó£¬Ö»ÄÜÑо¿MySqlÔõôÓÃÁË¡£
¸Õ¿ªÊ¼¾ÍÓöµ½ÁËÒ»¸ö»ù±¾µÄÎÊ ......
Mysql·½Ê½£º
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class MysqlDB {
private String strClass = "com.mysql.jdbc.Driver";
private String strDriver = "jdbc:mysql://localhost: ......
½â¾öThe‘InnoDB’feature is disabled; you need MySQL built with ‘InnoDB’ to have it2009Äê12ÔÂ29ÈÕ ÐÇÆÚ¶þ ÉÏÎç 11:15MySQL
³öÏÖÈçÏÂÓï¾ä£ºThe ‘InnoDB’ feature is disabled; you need MySQL built with ‘InnoDB’ to have it working£»
ÊÇmysqlÅäÖÃÎļþ½ûµôÁËÕâ¸öÑ¡ ......
MySQL showµÄÓ÷¨
a. show tables»òshow tables from database_name; // ÏÔʾµ±Ç°Êý¾Ý¿âÖÐËùÓбíµÄÃû³Æ
b. show databases; // ÏÔʾmysqlÖÐËùÓÐÊý¾Ý¿âµÄÃû³Æ
c. show columns from table_name from database_name; »òshow columns from database_name.table_name; ......