Basic MYSql: create table

egwiens

I am learning MySql from Sams 24 hours. I can connect to my server and to my database. Now I want to create a table (the one on p199 of Sams).

I cannot telnet to my ISP.
Can I just put the create table statements onto a separate page (say crtable.php)
<?
create table domains (id INT NOT NULL AUTO_INCREMENT,
PRIMARY KEY( id ),
domain VARCHAR( 20 ),
sex CHAR(1),
mail VARCHAR (20) );
?>
If I “run” the page crtable.php, will I then have the table ‘domains’ in my database that I can the use in Listing 12.2 of Sams?

What I saw after a search seems to assume access to the “command line of UNIX on a unix box”, which I do not have.

brandonschnell

crtable.php
##################
<?
$username = "";
$password = "";
$db_name = "";

mysql_pconnect("localhost","$username","$password");

mysql_db_query("$db_name","CREATE table domains (id INT NOT NULL AUTO_INCREMENT,
PRIMARY KEY( id ),
domain VARCHAR( 20 ),
sex CHAR(1),
mail VARCHAR (20) )")
or die("Error! Reason: " . mysql_error());

egwiens

thanks.
1. Can I use mysql_connect instead of mysql_pconnect?
2. Shouldn't I do a mysql_select_db before I do the mysql_db_query?
3. How "persistent" is the persistent connection to mysql using mysql_pconnect?

brandonschnell

1) mysql_connect works, but mysql_pconnect will connect once then tries to find an existing connection on the next call to mysql_pconnect, i call mysql_pconnect at the top of each page to make sure i'm connected and also to reduce the number of connections to mysql. both work and you can use either one

2) mysql_db_query() will select the db specified in the first part of the mysql_db_query() call. i use it to ensure i'm connecting to the correct db before the call as some of my scripts need to change between various databases and it beats calling mysql_select_db before mysql_query every time. if you have just one db then using mysql_select_db then mysql_query for the queries on the rest of the page will be fine

3)http://www.php.net/manual/features.persistent-connections.php

egwiens

Thanks again. It works perfectly. It's absolutely brilliant!.

Anon

This worked perfectly for me too! I was suprised how long it took me to find an example of how to do this without telnet access. I looked all over php.net and mysql.com.

Thanks for the script!