NUMERIC vs TEXT in SQL

When assigning data type in SQL, I know that if you assign TEXT, the value should you give it should be in “”.
When data type is NUMERIC do you still need to add the “” ??

example:

CREATE TABLE clothes (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    type TEXT,
    design TEXT);
    
INSERT INTO clothes (type, design)
    VALUES ("dress", "pink polka dots");
INSERT INTO clothes (type, design)
    VALUES ("pants", "rainbow tie-dye");
INSERT INTO clothes (type, design)
    VALUES ("blazer", "black sequin");

ALTER TABLE clothes ADD price NUMERIC;
SELECT * FROM clothes;
UPDATE clothes SET price = 10 WHERE id = 1;
UPDATE clothes SET price = 20 WHERE id = 2;
UPDATE clothes SET price = 30 WHERE id = 3;
SELECT * FROM clothes;

should it be : update clothes set price = 10 where id = 1 ?
or
update clothes set price = "10" where id = 1 ?

The first line is correct. You can also use numeric calculations like 10 times a variable etc.

1 Like

thank you ! (20 characters)