Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

问好 #1

Open
nobodxbodon opened this issue Jan 30, 2023 · 0 comments
Open

问好 #1

nobodxbodon opened this issue Jan 30, 2023 · 0 comments

Comments

@nobodxbodon
Copy link

早先的一点 尝试,可将:

创建读者表,编号为自动递增的整数主键,邮箱为不重复不为空的文本,出生年为整数。将昵称为“喵喵”的读者记录的出生年改为2001。删除出生年小于2000的读者记录。删除读者表。

转为:

CREATE TABLE 读者 ( 编号 INTEGER PRIMARY KEY AUTOINCREMENT, 邮箱 TEXT UNIQUE NOT NULL, 出生年 INTEGER ); UPDATE 读者 SET 出生年 = 2001 WHERE 昵称 = "喵喵"; DELETE FROM 读者 WHERE 出生年 < 2000; DROP TABLE 读者;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant