When I type 'sqlite3 phonebook.db' at the command prompt and hit enter, I get: 'Enter SQL statements terminated with a ";"' and then I get a cursor that is not like yours. Mine looks like '...>' and when i type the 'create...' line and hit enter, it tells me: 'Error: near "sqlite3": syntax error.'
@jamin3d The only thing I can think of is that you were already at the sqlite3> prompt when you typed "sqlite3 phonebook.db". Usually, when you see "...>" it means that you are missing a semicolon. Type ";" a few times and it sometimes goes away.
When I type 'sqlite3 phonebook.db' at the command prompt and hit enter, I get: 'Enter SQL statements terminated with a ";"' and then I get a cursor that is not like yours. Mine looks like '...>' and when i type the 'create...' line and hit enter, it tells me: 'Error: near "sqlite3": syntax error.'
Any ideas what is going on?
jamin3d 1 year ago
@jamin3d The only thing I can think of is that you were already at the sqlite3> prompt when you typed "sqlite3 phonebook.db". Usually, when you see "...>" it means that you are missing a semicolon. Type ";" a few times and it sometimes goes away.
Jaynonymous1 1 year ago
@Jaynonymous1 thanks, I got it!
jamin3d 1 year ago
update phonebook set name="Fay Jones" where phone="333-1111" and name="Fay"
athulican 1 year ago
@athulican What was your comment?
Jaynonymous1 1 year ago
nice! thank you
AntonisAsc 1 year ago