各种服务器重启mysql的方法 RedHat Linux (Fedora Core/Cent OS)
1.启动:/etc/init.d/mysqld start 2.停止:/etc/init.d/mysqld stop 3.重启:/etc/init.d/mysqld restart Debian / Ubuntu Linux 1.启动:/etc/init.d/mysql start 2.停止:/etc/init.d/mysql stop 3.重启:/etc/init.d/mysql restart Windows 1.点击"开始"->"运行"(快捷键Win+R) 2.启动:输入 net stop mysql 3.停止:输入 net start mysql 提示 Redhat Linux 也支持service command, 启动:# service mysqld start 停止:# service mysqld stop 重启:# service mysqld restart Windows下不能直接重启(restart),只能先停止,再启动。
查看库数量。名称
show databases;
转到test
use test;
查表数:
show tables;
描述:
desc student;
建库(指定编码):
creat database sanbo character set UTF8;
建表:(两列:id name--name不能为空)
create table student(
student_id int,
student_name varchar(30) not null
);
修改表:
alter table student
add sex char(1);
删此字段。。
alter table student
drop column sex;
写入:
insert into student values(1,'Tom','1');
指定部分列写入。(数据优化的一种方式-->△)
insert into student(id ,name) values (1,'Jack');
查:
select * from student ;
查询指定情况列:(where 查询条件)
select * from student where id=1 and name='Tom';
改:
修改列名:
Alter table student -没有分号!!!
Change student_name aaa varchar(50);
update student set name='Jack';-->名字全改为Jack
同时改两个:
update student set name='OO' ,id='22' where id=1;
累加操作
update product set price=price*1.1
追加:
ipdate student set student_id=cuncat(student_id,'1');
删:
删此字段。。
alter table student
drop column sex; 删指定行:
delete from student where student_name='Jack';
删数据:
delete from student;
删表
drop table student;
删库:
drop database student;Update user set password=password(‘123456’) where user=’root’;
1.启动:/etc/init.d/mysqld start 2.停止:/etc/init.d/mysqld stop 3.重启:/etc/init.d/mysqld restart Debian / Ubuntu Linux 1.启动:/etc/init.d/mysql start 2.停止:/etc/init.d/mysql stop 3.重启:/etc/init.d/mysql restart Windows 1.点击"开始"->"运行"(快捷键Win+R) 2.启动:输入 net stop mysql 3.停止:输入 net start mysql 提示 Redhat Linux 也支持service command, 启动:# service mysqld start 停止:# service mysqld stop 重启:# service mysqld restart Windows下不能直接重启(restart),只能先停止,再启动。
查看库数量。名称
show databases;
转到test
use test;
查表数:
show tables;
描述:
desc student;
建库(指定编码):
creat database sanbo character set UTF8;
建表:(两列:id name--name不能为空)
create table student(
student_id int,
student_name varchar(30) not null
);
修改表:
alter table student
add sex char(1);
删此字段。。
alter table student
drop column sex;
写入:
insert into student values(1,'Tom','1');
指定部分列写入。(数据优化的一种方式-->△)
insert into student(id ,name) values (1,'Jack');
查:
select * from student ;
查询指定情况列:(where 查询条件)
select * from student where id=1 and name='Tom';
改:
修改列名:
Alter table student -没有分号!!!
Change student_name aaa varchar(50);
update student set name='Jack';-->名字全改为Jack
同时改两个:
update student set name='OO' ,id='22' where id=1;
累加操作
update product set price=price*1.1
追加:
ipdate student set student_id=cuncat(student_id,'1');
删:
删此字段。。
alter table student
drop column sex; 删指定行:
delete from student where student_name='Jack';
删数据:
delete from student;
删表
drop table student;
删库:
drop database student;Update user set password=password(‘123456’) where user=’root’;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货