기본 문법

mysql -u root -p

show databases;

use example;

select * from member where seq=5 and name='leegugu';

update member set name = 'administrator' where seq=1;

 

select * from student, professor;  - 합쳐줌

 

 

select * from member where seq=5 and name='leegugu';

update member set name='test1', where name='test;

update member set name='test1', where seq=6;

 

---

 

create table time_student (sid int, sname varchar(16), create_time datetime);

insert into time_student(select 30, 'sun', now());

select * from time_student;

 

 

select * from student, professor;  - 합쳐줌