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

MySQL phpMyAdmin 安装

首先安装phpMyadmin
[root@aladdin phpMyAdmin]# uname -a
Linux aladdin.leadtek.com.cn 2.6.32.11-99.fc12.i686.PAE #1 SMP Mon Apr 5 16:15:03 EDT 2010 i686 i686 i386 GNU/Linux
[root@aladdin phpMyAdmin]# yum info phpmyadmin
Loaded plugins: presto, refresh-packagekit
Installed Packages
Name       : phpMyAdmin
Arch       : noarch
Version    : 3.2.5
Release    : 1.fc12
Size       : 11 M
Repo       : installed
from repo  : updates
Summary    : Web based MySQL browser written in php
URL        : http://www.phpmyadmin.net/
License    : GPLv2+
Description: phpMyAdmin is a tool written in PHP intended to handle the
           : administration of MySQL over the Web. Currently it can create and
           : drop databases, create/drop/alter tables, delete/edit/add fields,
           : execute any SQL statement, manage keys on fields, manage
           : privileges,export data into various formats and is available in 50
           : languages
安装完成后访问 http://localhost/phpMyAdmin, 需要http认证, 故需要修改配置文件.
修改配置文件, 参考 http://www.phpmyadmin.net/documentation/#config
在/etc/phpMyAdmin/中
# cd /etc/phpMyAdmin
# mkdir config # create directory for saving
# chmod o+rw config # give it world writable permissions
# cp config.inc.php config/ # copy current configuration for editing
# chmod o+w config/config.inc.php # give it world writable permissions
使用浏览器访问 http://localhost/phpMyAdmin/setup
选择Connect without passwo


相关文档:

IIS6.0+PHP+MYSQL配置

Win2003server 下架设PHPWind产品环境
安装前准备:1、安装好iis6
            
             
            
&nbs ......

mysql多表联合查询并统计

推广地点表promotion_addr字段:name,id
电话报竣表unicom_record字段:date, sheet_id(关联sheet表id)
报单表sheet字段:id,promotion_addr_id(关联promotion_addr表id)
要求统计某个月已报竣各推广地点的推广个数;
SELECT
p.name, count(*)
from
unicom_record AS ur
Left Join sheet AS s ON ur.sheet_id ......

PowerDesigner设定MySQL字段identity类型

自增长类型增加
1.如果dbms是MsSql,则选定表后,database-> edit   current   dbms-> 出现DBMS   properties对话框,选择General页,左侧的树选择SQL   2000-> Profile-> Column-> Extended   Attributes   下面的ExtIdentityIncrement是步进 ......

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 Workbench 可视化的设计 MySQL 数据库

英文原文:
http://www.packtpub.com/article/visual-mysql-database-design-in-mysql-workbench
下面是部分翻译过来的,转载自:http://zuolo.info/2008/11/%e4%bd%bf%e7%94%a8-mysql-workbench-%e5%8f%af%e8%a7%86%e5%8c%96%e7%9a%84%e8%ae%be%e8%ae%a1-mysql-%e6%95%b0%e6%8d%ae%e5%ba%93-1%e8%af%91%e6%96%87/
MySQL ......
© 2009 ej38.com All Rights Reserved. 关于E健网联系我们 | 站点地图 | 赣ICP备09004571号