I'm unable to add rows to the table created


#1

Hello every body, I'm unable to add rows to the table created

please do we need to define the server_name, usersname , password and a databasename? if yes what are their values?

I have created a table with
CREATE TABLE fgi (Matricle,name, location, email, tel);
the table is well created but there an error message 'Error: near line 1: no such table: fgi'
while trying to insert with
INSERT INTO fgi (matricle,name,location, email,tel) VALUES ('12G02113','Bertrand Ndakena', 'Douala','ndakena@gmail.com',676610576); the error message is
'Error: near line 1: no such table: fgi', infact same error, please kindly assist


4 create
#2

Your code runs:

sqlite> CREATE TABLE fgi (Matricle,name, location, email, tel);
sqlite> INSERT INTO fgi (matricle,name,location, email,tel) VALUES ('12G02113','Bertrand Ndakena', 'Douala','ndakena@gmail.com',676610576);
sqlite> select * from fgi;
12G02113|Bertrand Ndakena|Douala|ndakena@gmail.com|676610576

How would one reproduce your problem? What are you trying to do? Where?


#3

@bertrandndakena
and maybe provide the output of

select * from sqlite_master;

#4

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