ALTER table my_contacts add column contact_id int not null auto_increment first, add primary key (contact_id);
SELECT * FROM MY_CONTACTS;
ALTER TABLE my_contacts add column phone varchar(10);
ALTER TABLE my_contacts add COLUMN phone varchar(10) after first_name; drop table cookie_sales; create table cookie_sales ( ID INT NOT NULL AUTO_INCREMENT, first_name varchar(10) not null, sales double not null, sale_date date not null, primary key (ID) );
select * from cookie_sales; -- insert into cookie_sales (first_name,sales,sale_date) values('Lindsay',32.05,'2007-3-6'); insert into cookie_sales (first_name,sales,sale_date) values('Paris',26.53,'2007-3-6'); insert into cookie_sales (first_name,sales,sale_date) values('Britney',11.25,'2007-3-6'); insert into cookie_sales (first_name,sales,sale_date) values('Nicole',18.96,'2007-3-6'); insert into cookie_sales (first_name,sales,sale_date) values('Lindsay',9.16,'2007-3-6'); insert into cookie_sales (first_name,sales,sale_date) values('Paris',1.52,'2007-3-6'); insert into cookie_sales (first_name,sales,sale_date) values('Britney',43.21,'2007-3-6'); insert into cookie_sales (first_name,sales,sale_date) values('Nicole',8.05,'2007-3-6'); insert into cookie_sales (first_name,sales,sale_date) values('Lindsay',17.62,'2007-3-6'); insert into cookie_sales (first_name,sales,sale_date) values('Paris',24.19,'2007-3-6'); insert into cookie_sales (first_name,sales,sale_date) values('Britney',3.40,'2007-3-6'); insert into cookie_sales (first_name,sales,sale_date) values('Nicole',15.21,'2007-3-6'); insert into cookie_sales (first_name,sales,sale_date) values('Lindsay',0,'2007-3-6'); insert into cookie_sales (first_name,sales,sale_date) values('Paris',31.99,'2007-3-6'); insert into cookie_sales (first_name,sales,sale_date) values('Britney',2.58,'2007-3-6'); insert into cookie_sales (first_name,sales,sale_date) values('Nicole',0,'2007-3-6'); insert into cookie_sales (first_name,sales,sale_date) values('Lindsay',2.34,'2007-3-6'); insert into cookie_sales (first_name,sales,sale_date) values('Paris',13.44,'2007-3-6'); insert into cookie_sales (first_name,sales,sale_date) values('Britney',8.78,'2007-3-6'); insert into cookie_sales (first_name,sales,sale_date) values('Nicole',26.82,'2007-3-6'); insert into cookie_sales (first_name,sales,sale_date) values('Lindsay',3.71,'2007-3-6'); insert into cookie_sales (first_name,sales,sale_date) values('Paris',0.56,'2007-3-6'); insert into cookie_sales (first_name,sales,sale_date) values('Britney',34.19,'2007-3-6'); insert into cookie_sales (first_name,sales,sale_date) values('Nicole',7.77,'2007-3-6'); insert into cookie_sales (first_name,sales,sale_date) values('Lindsay',16.23,'2007-3-6'); insert into cookie_sales (first_name,sales,sale_date) values('Paris',0,'2007-3-6'); insert into cookie_sales (first_name,sales,sale_date) values('Britney',4.50,'2007-3-6'); insert into cookie_sales (first_name,sales,sale_date) values('Nicole',19.22,'2007-3-6');
select * from cookie_sales;
select first_name, sum(sales) as sum_sales from cookie_sales group by first_name order by sum_sales desc;
select first_name,avg(sales)as avg_sales from cookie_sales group by first_name order by avg_sales desc;
create table interests( int_id int not null auto_increment primary key, interest varchar(50) not null, contact_id int not null, constraint my_contacts_contact_id_fk foreign key (contact_id) references my_contacts (contact_id) );
010.2073.24##로
변경되었습니다~
#송희
ㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡ
불가피하게 수정했습니다 _ _;)