mysql ubuntu 应用记录 --- Head First SQL (三)

mysql ubuntu 应用记录 — Head First SQL (三)

vi clown_info.sql

去掉 ^@

vi 输入 :%s/^@//g

确定 ^M是使用 "CTRL-V CTRL-M" 而不是字面上的 ^M。这个正则式将替换所有回车符前的 ^M为空($是为了保证^M出现在行尾)

source /home/jack/sql/HeadFirstSQLTables/clown_info.sql
select * from clown_info ;

SELECT * FROM clown_info WHERE name = ‘Zippo’;
DELETE FROM clown_info WHERE activities = ‘dancing’;
DELETE FROM doughnut_ratings WHERE location = ‘Krispy King’ AND rating <> 6 ;

DELETE FROM clown_info WHERE activities = ‘yelling,dancing’ AND name = ‘Clarabelle’;
UPDATE doughnut_ratings SET type = ‘glazed’ WHERE type = ‘jelly’ ;

update clown_info set last_seen = ‘Tracy’s’ WHERE name = ‘MR. Hobo’ and last_seen = ‘Dickson Park’ ;

select * From clown_info ;

update drink_info set cost = 3.5 where drink_name = ‘Blue Moon’;

update drink_info set cost = cost + 1 where drink_name = ‘Blue Moon’ or drink_name = ‘Oh My Gosh’;