Mevo Hafez
Mevo Hafez

Reputation: 161

Error in the sql command line

Every time I insert new data to my table using the command line, it is inserted successfully (and I check my insertion by typing select * from table_name;) but when I close the command line and open it again and write the sql statement which (select * from table_name;) it says that there are no rows selected. I mean the inserted row is not saved in the database.

Please can someone help me to know the problem?

Upvotes: 0

Views: 136

Answers (1)

Marcodor
Marcodor

Reputation: 5741

Use COMMIT; to apply your SQL statements

Upvotes: 2

Related Questions