MySQL WHERE와 Alias

[주인장]

show tables;

-- 새로운 테이블 만들기

CREATE TABLE cats

(

cat_id INT AUTO_INCREMENT,

name VARCHAR(100),

breed VARCHAR(100),

age INT,

PRIMARY KEY(cat_id)

);

DESC cats;

-- 데이터 입력하기

INSERT INTO cats(name, breed, age)

VALUES ('Ringo', 'Tabby', 4),

('Cindy', 'Maine Coon', 10),

('Dumbledore', 'Maine Coon', 11),

('Egg', 'Persian', 4),

('Misty', 'Tabby', 13),

('George Michael', 'Ragdoll', 9),

('Jackson', 'Sphynx', 7);

-- SELECT 사용하기

SELECT * FROM cats;

SELECT age FROM cats;

SELECT name, age, breed FROM cats;

-- WHERE 사용하기

SELECT * FROM cats WHERE age = 4;

SELECT name FROM cats WHERE age = 4;

SELECT * FROM cats WHERE name = 'eGG';

SELECT * FROM cats WHERE name = 'Egg';

SELECT name, age FROM cats WHERE breed='Tabby';

SELECT cat_id, age FROM cats WHERE cat_id=age;

SELECT * FROM cats WHERE cat_id = age;

-- Alias

SELECT cat_id as id FROM cats;

SELECT cat_id as id, name as kittyName FROM cats;