sql 기본 crud

seonghyeon·2022년 1월 7일
0
  • INSERT INTO topic (title,description,created,author,profile) VALUES('mongodb','mongodb is ...',NOW(),'baebae','')

-SELECT id,title,created,author,profile FROM topic WHERE author='baebae' ORDER by created DESC LIMIT 1;

  • UPDATE topic SET description = '가나다', title='mysql' WHERE id= 'idvalue';

  • DELETE FROM table name WHERE id = 'idvalue' ;

WHERE < 빠트리지말자 절대로 빠트리지말자

0개의 댓글