CRUD, 함수 예제 1
세팅 데이터베이스test6테이블employees컬럼더보기INSERT INTO employees (name, position, email, phone_number, salary) VALUES('김철수', 'Manager', 'chulsoo.kim@example.com', '010-1234-5678', 5000000),('이영희', 'Developer', 'younghee.lee@example.com', '010-2345-6789', 4000000),('박준혁', 'Designer', 'junhyuk.park@example.com', '010-3456-7890', 3500000),('최수진', 'Tester', 'sujin.choi@example.com', '010-4567-8901', 3200000),('..
2024. 11. 28.
함수 예제 1
세팅 데이터베이스test6테이블books컬럼id - int, pri, not null, auto incrementtitle - varchar(100)author_fname - varchar(100)author_lname - varchar(100) released_year - intstock_quantity -intpages - int 더보기INSERT INTO books (title, author_fname, author_lname, released_year, stock_quantity, pages)VALUES('The Namesake', 'Jhumpa', 'Lahiri', 2003, 32, 291),('Norse Mythology', 'Neil', 'Gaiman',2016, 43, 304),('Amer..
2024. 11. 28.
CRUD 예제
세팅 데이터베이스 test5 테이블 product 컬럼 id - int, pri, not null, auto incrementproduct_name - varchar(100)category - varchar(50)price - intstock_quantity -intcreated_at - timestamp더보기INSERT INTO product (product_name, category, price, stock_quantity, created_at) VALUES('삼성 스마트폰', '전자제품', 850000, 50, '2023-01-15'),('LG 냉장고', '가전제품', 1200000, 30, '2023-01-20'),('다이슨 청소기', '가전제품', 550000, 20, '2023-02-05')..
2024. 11. 27.
