易截截图软件、单文件、免安装、纯绿色、仅160KB

mysql 命令使用

mysql 命令学习:
1. mysql -uroot  ;
2.mysql -h ip -ubusiusr -pbusiusr newdrmdb;
3.show databases ;                 //显示所有的数据库 ;
4.show tables ;                       //显示所有的表 ;
5.set names gbk ;                   //设置字符集 ;
6.desc tmonthfees201004 ;    //显示表结构 ;
7.alter table tcontents change cVersion cVersion varchar(128) null ;   //修改mysql表中字段的属性 ;
8. show index from tcontents from newdrmdb;
    show index from newdrmdb.tcontents ;
    show keys from tcontents ;                         
    show indexes from tcontents ;                     //查看表的索引 ;


相关文档:

mysql的配置文件my.ini

# MySQL Server Instance Configuration File
# ----------------------------------------------------------------------
# Generated by the MySQL Server Instance Configuration Wizard
#
#
# Installation Instructions
# ----------------------------------------------------------------------
#
# On Li ......

转帖:Python2.6 下安装 mysql (Windows xp)

转自:
http://hi.baidu.com/feng2211/blog/item/8b86b6d9816a3f2710df9b79.html

http://i.19830102.com/archives/164
Python 版本:2.6
下载地址:http://www.python.org/download/releases/2.6.1/
下载msi文件并安装
MySQLdb版本: MySQL-python-1.2.2.win32-py2.6.exe
下载地址:http://home.netimperia.com/ ......

php PDO 链接 mysql 最简单 实例

define("DB_SERVER","127.0.0.1");
define("DB_PORT",3306);
define("DB_CATALOG","uab");
define("DB_USERID","root");
define("DB_PASSWORD","");
$dsn="mysql:host=".DB_SERVER.";port=".DB_PORT.";dbname=".DB_CATALOG;
self::$__PDO=new PDO($dsn, DB_USERID, DB_PASSWORD);
//support long connection
self:: ......

Mysql 关键字 保留字

Mysql 关键字-保留字
在powerdesigner设计的时候用了关键字,生成出错,很囧。。。
 
 
 
 
 
ADD
ALL
ALTER
ANALYZE
AND
AS
ASC
ASENSITIVE
BEFORE
BETWEEN
BIGINT
BINARY
BLOB
BOTH
BY
CALL
CASCADE
CASE
CHANGE
CHAR
CHARACTER
CHECK
COLLATE
COLUMN
CON ......

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 ......
© 2009 ej38.com All Rights Reserved. 关于E健网联系我们 | 站点地图 | 赣ICP备09004571号