第一天学linux的mysql

佑拐角803

vim /etc/resolv.conf  #进去添加第二行的#号键
scp root@10.0.0.253:~/rhel*.iso .  #进去下载iso的镜像
mkdir /var/ftp/rhel6.3
mount -o loop rhel6.3.x86.iso  /var/ftp/rhel6.3
cd /var/ftp/rhel6.3/Packages
rpm -ivh perl-DBI-1.609-4.el6.i686.rpm
rpm -ivh perl-DBD-MYSQL-4.013-3.el6.i686.rpm
rpm -ivh mysql-server-5.1.61-4.el6.i686.rpm
查询:
rpm -q mysql
service mysqld start
mysql
创建数据库:
create database ds;
进入数据库:
use ds;
创建表
create table stu
show tables;
desc stu stuName;
show table status like 'stu'\show * from stu;

show full columns from stu;
insert into stu values(1, 'tom', 20);
select * from stu;
drop table if exists stu;
show create table stu;