cobar and mysql·Ö¿â×Ö¶ÎÎÊÌâ
½ñÌìµ÷³ÌÐò´ÓÊý¾Ý¿âÀïÈ¡Êý¾Ý£¬Ò»Ö±È¥²»³öÀ´£¬°ÑÈÕÖ¾Àï´ò³öÀ´µÄsql·Åµ½Êý¾Ý¿âÀïÈ¥Ö´ÐУ¬È´ÓÖÄÜ
È¡³öÊý¾ÝÀ´£¬ºÜÊÇÓôÃÆ¡£
Êý¾Ý¿âÊÇmysqlµÄ£¬Ò»¹²128¸ö¿â£¬Í¨¹ýij¸ö×ֶηֿ⡣
ºóÀ´·¢ÏÖÒª²éµÄÕâÌõÊý¾ÝµÄ·Ö¿â×ֶα»¸Ä¹ý£¬°´ÕÕ³ÌÐòÀïÖ´ÐеÄÈ¥²é£¬Ëû¾ÍÈ¥ÁËÁíÍâÒ»¸ö¿âÈ¥²éѯÁË£¨ÒòΪ·Ö¿â×ֶα»¸Ä¹ý£©
¶øÖ±½ÓÈ¥Êý¾Ý¿âÀïÈ¥²é£¬²éѯÁËËùÓеĿ⣬ËùÒÔÄܲé³öÊý¾ÝÀ´¡£
°´ÕÕcobarµÄÔÔò£¬²éѯÌõ¼þ´øË«ÒýºÅÊÇĬÈϲéËùÓеĿ⣬¶øµ¥ÒýºÅÊǰ´ÕÕ·Ö¿â×Ö¶ÎÈ¥²éÏàÓ¦µÄ¿â¡£
±ÈÈ磺
1.²éËùÓеĿ⣺ select * from A where b="test"
2.²éµ¥¿â£º select * from A where b='test' and ·Ö¿â×Ö¶Î='cobar'
Ïà¹ØÎĵµ£º
£¨1£©Æô¶¯
MySQL°²×°Íê³ÉºóÆô¶¯ÎļþmysqlÔÚ/etc/init.dĿ¼Ï£¬ÔÚÐèÒªÆô¶¯MySQL·þÎñʱÔËÐÐÏÂÃæÃüÁî¼´¿É¡£ [root@test1 init.d]# /etc/init.d/mysql start
£¨2£©Í£Ö¹
/usr/bin/mysqladmin -u root -p shutdown
£¨3£©ÉèÖÃMySQL×Ô¶¯Æô¶¯
1£©²ì¿´mysqlÊÇ·ñÔÚ×Ô¶ ......
¼ÙÈçÎÒÓиöuser±í,ÎÒÏë²éѯ·ûºÏijЩÌõ¼þµÄµÚ50¸öÓû§¿ªÊ¼µÄ10¸öÓû§,ÇÒ²»ÄÜʹÓÃidºÅbetween andÄÇÑù²éѯ,Ó¦¸ÃÔõôдSQLÓï¾ä?
¡¡¡¡ÔÚmysqlÊý¾Ý¿âÖÐÓÐlimit,offsetÓï¾ä¿ÉÒÔ·½±ãµÄʵÏÖ,ÄÇôÔÚSQL serverÖÐÄØ?SQL ServerÊÇ·ñÖ§³ÖlimitºÍoffsetÓï¾äÄØ?
select top 10 * from
(select top 60 * from [user] order by userid) a ......
import java.io.File;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import jxl.*;
public class ImportExcel {
public static void main(String[] args) {
File importExcel = new File("D:\\test\\test.xls");
try {
// Êý¾Ý¿âÁ¬½Ó
Class.forNa ......
×¼±¸£ºÏÂÔØMysql5.1<mysql-essential-5.1.41-win32.msi>
°²×°£ºstep by step
²âÊÔ£º1.MySQL²âÊÔ
µã¿ªMySQL Command Line Client, ÊäÈ밲װʱ½¨Á¢µÄÃÜÂë¡£
mysql>show databases;
mysql>use <<database name>>;
mysql>show tables;
mysql>select * from <<table name>>;
......
ºÚ¿ÍÈëÃż¼ÊõÖ®php+mysql×¢ÉäÓï¾ä¹¹Ô죺
Ò».ǰÑÔ£º
²âÊÔ°æ±¾ÐÅÏ¢£ºOkphp BBS v1.3 ¿ªÔ´°æ
ÓÉÓÚPHPºÍMYSQL±¾ÉíµÃÔÒò,PHP+MYSQLµÄ×¢ÉäÒª±ÈaspÀ§ÄÑ£¬ÓÈÆäÊÇ×¢ÉäʱÓï¾äµÄ¹¹Ôì·½Ãæ¸üÊǸöÄѵ㣬±¾ÎÄÖ÷ÒªÊǽè¶ÔOkphp BBS v1.3һЩÎļþµÃ¼òµ¥·ÖÎö£¬À´Ì¸Ì¸php+mysql×¢ÉäÓï¾ä¹¹Ô췽ʽ£¬Ï£Íû±¾ÎĶÔÄãÓеã°ïÖú¡£
¡¡¡¡ÉùÃ÷£ºÎÄÕÂËùÓ ......