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
Ïà¹ØÎĵµ£º
ɾ³ý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 ÃüÁîѧϰ£º
1. mysql -uroot ;
2.mysql -h ip -ubusiusr -pbusiusr newdrmdb;
3.show databases ; //ÏÔʾËùÓеÄÊý¾Ý¿â ;
4.show tables ; ......
²é¿´Ä³¸ö±íµÄ½¨±íÓï¾ä £ºshow create table data_statdata;
drop index ts on data_statdata;
Ë÷ÒýÊǼÓËÙ²éѯµÄÖ÷ÒªÊֶΣ¬Ìرð¶ÔÓÚÉæ¼°¶à¸ö±íµÄ²éѯ¸üÊÇÈç´Ë¡£±¾½ÚÖУ¬½«½éÉÜË÷ÒýµÄ×÷Óá¢Ìص㣬ÒÔ¼°´´½¨ºÍɾ³ýË÷ÒýµÄÓï·¨¡£
13.4.1 ʹÓÃË÷ÒýÓÅ»¯²éѯ
Ë÷ÒýÊÇ¿ìËÙ¶¨Î»Êý¾ÝµÄ¼¼Êõ£¬Ê×ÏÈͨ¹ýÒ»¸öʾÀýÀ´Á˽ ......
ת×Ô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
Óû§¹ÜÀí
×Ô´ÓÉÏÔÚredhat Enterprise 5 Öа²×°ÁËMySQL
,Õâ´ÎÀ´Êµ¼ù²Ù×÷Ò»ÏÂMySQL
Óû§µÄ¹ÜÀí£»
Ò»¡¢rootÓû§ÃÜÂëµÄά»¤£º
ÓÉÓÚ°²×°MySQL
Íêºó,MySQL
»á×Ô¶¯Ìṩһ¸ö²»´ø ......