목록오름차순 (1)

취미와 밥줄사이

MySQL 오름차순, 내림차순 정렬: 'Order by'

1. 테이블 생성 create table books ( book_id int not null auto_increment, title varchar(100), author_fname varchar(100), author_lname varchar(100), released_year int, stock_quantity int , pages int , primary key (book_id) ); 2. 데이터 삽입 INSERT INTO books (title, author_fname, author_lname, released_year, stock_quantity, pages) VALUES ('The Namesake', 'Jhumpa', 'Lahiri', 2003, 32, 291), ('Norse Mythology..
DB 2021. 3. 16. 17:39
이전 Prev 1 Next 다음