๐ ๊ณต๋ถํ๋ ์ง์ง์ํ์นด๋ ์ฒ์์ด์ง?
[MySQL] ๊ฐ๋จํ๊ฒ ๋ฐ์ดํฐ๋ฒ ์ด์ค, ํ ์ด๋ธ ๋ถ๋ฌ์ค๊ธฐ ๋ณธ๋ฌธ
๐ฉ๐ป ์ปดํจํฐ ๊ตฌ์กฐ/About Computer
[MySQL] ๊ฐ๋จํ๊ฒ ๋ฐ์ดํฐ๋ฒ ์ด์ค, ํ ์ด๋ธ ๋ถ๋ฌ์ค๊ธฐ
์ง์ง์ํ์นด 2023. 2. 21. 13:01728x90
๋ฐ์ํ
โญ Mysql Workbench ์์ ์ฌ์ฉ
https://dev.mysql.com/downloads/workbench/
โญ ๋ฐ์ดํฐ๋ฒ ์ด์ค, ํ ์ด๋ธ ๋ถ๋ฌ์ค๊ธฐ
show databases;
use login_lecture;
CREATE TABLE users (
id varchar(30) NOT NULL,
name varchar(30) NOT NULL,
psword varchar(30) NOT NULL,
in_date datetime DEFAULT current_timestamp,
PRIMARY KEY(id)
);
show tables;
desc users;
INSERT INTO users( id, name, psword)
values("gani", "๊ฐ๋", "1234"),
("gaeun", "๊ฐ์", "123"),
("gan", "๊ฐ", "12"),
("ganigani", "๊ฐ์ผ๋", "1212"),
("lee gaeun", "์ด๊ฐ์", "12334"),
("lee gan", "์ด๊ฐ", "123444");
SELECT * FROM users;
728x90
๋ฐ์ํ
'๐ฉโ๐ป ์ปดํจํฐ ๊ตฌ์กฐ > About Computer' ์นดํ ๊ณ ๋ฆฌ์ ๋ค๋ฅธ ๊ธ
[์ปดํจํฐ ๊ตฌ์กฐ] CPU & ์ ์ถ๋ ฅ์ฅ์น & ๋ณด์กฐ๊ธฐ์ต์ฅ์น (0) | 2023.03.06 |
---|---|
[์ปดํจํฐ ๊ตฌ์กฐ] ๋ฐ์ดํฐ์ ๋ช ๋ น์ด ๋ฐ ๋ฉ๋ชจ (0) | 2023.03.06 |
Python์ ๋๊ธฐ์ ๋น๋๊ธฐ๋ (0) | 2022.11.22 |
javascript์ ๋๊ธฐ์ ๋น๋๊ธฐ๋ (0) | 2022.11.22 |
์์ผ ํต์ (Socket)_TCP & UDP (0) | 2022.08.29 |
Comments