Hi there, i am using sqlite3 online compiling. I wanted to create a table where one of the employee has a value of unknown salary.
Here are my sqlite3 codes.
where John Doe works at Burger Steak but his salary is unknown.
BEGIN TRANSACTION; /* Create a table called Works */ CREATE TABLE Works(employee_name text, company_name text, salary varchar); /* Create few records in this table */ INSERT INTO Works VALUES('John Smith', 'Starbucks Coffee', '2000 USD'); INSERT INTO Works VALUES('Peter Cruz', 'Mc Donalds', '3000 USD'); INSERT INTO Works VALUES('John Doe', 'Burger Steak', ''); COMMIT;
The output is
John Smith|Starbucks Coffee|2000 USD
Peter Cruz|Mc Donalds|3000 USD
John Doe|Burger Steak|
Am i doing this right? Is the unknown salary should be leave blank? what about NULL values, how i could apply it here.