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

Mysql°²×°°æÓëÃâ°²×°°æµÄÇл»Ê¹ÓÃ

Èç¹ûͬÒâϵͳÖÐͬʱ´æÔÚinstall mysqlºÍno—install mysql£¬ÄÇôÔõÑù½øÐÐÁ½¸ö°æ±¾µÄÇл»Ê¹ÓÃÄØ£¿ÓÖ»áÓöµ½Ê²Ã´ÑùµÄÎÊÌâÄØ£¿
Ê×ÏÈ£¬install mysqlµÄmysql·þÎñÊÇĬÈÏÆô¶¯µÄ£¬ÔÚÈÎÎñ¹ÜÀíÆ÷½ø³ÌÖпÉÒÔ¿´µ½¼¸ÌõsqlµÄ×ÖÑÛ£¬Èçmysqld.exe,sqlbrowser¡£ÕâÊÇinstall mysqlµÄ·þÎñ¡£ÄÇôͨ¹ý¿ì½Ý·½Ê½»ònavicat¾ÍÄÜÆô¶¯Ê¹ÓÃinstall mysqlÁË¡£
Çл»no-install mysql£º
1¡¢°ÑÎñ¹ÜÀíÆ÷½ø³ÌÖÐmysqlld.exe,sqlbrowseµÈ½ø³Ì¹Øµô¡£
2¡¢ÕÒµ½no-install mysqlµÄ·¾¶½øÈë¸ùĿ¼£¬ÓÐStartMysql.batºÍStopMysql.bat,·Ö±ðÊÇÆô¶¯ºÍ¹Ø±ÕmysqlµÄÅú´¦ÀíÎļþ£¬Ë«»÷StartMysql.bat¡£
3¡¢´ò¿ªdosÔËÐд°¿Ú£¬½øÈëno-install mysqlµÄ·¾¶ÏµÄbinµÄÎļþ¼ÐÔËÐÐmysql -uroot -pÃüÁOkÊäÈëÃÜÂë°É¡£¿ÉÒÔ¿ªÊ¼Ê¹ÓÃno-install mysqlÁË¡£
Çл»»Øinstall mysql
1¡¢ÕÒµ½no-install mysqlµÄ·¾¶½øÈë¸ùĿ¼£¬ÓÐStartMysql.batºÍStopMysql.bat,·Ö±ðÊÇÆô¶¯ºÍ¹Ø±ÕmysqlµÄÅú´¦ÀíÎļþ£¬Ë«»÷StopMysql.bat¡£
2¡¢ÕÒµ½install mysqlµÄ°²×°Â·¾¶½øÈëbinÎļþ¼Ð£¬Ë«»÷mysqld.exe.
3¡¢okÓֻص½ÁËinstall mysql״̬


Ïà¹ØÎĵµ£º

LVS+Mysql¼¯Èº¸ºÔؾùºâ ÄÚÍølvsÅäÖÃ

Ò»¡¢IPÐÅÏ¢ÁÐ±í£º
   Ãû³Æ                 IP   
   LVS-DR-VIP            192.168.50.245
   LVS-DR-Master  ......

Á¬½ÓmysqlµÄjavabeanʵÀý+¼òµ¥·ÖÒ³

<%@ page contentType="text/html;charset=GBK" language="java" import="java.sql.*,java.util.*"%>
<html>
<head>
<title>Á¬½ÓmysqlµÄjavabeanʵÀý+¼òµ¥·ÖÒ³</title>
<link href="../CSS.css" rel="stylesheet" type="text/css">
</head>
<body>
<jsp:useBean ......

ÓÉMySQLÖÐcharºÍvarcharЧÂÊÏëµ½µÄ

¶Ô±ÈcharºÍvarcharËæ±ãÔÚgoogle»ò°Ù¶ÈÖÐËÑһϵõ½µÄ½áÂÛ´ó¸Å¶¼ÊÇ"char¶¨³¤,varchar²»¶¨³¤,charÒª±ÈvarcharÕ¼Óøü¶àµÄ¿Õ¼ä,ÓÉÓÚ¶¨³¤charµÄЧÂʸßÓÚvarchar,char×î´ó255,varchar×î´ó65536"¸ü¸ß¼¶Ò»µãµÄÊý¾ÝÊÇ"charÔÚ´æÈëºÍÈ¡³öµÄʱºò,»á×Ô¶¯°ÑĩβµÄ¿Õ¸ñÈ¥µô,varchar»á¶îÍâµÄ¶àÓÃ1-2¸ö×Ö½ÚÀ´´æ·Å×Ö·û³¤¶È,ÁÐÖÐÓÐÒ»¸övarchar» ......

ÓÃMySQL´´½¨Êý¾Ý¿âºÍÊý¾Ý¿â±í

1¡¢Ê¹ÓÃSHOWÓï¾äÕÒ³öÔÚ·þÎñÆ÷Éϵ±Ç°´æÔÚʲôÊý¾Ý¿â£º
 
de>de>mysql> SHOW DATABASES; +----------+ | Database | +----------+ | mysql | | test | +----------+ 3 rows in set (0.00 sec)
    2¡¢´´½¨Ò»¸öÊý¾Ý¿âabccs
     mysql> CREATE DATABASE abccs; ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ