PostgreSQL | MySQL | 服务启动: 1)#service postgresql start 2)#/etc/init.d/postgresql start 3)#su – postgresql $pg_ctl start PostgreSQL的进程号:1210、1207、 | 服务启动: 1)#service mysqld start 2)#/etc/init.d/mysqld start 3)#safe_mysqld& MySQL的进程号为1663 | 第一次进入数据库: #su – postgres $createdb (建名为postgres的数据库) $psql | 第一次进入数据库: #mysql mysql> (出现这个提示符说明成功) | 创建用户:(用户Ajian,密码:123) #su – postgres $psql =#create user ajian with password ‘123’ | 创建用户:(用户Ajian,密码:123) #grant all privileges on *.* to ajian@"%" identified by "123" (注意:同还可以分配权限,这里是ALL) | 创建数据库(My): #su – postgres $psql =#create database My with owner = ajian template = template1 encoding=’UNICODE’; | 创建数据库(My): 1)#mysql Mysql>create database My; 2)#mysqladmin create My | 查看用户和数据库: #su – postgres $psql =#\l (查看数据库) =#\du (查看用户) | 查看用户和数据库: 1)#mysql Mysql>show databases; (看数据库) 2)#mysqlshow | 新建用户登录: (首先修改配置文件) # vi /var/lib/pgsql/data/pg_hba.conf(在最后加) host all all 127.0.0.1 255.255.255.255 md5 再重启服务:#service postgresql restart 登录:#psql –h 127.0.0.1 –U ajian My Password: | 新建用户登录: 1)#mysql –u ajian –p (带口令登录) 2)#mysql Mysql>use My; (不带口令登录一般用于本机) | 创建表(employee): =#create table employee( (#employee_id int primary key, (#name char(8), (#sex char(2)); | 创建表: >create table employee( ->employee_id int primary key, ->name char(8), ->sex char(2)); | 查看表: =#\dt | 查看表: >show tables; | 查看表的结构: =#\d employee | 查看表的结构: >sescribe employee; | 向表中添加数据: =#insert into employee values -#(‘1’,’zhang’,’F’); -#(‘2’,’chen’,’M’,); | 向表中添加数据: >insert into employee values ->(‘1’,’zhang’,’F’); ->(‘2’,’chen’,’M’,); | 查看表的数据: =#select * from emlpoyee | 查看表的数据: >select * from emlpoyee; | 创建索引(IN_employee): =#create index IN_employee on employee(name); 查看索引: =#\di 删除索引: =#drop index IN_employee on employee; 重建索引: =#reindex table employee;(重建employee所有的) =#reindex index IN_employee;(重建指定的) | 创建索引(IN_employee): 1)>create index IN_employee on employee(name); 2)>alter table employee add index IN_employee(name); 查看索引: >show index from employee; 删除索引: 1)>drop index IN_employee on employee; 2)>alter table emlpoyee drop index IN_employee; | 删除表: =#drop table employee; | 删除表: >drop table employee; | 删除数据库:(注意命令前面的标志) 1)=#drop database ajian; 2)$dropdb ajian | 删除数据库:(注意命令前面的标志) 1)>drop database ajian; 2)#mysqladmin drop ajian | |
|
转贴:http://www.blogjava.net/alwayscy/archive/2007/08/12/136174.html