데이터베이스 SQL (2) 썸네일형 리스트형 SQL select select a.sname from student1 a, professor b where a.pid=b.pid; MariaDB [example]> select a.sname from student1 a, professor b where a.pid=b.pid; +--------+ | sname | +--------+ | stella | | eve | | John | | stella | | eve | | John | +--------+ 6 rows in set (0.000 sec) MariaDB [example]> select * from student1 a right join professor b on (a.pid=b.pid); +------+--------+-------------+------+-----.. 기본 문법 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), cr.. 이전 1 다음
