mysql help?

[Jamie_Garland]

Hello,

How do i insert the field NOTES in to my sql database?

[kfcSmitty]

You want to add the field NOTES to the table, or you want to insert a value into the NOTES field within a currently existing table?

[Jamie_Garland]

i want to add Notes to the current table?

[kfcSmitty]

What kind of field is notes?

You can add a varchar field to a MySQL database using the below query

ALTER TABLE 'tableName' ADD 'Notes' VARCHAR(255);

[Jamie_Garland]

ill try it when i get home and let u know if it works.

[Sakesaru]

If that fails you could always use something like PHPMyAdmin or the Database browser that comes with MySQL to do it from a GUI.