database zip files? // mySQL create table

[Trevor DeVore]

On Jan 2, 2007, at 4:49 AM, Ruslan Zasukhin wrote:

> 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.

They aren't actually single quotes.  It is ASCII 96.  This is the  
default MySQL behavior but I imagine you can change this behavior in  
the database settings though.

-- 
Trevor DeVore
Blue Mango Learning Systems - www.bluemangolearning.com
trevor at bluemangolearning.com