7/10 LESSON about alter table

I stuck in celebs table stage 7/10.
After creating the table, I tried to enter the following code to SQL, which I had been using to practice what I learned:

ALTER TABLE celebs ADD COLUMN twitter_handle TEXT;

SELECT * FROM celebs;

However, SQL reported error saying: Incorrect syntax near keyword “COLUMN” although the tutorial let me pass. Anybody know why??

Found with google search
sqlite Incorrect syntax near keyword “COLUMN” site:stackoverflow.com

+++ show all table defintions
select * from sqlite_master;

++++ANALYZE in sqlite

It worked!! Thanks a lot!

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.