MySQL ¦ Setting Fields, Parameters and Extras

Is this possible...

[madcat]

Is it possible to modify row and column parameters in MySQL after the table has been created? For example, setting the ID column to Auto-Increment. I have a script that converts Excel files to MySQL tables- but it creates both the table and field names without the option to tweak each parameter on each field prior to creation. I'm looking for a way to set up each column with the appropriate settings.

Thanks for any suggestions...

[ukgimp]

you can do that with phpMyAdmin

Pretty slick tool that allows you to do all of those sort of things plus run sql statements (handy when seeing if you have naused your php scripts up) and general admin, like flushing tables.

you can also use php command

ALTER TABLE table_name CHANGE field_name field_name CHAR (16) not null;

or whatever you want it to change to

Cheers

[madcat]

Perfect, yeah I'll see if I can get this fixed with phpmyadmin, thanks. Are there any good MySQL tutorials or links that you know about?

[Birdman]

Here's a link: [sqlcourse.com...]

Definitely phpMyAdmin. You can ALTER [mysql.com] your table easily.

[madcat]

I guess I just felt like neglecting mysql.com for the information ;)

Thanks for the links--

[txbakers]

I use mySql on Windows and use the mySqlFront for GUI and altering tables.

It's fabulous.

Most everything is in the mySql manual.

However, as my queries have become more sophisticated, the lack of basic functions such as sub-queries, and UNION commands is becoming more and more frustrating.