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

最新推荐文章于 2025-12-02 15:55:42 发布

原创最新推荐文章于 2025-12-02 15:55:42 发布 · 128 阅读

0 ·

CC 4.0 BY-SA版权

python 同时被 2 个专栏收录

313 篇文章

订阅专栏

web_html

86 篇文章

订阅专栏

本文详细记录了在Ubuntu环境下应用HeadFirstSQL教程进行MySQL操作的过程，包括SQL命令的执行，如数据的增删改查，以及对特定字段的更新。通过具体实例，如删除具有特定活动的clown_info条目，更新doughnut_ratings类型，调整drink_info成本等，深入探讨了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’;