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

Struts+Hibernate+MySqlÖÐÎÄÂÒÂë½â¾ö·½°¸

1¡¢ÐÞ¸ÄMySqlÊý¾Ý¿âµÄmy.iniÅäÖÃÎļþ¡¢
# CLIENT SECTION
# ----------------------------------------------------------------------
#
# The following options will be read by MySQL client applications.
# Note that only client applications shipped by MySQL are guaranteed
# to read this section. If you want your own MySQL client program to
# honor these values, you need to specify it as an option during the
# MySQL client library initialization.
#
[client]
port=3306
default-character-set=GBK
#´Ë´¦Ä¬ÈϱàÂëÐÞ¸ÄΪGBK»òutf-8
# SERVER SECTION
# ----------------------------------------------------------------------
#
2¡¢´´½¨Êý¾Ý±íµÄʱºò
# Ö÷»ú: localhost
# Êý¾Ý¿â: cits
# ±í: 'article'
#
CREATE TABLE `article` (
  `article_id` varchar(100) NOT NULL default '0',
  `article_title` varchar(100) default NULL,
  `domain_id` varchar(100) default NULL,
  `article_text` varchar(100) default '',
  `good_flg` tinyint(1) default NULL,
  `lock_flg` tinyint(1) default NULL,
  `top_flg` tinyint(1) default NULL,
  `read_times` int(11) default NULL,
  `reply_times` int(11) default NULL,
  `last_reply` char(6) default NULL,
  `last_reply_time` datetime default NULL,
  `add_user` varchar(30) default NULL,
  `add_date` datetime default NULL,
  `upd_user` varchar(30) default NULL,
  `upd_date` datetime default NULL,
  PRIMARY KEY  (`article_id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
´Ë´¦ÒªÓÃGBK±àÂë
 
3¡¢ÔÚjspÒ³ÃæÖÐʹÓÃUTF-8±àÂë
<%
Object init = request.getAttribute("init");
String domainId = (String)request.getAttribute("domainId");
if ((init == null) || (init.equals("")) || (init.equals("null"))) {
 response.sendRedirect("./listArticle.do?domainId="+domainId);
} else {
%>
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ page import ="java.util.HashMap"%>
<%@ page import ="java.util.List"%>
<%@ page impo


Ïà¹ØÎĵµ£º

mysql°²×°Ê¹ÓÃÊÖ¼Ç

ɾ³ýrpm°ü
    rpm -e mysql-embedded-5.1.39-4.fc12.i686 --nodeps
°²×°rpm°ü
    rpm -vih MySQL-server-community-5.1.37-0.rhel5.i386.rpm
²éѯÒÑ°²×°µÄrpm°ü
    rpm -qa | grep MySQL
Æô¶¯mysql
    mysql£¨Ã»ÓÐÃÜÂëµÄÇé¿ö£©
  &nbs ......

mysql ÃüÁîʹÓÃ

mysql ÃüÁîѧϰ£º
1. mysql -uroot  ;
2.mysql -h ip -ubusiusr -pbusiusr newdrmdb;
3.show databases ;                 //ÏÔʾËùÓеÄÊý¾Ý¿â ;
4.show tables ;           ......

mysql Ë÷Òý


 
 
²é¿´Ä³¸ö±íµÄ½¨±íÓï¾ä £ºshow create table data_statdata;
drop index ts on data_statdata;
Ë÷ÒýÊǼÓËÙ²éѯµÄÖ÷ÒªÊֶΣ¬Ìرð¶ÔÓÚÉæ¼°¶à¸ö±íµÄ²éѯ¸üÊÇÈç´Ë¡£±¾½ÚÖУ¬½«½éÉÜË÷ÒýµÄ×÷Óá¢Ìص㣬ÒÔ¼°´´½¨ºÍɾ³ýË÷ÒýµÄÓï·¨¡£
13.4.1 ʹÓÃË÷ÒýÓÅ»¯²éѯ
Ë÷ÒýÊÇ¿ìËÙ¶¨Î»Êý¾ÝµÄ¼¼Êõ£¬Ê×ÏÈͨ¹ýÒ»¸öʾÀýÀ´Á˽ ......

phpmyadminÖÐMySQLÈçºÎ¼ÓÃÜ(ÅäÖÃ)

ת×Ôhttp://blog.csdn.net/ytz_linuxer/archive/2009/07/04/4321259.aspx
ÒÔ°æ±¾phpMyAdmin-2.6.1.tar.gzΪÀý
      ÏȽâѹphpMyAdmin-2.6.1.tar.gzµ½/usr/local/apache2/htdocs£¬
µÃµ½Îļþ¼ÐphpMyAdmin-2.6.1£¬½«ÆäÖØÃüÃûΪphpmyadmin,(ÕâÑùÔÚÒÔºóµÄ²Ù×÷Öн«»á±äµÄ¼ò±ã)¡£
    ......

linuxÏ mysqlÓû§µÄ¹ÜÀí

linux
ÏÂ mysql
Óû§µÄ¹ÜÀí
ÎÄÕ·ÖÀà:Êý¾Ý¿â
¹Ø¼ü×Ö: linux
mysql
Óû§¹ÜÀí

×Ô´ÓÉÏÔÚredhat Enterprise 5 Öа²×°ÁËMySQL
,Õâ´ÎÀ´Êµ¼ù²Ù×÷Ò»ÏÂMySQL
Óû§µÄ¹ÜÀí£»
 Ò»¡¢rootÓû§ÃÜÂëµÄά»¤£º
       ÓÉÓÚ°²×°MySQL
Íêºó,MySQL
»á×Ô¶¯Ìṩһ¸ö²»´ø ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ