Hi,
I am trying to create tables on a new database using SQL statements embedded
into Perl scripts. The problem I am having is that only the first six
fields/columns of the table can be populated, any following fields/columns
remain empty. This is happening on all the table I have created, despite the
fact that SHOW COLUMNS returns the correct table definition.
An SQL statement that I have tried is listed below (Each statement is run
from a seperate script);
$sqldata = $dbh->prepare("CREATE TABLE jobs (jobref INT PRIMARY KEY,jobtitle
VARCHAR(40),rate INT,period VARCHAR(10),cp VARCHAR(10),description
TEXT,location VARCHAR(40),startdate CHAR(8))");
$sqldata->execute;
$sqlinsert = $dbh->prepare("INSERT INTO
jobs(jobref,jobtitle,rate,period,cp,description,location,startdate) VALUES
($num,'Test Engineer','20','per hour','contract','To test radar sets to
component level','West London','12/01/01')");
$sqlinsert->execute;
I have tried these statements on tow different servers with independent
MySQL databases with the same results.
I am would be very grateful for any thoughts, ideas, answers as to why I
cannot populate fields/columns after the first six in the table.
Thanks for your troubles,
Mark Dressel
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
