commands

Question 1

How to start MySQL in PuTTY?

Answer 1

mysql -p

Question 2

to display catalog

Answer 2

show ________ ;

Question 3

to open database

Answer 3

use ______;

Question 4

to create a table

Answer 4

create table ________ (__, ___);

Question 5

to delete table

Answer 5

drop table _______;

Question 6

to create a field

Answer 6

insert into _______(__, __) values(__, __)

Question 7

conditions in selecting

Answer 7

where ____=’__’;
order by asc/desc;
limit __;

Question 8

show the table structure

Answer 8

describe ____;

Question 9

add new field

Answer 9

alter table _____ add ______ varchar/int ();

Question 10

rename field name/column

Answer 10

alter table _____ change _______ ________ varchar/int();

Question 11

modify field attributed

Answer 11

alter table ______ modify _______ varchar / int();

Question 12

delete field

Answer 12

alter table ________ drop ______;

Question 13

rename table

Answer 13

alter table ____ rename to _______;

Question 14

add primary key

Answer 14

alter table _______ add primary key (_______);

Question 15

update record all or specific

Answer 15

update ________ set ______= ‘___’ where ______=’____’;

Question 16

delete records

Answer 16

delete from ______ where ______=’___’;