I don't know what's wrong, why my statement won't insert. I have the following data:
username varchar length (25) password varchar length (25) fname varchar length (25) email text contactnum big int (30)
I don't know why my email is not inserting along with my contactnum here's the screenshot:
Based on what I understand the length is the number of characters in a data one can enter right?
What seems to be wrong on my query?
INSERT INTO members (username, password, fname, email, contactnum) VALUES (2, 2, 2, '[email protected]', 1)
if its string dont forget to use single quotation