mySQL Table Creator
The mySQL Table Creator allows you to enter field values and will output the code used to create the table. If you are using phpMyAdmin then you can just copy this code into the SQL box to automatically create the table.
However just because you can type whatever into the fields does not make it mySQL compatible code. This is a dumb calculator in the sense that it will not (as of yet) validate your code. For instance you can have multiple primary keys, and you can create text fields that automatically increment.
Also some field types require an argument, and others don't. Some only allow one and others two, however you can enter both values for every field type.
You can also read the forum posting that made this calculator possible.
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
