Re: IMPORT TABLE INTO MySQL

[Mark Snyder]

I guess I can't believe that you can't believe... :-) It would be like a moving van full of a family's belongings showing up to a deserted lot and expecting the movers to build the house the stuff was to go into.

Another way to look at it: how smart would this 'import utility' have to be? It would have to know how to figure the maximum size for each field, which one should be the primary key, which ones could be NULL, which ones could only have a set list of values, which ones to auto increment...

I'm not sure about the free vs. pay aspect. I haven't worked with Oracle for a while; but I remember creating tables with it too. MySQL, like most open source endeavors, is geared at being a lean, efficient program. I don't think it will take you that long to sit down and determine for your 35 fields what type of data it is, what the max size should be, and develop the CREATE TABLE command required.