MYSQL-テーブル操作
1613 ワード
1、
:create table ( [,.. ]);
mysql> create table MyClass(
> id int(4) not null primary key auto_increment,
> name char(20) not null,
> sex int(4) not null default '0',
> degree double(16,2));
2、
: desc , show columns from
mysql>DESCRIBE MyClass
mysql> desc MyClass;
mysql> show columns from MyClass;
3、
:drop table
: MyClass
mysql> drop table MyClass;
4、
:insert into [( [,.. ])] values ( 1 )[, ( n )]
, MyClass , : 1 Tom 96.45, 2 Joan 82.99, 3 Wang 96.5.
mysql> insert into MyClass values(1,'Tom',96.45),(2,'Joan',82.99), (2,'Wang', 96.59);
5、
1)、
: select from < > where < >
: MyClass
mysql> select * from MyClass;
2)、
: MyClass 2
mysql> select * from MyClass order by id limit 0,2;
:
mysql> select * from MyClass limit 0,2;
6、
:delete from where
: MyClass 1
mysql> delete from MyClass where id=1;
7、 :update set = ,… where
mysql> update MyClass set name='Mary' where id=1;
7、 :
:alter table add ;
: MyClass passtest, int(4), 0
mysql> alter table MyClass add passtest int(4) default '0'
8、 :
:rename table to ;
: MyClass YouClass
mysql> rename table MyClass to YouClass;
update set =
update set = replace( ,' ',' ');
4
update article set content=concat(' ',content);