1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
| create database MyDB;
show databases;
MariaDB [MyDB]> create table table_name( -> id int(10), -> name varchar(15), -> salary float -> );
insert into table_name value (1, 'dd', 10000);
select * from table_name;
describe users;
rename table table_name to cy_and_dd;
drop table cy_and_dd;
update cy_and_dd set salary = 110110 where id = 1;
select * from cy_and_dd order by salary desc;
delete from cy_and_dd where id = 0;
ALTER TABLE my_table MODIFY COLUMN id INT NOT NULL AUTO_INCREMENT PRIMARY KEY;
|