Creating new tables and fields in mysql without going to phpmyadmin?

[BelovedDoll]

I am trying to simplify my coding work for my website and wanting to make it operate more professionally (as part of my training to better my programming skills, which I know will take a lot of time to do). One of the things I`d like to improve on it is to create tables and fields in my mysql database, but not have to go into phpmyadmin to do it. I know open source programs like Drupal can do this easily so that when you add modules, the user does not have to access the database to set it up. But looking at the codes, I`m unable to figure out how it works.

 

How will I be able to program my code to do something like, I`ll have a form where I enter in what I want the new table to be called, what fields to add in and their specifications, where I could do this by just going into my website as the admin?

[WatsonN]

after you connected use this code:

CREATE TABLE table_name
(
column_name1 data_type,
column_name2 data_type,
column_name3 data_type,
....
)

For example:

$sql = "CREATE TABLE Persons
(
FirstName varchar(15),
LastName varchar(15),
Age int
)";

[BelovedDoll]

Oh wow, that is so simple! Is that really all there is to it? That definitely would save me a lot of time and hassle.

[WatsonN]

Thats it 

[BelovedDoll]

Thanks very much! Is there a source where I can find a list of what specific terms I should use for the different field types? (Like int, varchar, etc?)

[trq]

http://dev.mysql.com/doc/refman/5.1/en/