database zip files? // mySQL create table

[Ruslan Zasukhin]

On 07/2/1 1:49 PM, "Robert Mann" <robmann at gp-racing.com> wrote:

> yes OBDC import
> problems start right with the first field

CREATE TABLE `stockvalving` (
  `record_id` bigint(20) NOT NULL default '0',
  `orig_record_id` bigint(20) default NULL,
  `date` timestamp NOT NULL default CURRENT_TIMESTAMP on update
CURRENT_TIMESTAMP,
  `access` int(10) default '0',
  `tunername` varchar(20) default NULL,


-------------
Another anomaly of mySQL:

    they use single quotes around names
    even somehow not usual single quotes.

SQL92 require here to use DOUBLE quotes.



-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]