¼òµ¥²âÊÔMySQL 5.1 ±í·ÖÇø¹¦ÄÜ
Ïë²âÊÔϱí·ÖÇø¹¦Äܸú×ÔÖ÷µÄ·Ö²¼Ê½µÄÐÔÄܲîÒ죬½øÐÐÁ˼òµ¥µÄ²âÊÔ£¬Ç°ºó»¨·ÑÁ˰ë¸öСʱ£¬¿ÉÄܲâÊÔÊý¾Ý²»Ì«×¼È·¡£
¡¾²âÊÔ»·¾³¡¿
²Ù×÷ϵͳ£ºWindows XP SP2
MySQL£º 5.1.19-beta-community-nt-debug
¡¾²âÊÔ¹ý³Ì¡¿
²é¿´MySQL°æ±¾£º
mysql> select version();
+--------------------------------+
| version() |
+--------------------------------+
| 5.1.19-beta-community-nt-debug |
+--------------------------------+
1 row in set (0.00 sec)
½¨Á¢·ÖÇø±í£º
mysql> create table p1 (
-> id int(10) not null auto_increment,
-> username varchar(32) default '',
-> email varchar(64) default '',
-> created datetime default '0000-00-00 00:00:00',
-> primary key (id)
-> ) engine=myisam
-> partition by range(id)(
-> partition p1 values less than (10000),
-> partition p2 values less than (20000),
-> partition p3 values less than (30000),
-> partition p4 values less than (40000),
-> partition p5 values less than (50000),
-> partition p6 values less than (60000),
-> partition p7 values less than (70000),
-> partition p8 values less than (80000),
-> partition p9 values less than (90000),
-> partition p10 values less than maxvalue
-> );
Query OK, 0 rows affected (0.08 sec)
½¨Á¢²»·ÖÇø£¨ÆÕͨ±í£©£º
mysql> create table p2 (
-> id int(10) not null auto_increment,
-> username varchar(32) default '',
-> email varchar(64) default '',
-> created datetime default '0000-00-00 00:00:00',
-> primary key (id)
-> ) engine=myisam;
Query OK, 0 rows affected (0.00 sec)
²åÈëÊý¾ÝµÄ´æ´¢¹ý³Ì£º
mysql> delimiter //
mysql> create procedure load_tab()
-> begin
-> declare v int default 0;
-> while v < 100000
-> do
-> insert into p1 (username,email,created) values ('jack', 'jack@example.com', now());
-> set v = v + 1;
-> end while;
-> end
-> //
Query OK, 0 rows affected (0.00 sec)
¸øÁ½¸ö±í·Ö±ð²åÈë
Ïà¹ØÎĵµ£º
½ñÌìÓöµ½Òªµ¼³öÊý¾Ý¿âÖбíµÄÊý¾Ý¡£ÏÂÃæÕâ¸ö¾Í¿ÉÒԸ㶨¡£¡£
#µ¼³öÖ¸¶¨µÄ±í #µ¼³öÃüÁî -uÓû§Ãû -pÃÜÂë -hÖ÷»úIPµØÖ· Êý¾Ý¿âÃû ±íÃû1 ±íÃû2 > µ¼³öÎļþ.sql
mysqldump -uroot -proot -h192.168.0.88 ok_db oktable1 oktable2 > ok_db.sql
ÁíÍâÔÚ¸ü¸ÄmysqlÃÜÂëʱºò£¬ÍøÉÏÓÐЩÃüÁî²»¶Ô£º
ÎÒÓÃÈçÏ£ºset password=pas ......
package com.lovo.cq.shopping10_1.common;
import java.sql.*;
public class DbUtil {
private PreparedStatement pstmt = null;
private Connection con = null;
public DbUtil() {
try {
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://l ......
±¾ÊµÑéÍê³ÉÈçϽá¹û£º
0. testÊý¾Ý¿â,userinfo Óû§ÐÅÏ¢±í ºÍ userinfolog Óû§ÐÅÏ¢ÈÕÖ¾±í
1. ½¨Á¢Ò»¸öuserinfo±íÐÂÔö¼Ç¼ʱµÄ´¥·¢Æ÷,½«ÐÂÔöÈÕÖ¾¼ÓÈëµ½userinfolog
2. ½¨Á¢Ò»¸öÏòuserinfo±íÐÂÔö¼Ç¼µÄ´æ´¢¹ý³Ì
3. ¸ù¾ ......
mysql error number 2003
Can't connect to MySQL server xxx.xxx.xxx.xxx (10061)
ÔÚubuntu 9.04ÖÐĬÈϰ²×°ÁËmysql£¬Ä¬ÈÏÖ»Äܱ¾µØ·ÃÎÊ£¬googleÁËһϣº
²ÉÓÃ
µÇ¼µ½MySQL·þÎñÆ÷¶Ë£¬ÔÚmysql¿âÏÂÖ´ÐÐ
grant all on *.* to 'remote'@'172.16.21.39' identified by 'password';
¼´¿É
Èç¹ûÒªÉèÖÃΪ ......
Ò»¡¢Á¬½ÓMYSQL
¡¡¡¡¸ñʽ£º mysql -hÖ÷»úµØÖ· -uÓû§Ãû £pÓû§ÃÜÂë
¡¡¡¡1¡¢Àý1£ºÁ¬½Óµ½±¾»úÉϵÄMYSQL¡£
¡¡¡¡Ê×ÏÈÔÚ´ò¿ªDOS´°¿Ú£¬È»ºó½øÈëĿ¼ mysqlbin£¬ÔÙ¼üÈëÃüÁîmysql -uroot -p£¬»Ø³µºóÌáʾÄãÊäÃÜÂ룬Èç¹û¸Õ°²×°ºÃMYSQL£¬³¬¼¶Óû§rootÊÇûÓÐÃÜÂëµÄ£¬¹ÊÖ±½Ó»Ø³µ¼´¿É½øÈëµ½MYSQLÖÐÁË£¬MYSQLµÄÌáʾ·ûÊÇ£ºmysql>
¡¡¡ ......