MySql: Creating Tables

[sonique]

how do i create a table for mysql db
without using SSH
or Phpmyadmin?

[sonique]

anyone?

[Defender1]

you can do it with a php script.

something like:

$create_sql = "CREATE TABLE users (user_id INT (4) not null , username VARCHAR (32) not null , email VARCHAR (32) , PRIMARY KEY (user_id), UNIQUE (user_id))";
if(!$create_sql)
{
  echo mysql_error();
  exit;
} 

That'll create a table called users with 3 fields:
user_id which is a number, 4 characters long, not null (null means empty)
username which is a character field, 32 char. long, not null
and email which is a character field, 32 long, and can be null.

PRIMARY KEY makes the field in the () the primary key of the table, and UNIQUE specifies a field that can't be duplicated.

If for some reason the query fails it'll echo out the mysql error that cased the failure.

[Defender1]

also, here's mysql's support page for create table:
http://www.mysql.com/doc/C/R/CREATE_TABLE.html

[sonique]

Error
SQL-query : [Edit]

CREATE TABLE `users` (`user_id` INT(4) NOT NULL, `user_name` TEXT(32) NOT NULL, `email` TEXT(32) , PRIMARY KEY (`user_id`), UNIQUE (`user_id`)) comment = 'Training'

MySQL said:


You have an error in your SQL syntax near '(32) NOT NULL, `email` TEXT(32) , PRIMARY KEY (`user_id`), UNIQUE (`user_id`)) c' at line 1

what's the prob here?

[Defender1]

i'm not expert on the exact syntax, but why are you using the accent marks (`) around the field names?

I've created many tables fine w/o the use of them.

also, try moving the comment into the parentheses and see if that helps.

[seanf]

Originally posted by Defender1
i'm not expert on the exact syntax, but why are you using the accent marks (`) around the field names?

This is from phpMyAdmin

Sean

[Defender1]

heh, if he's using phpmyadmin, why does he want the code to do it?

[sonique]

i tried it myself, but i had no results....so i gave it a go in the admin thing......it works now
but i want to learn MySql without the use of the admin

[sonique]

also....
when i look at tut's it tells me to use a secure shell program.....which i don't want to do...

[Robo]

You get an error if you make column names with quotes around them, dispite what phpMyAdmin shows you.