creating tables

[[deleted]]

I'm learning mysql and i'm able to so far connect to the mysql server and create the database with success.

I want to create a table, but i'm a little confused as to what I should do.

I want to store email addresses for my newsletter in it.

What would I put for the table info?

$tablename= "emailaddresses";
$tableinfo = "";

eg..
$tableinfo = "CREATE TABLE %s(EMAIL CHAR(255), ROWID INT PRIMARY KEY AUTO_INCREMENT";

What does the stuff after EMAIL CHAR(255), mean? ...and is that what I need or should it be different?

Thanks!

[[deleted]]

I have already connected to the server and database.. now i want to create the table.

if (!mysql_query(sprintf($tinfo,$tname), $link)) {
printError(sprintf("Error in executing %s table info", $tinfo));
printError(sprintf("Error:%d %s", mysql_errno($link), mysql_error($link)));
exit;
}

[mp96brbj]

"ROWID ..." is a column with a unique ID for each row. It's always a good idea to have one of those in your table, so you can access any specific row, even if all the other columns happen to be identical.

Here is how I would create the table:
CREATE TABLE emailaddresses(
id INT NOT NULL DEFAULT 1 PRIMARY KEY AUTO_INCREMENT,
email VARCHAR(255) UNIQUE
);

I added the UNIQUE, because you wouldn't want to have the same e-mail address twice, right? Alternatively, you could search like this: "SELECT DISTINCT email
FROM emailaddresses;"

Mark wrote:

What would I put for the table info?

$tablename= "emailaddresses";

eg..
$tableinfo = "CREATE TABLE %s(EMAIL CHAR(255), ROWID INT PRIMARY KEY AUTO_INCREMENT";

What does the stuff after EMAIL CHAR(255), mean?