7/10 LESSON about alter table


#1

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??


#2

Found with google search
sqlite Incorrect syntax near keyword "COLUMN" site:stackoverflow.com
https://stackoverflow.com/questions/794371/alter-table-add-column-syntax

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

++++ANALYZE in sqlite
http://stackoverflow.com/questions/17663379/how-to-understand-sqlite-explain-query-plan-result
http://www.sqlite.org/lang_analyze.html
http://www.sqlite.org/docs.html


#3

It worked!! Thanks a lot!


#4

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