MySQL insert question

[CrimsonSoul]

A quick question that sounds rather silly but here goes:

I've got a large file of data to be inserted into various tables. Each of the values to be inserted is within quotes although some of the columns are integer.

Does MySQL adjust the input according to column type or will I need to parse the input to remove the quotes?

[________]

If you try to insert "1" (with the ") into a int field, the value will probably be set to 0.

[CrimsonSoul]

After some sleep I finally thought, why not try a sample insert and see (obvious really).

The insert is in the form of INSERT INTO table (column1, column2, ...) VALUES ('356', '456', ...);

column1 and column2 are integer fields.

The insert worked fine! You learn something new every day 🙂