
数据库
文章平均质量分 85
songuooo
Make easy things easy & hard things possible.
展开
-
SQL常用操作
1.表结构以oracle为例,下面定义三个表:学生信息表Student,课程表Course和选课表SC:create table Student ( Sno varchar2(10) primary key, Sname varchar2(20) not null, Ssex char(2) check (Ssex in('男', '女')原创 2012-09-01 16:05:50 · 845 阅读 · 0 评论 -
CentOS 6安装MySQL及phpMyAdmin
1. CentOS 6安装MySQLThe recommended way to install MySQL on a Linux system is via RPM. MySQL-server-5.5.28-1.el6.i686.rpm - The MySQL database server, which manages databases and tables, controls原创 2012-10-22 18:34:20 · 4419 阅读 · 0 评论 -
Learning MySQL 1 - create database & tables using specified charset
1 Create Databasescreate database mydb DEFAULT CHARSET=utf8;2 Create Tablescreate table ids ( id int auto_increment, name varchar(10) not null, num varchar(10), descript原创 2012-11-09 21:39:21 · 1206 阅读 · 0 评论