MySQL
is available with the Ecommerce and Max Plan. To begin using
MySQL, please follow these simple steps:
 File a technical support request asking that
your MySQL database to be created.
Include the password
you wish to use for this database.
The database will be named the same as your account
userID. The only
exception is if
there is a "-" in your username. The "-" will be replaced
by a "_".
The database will run on the web server that
your account is on.
If
you are using PERL, start your script by using the following
code:
use
DBI;
$dbh = DBI->connect('YOUR_USERID', 'YOUR_USERID', 'YOUR_PASSWORD',
'mysql');
To
select data out of a table:
$query
= "select * from table";
$sth = $dbh->prepare($query);
$rs = $sth->execute;
@data = $sth->fetchrow;
To
insert data into a table:
$query
= "insert into table values ('value1', 'value2')";
$sth = $dbh->do($query);
|
