phpmyadmin mysql INSERT statement syntax error

advertisements

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