Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÖÕÓÚÕÒµ½Ò»¸ö¿ÉÒÔ½â¾öMySQLÆô¶¯Ê±1067´íÎóµÄ·½·¨ÁË£¡

°²×°ºóMYSQL5ºó£¬·¢ÏÖÆô¶¯³ö´í.
³ö´í´úÂ룺1067
½â¾ö°ì·¨ÈçÏ£º
ɾ³ý%windows%/my.ini
ɾ³ýÆäËüµØ·½µÄmy.ini
ÔÚmysql°²×°Ä¿Â¼Ï°Ñmy-small.ini¸´ÖÆΪmy.ini
ÔÚmy.ini×îºóÒ»ÐвåÈ룺
CODE:
[mysqld]
#ÉèÖÃbasedirÖ¸ÏòmysqlµÄ°²×°Â·¾¶
basedir=C:\mysql-5.1.11-beta-win32
datadir=C:\mysql-5.1.11-beta-win32\data
ÖØÐÂÆô¶¯·þÎñ¡£¡£¡£
CODE:
C:\mysql-5.1.11-beta-win32\bin>net start mysql
MySQL ·þÎñÕýÔÚÆô¶¯ .
MySQL ·þÎñÎÞ·¨Æô¶¯¡£
ϵͳ³ö´í¡£
·¢Éúϵͳ´íÎó 1067¡£
½ø³ÌÒâÍâÖÕÖ¹¡£
C:\mysql-5.1.11-beta-win32\bin>mysqld-nt --remove
Service successfully removed.
C:\mysql-5.1.11-beta-win32\bin>mysqld-nt --install
Service successfully installed.
C:\mysql-5.1.11-beta-win32\bin>net start mysql
MySQL ·þÎñÕýÔÚÆô¶¯ .
MySQL ·þÎñÒѾ­Æô¶¯³É¹¦¡£
C:\mysql-5.1.11-beta-win32\bin>net stop mysql
MySQL ·þÎñÕýÔÚÍ£Ö¹..
MySQL ·þÎñÒѳɹ¦Í£Ö¹¡£


Ïà¹ØÎĵµ£º

Mysql ÃüÁîÐÐģʽ ѧ»áʹÓðïÖúÎĵµ

 ÔÚÎÒÃÇ»ú·¿ÉϿεÄʱºò£¬ÀÏʦÈÃ×Ô¼º×ö ͼͼƬ ³ö¿â ºÍÈë¿â £¬°¥  £¬ ×ø×Å×ø×Å £¬½¨±íMYSQL  ÃüÁîÐÐģʽ£¬Óиö´æ´¢ ͼƬµÄ×ֶΠ×Ô¼º²»ÊìϤ£¬ÓÐûÓÐMysql µÄAPIÎĵµ£¬ ÈçºÎ°ì ÎÊͬѧ ͬѧҲ²»ÖªµÀ¡£
ºÇºÇ ÏëÆðÁË DOSµÄ°ïÖú ´òÁËÒ»¸ö Help ºÇºÇ ³öÏÖÁË ºÃ¶à¶«Î÷
ÔÙ°´ÕÕÌáʾ £ºhelp create table  ºÇºÇ Ï ......

Éè¼ÆMySQLÊý¾Ý¿âµÄ¼¼ÇÉ


¡¡¡¡ÄãÕý¼Æ»®¿ª·¢Ò»¸öÐèÒªMySQLÊý¾Ý¿âµÄPHPÍøÂçÓ¦ÓÃÂð£¿ÄÇôÄãÊ×ÏÈÐèÒªÉè¼ÆMySQLÊý¾Ý¿â¡£±¾ÎĽ«½Ì»áÄãһЩÉè¼ÆMySQLÊý¾Ý¿âµÄ¼¼ÇÉ¡£
¡¡¡¡¾ÍMySQL¶øÑÔ£¬´ó¶àÊý³ÌÐòÔ±¶¼²»Ì«Á˽âÆäÉè¼Æ±³¾°£¬Òò´Ëµ±ËûÃdz¢ÊÔ´´½¨×Ô¼ºµÄÊý¾Ý¿âʱ£¬»áÁôϺܶ੶´¡£
¡¡¡¡ÒªÏëΪMySQLÊý¾Ý¿â½øÐкÏÊʵÄÅäÖã¬ÄãµÄÍøÂçÓ¦ÓÃÓ¦¸ÃÊÇÓÐЧÇÒ¿É¿¿µÄ£¬Òò ......

jsp mysql ²åÈë ¶ÁÈ¡ ͼƬ

½¨Á¢Êý¾Ý¿â£º
ÎÒµÄÊý¾Ý¿âimages
create table img (
id  int primary key auto_increment,
name varchar(80),
pic  longblob
)
Òª±£Ö¤ÍøÕ¾¸ùĿ¼ Óиö images Îļþ¼Ð
²åÈëÊý¾Ý¿â ´Ó±¾µØÎļþ¼Ð
<%@ page contentType="text/html; charset=utf-8" language="java"  import="java.sql.*,java.io.*" ......

WindowsÏ°²×°×îеÄApache+PHP+MySQLÖ¸ÄÏ

 ×¢Ò⣺֮ǰÎÒÔÚÍøÉÏÕÒÁ˺öàµÄ×ÊÁÏ NND¶¼²»ÄÜÕý³£ÅäÖóɹ¦ ¸ãµÃÎÒÊǷdz£µØÓôÃÆ£¡
ÕÒµ½ÕâƪÎÄÕÂÖ®ºóÎÒÖÕÓÚÅäÖóɹ¦ÁË£¡ÍÛºÃˬѽ£¡Ö»Òª°´ÕÕ ÉÏÃæµÄ²½Öè¾ÍÒ»¶¨Äܹ»³É¹¦µÄ£¡
´ËÎÄյݲװ·½·¨ÊÊÓÃÓÚWindows XPϵÄApache+PHP+MySQL°²×°£¬Í¬Ê±Ò²ÊÊÓÃÓÚWindows 2003ϵͳϵݲװºÍÅäÖá£
1. °²×°»·¾³
²Ù×÷ϵͳÊÇ Window ......

MYSQL ÓëMSSQL2000 ÔÚÐ޸ıí×ֶεÄÇø±ð

Ìí¼Ó×ֶΣº
MYSQL
alter table tb add col2 varchar(10)
MSSQL2000
alter table tb add col2 varchar(10)
ÐÞ¸Ä×ֶΣº
MYSQL
 alter table tb modify col2 varchar(20)
MSSQL2000
 alter table tb alter column col2 varchar(20)
ɾ³ý×ֶΣº
MYSQL
 alter table tb drop column col ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ