I was wondering if anyone might be able to offer some 'guidance'. I'm trying to create a few simple tables to demonstrate a bigger problem I'm having and when I try to create the first table I get my arch-nemesis, the dreaded ERROR 1064 (42000).
Here's the really simple table I'm trying to create:
CREATE TABLE atbl
(
atblnum INT UNSIGNED NOT NULL PRIMARY KEY,
description VARCHAR NULL,
btbl INT UNSIGNED NULL,
ctbl INT UNSIGNED NULL
);

Here's the error I'm getting:
mysql> source ~/prog/createtable.sql;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL,
btbl INT UNSIGNED NULL,
ctbl INT UNSIGNED NULL
)' at line 4

I swear I've created a hundred tables and I know I'm prone to stupid syntax errors, but for the life of me I can't see what I'm doing wrong here.

Chris

---
■ Synchronet ■ Diamond Mine Online BBS - bbs.dmine.net

Re: Mysql Table Creation Issue
By: Chris Perrault to All on Sat Oct 22 2011 07:06 pm

Ok, problem solved.
It was a dumb mistake as expected.
I needed to specify a length for VARCHAR:
description VARCHAR NULL,
Should have been:
description VARCHAR(20) NULL,
Of course '20' could have been any number between 1 and 255 according to my slightly out of date book.
Chris
/s

I was wondering if anyone might be able to offer some 'guidance'. I'm

trying > create a few simple tables to demonstrate a bigger problem I'm
having and wh

I try to create the first table I get my arch-nemesis, the dreaded ERROR 106 (42000).
Here's the really simple table I'm trying to create:
CREATE TABLE atbl
(
atblnum INT UNSIGNED NOT NULL PRIMARY KEY,
description VARCHAR NULL,
btbl INT UNSIGNED NULL,
ctbl INT UNSIGNED NULL
);

Here's the error I'm getting:
mysql> source ~/prog/createtable.sql;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual t corresponds to your MySQL server version for the right syntax to use near 'NULL,
btbl INT UNSIGNED NULL,
ctbl INT UNSIGNED NULL
)' at line 4

I swear I've created a hundred tables and I know I'm prone to stupid syntax errors, but for the life of me I can't see what I'm doing wrong here.

Chris

/***********************************************/
/* cdp - Diamond Mine BBS */
/* The Programmers' SIG @ DelphiForums */
/* http://forums.delphiforums.com/prosig/start */ /***********************************************/

---
■ Synchronet ■ Diamond Mine Online BBS - bbs.dmine.net

Re: Mysql Table Creation Issue
By: Chris Perrault to All on Sat Oct 22 2011 07:06 pm

Subject: Mysql Table Creation Issue
@VIA: DMINE
@MSGID: <4EA34C86.1488.dove-prg@dmine.net>
@TZ: c12c
I was wondering if anyone might be able to offer some 'guidance'. I'm trying create a few simple tables to demonstrate a bigger problem I'm having and wh I try to create the first table I get my arch-nemesis, the dreaded ERROR 106 (42000).
Here's the really simple table I'm trying to create:
CREATE TABLE atbl
(
atblnum INT UNSIGNED NOT NULL PRIMARY KEY,
description VARCHAR NULL,
btbl INT UNSIGNED NULL,
ctbl INT UNSIGNED NULL
);

Here's the error I'm getting:
mysql> source ~/prog/createtable.sql;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual t corresponds to your MySQL server version for the right syntax to use near 'NULL,
btbl INT UNSIGNED NULL,
ctbl INT UNSIGNED NULL
)' at line 4

I swear I've created a hundred tables and I know I'm prone to stupid syntax errors, but for the life of me I can't see what I'm doing wrong here.

Chris

try stronger nails.... lol

"Practise safe Lunch, Use a Condiment"


---
■ Synchronet ■ Three Stooges Gentlemens Club - Las Vegas, Nv - tsgc.dyndns.org

Re: Mysql Table Creation Issue
By: Corey to Chris Perrault on Sat Oct 22 2011 06:57 pm

Haha, sadly, I'm a better coder than woodworker. That's not saying much unfortunately...

try stronger nails.... lol

"Practise safe Lunch, Use a Condiment"

/***********************************************/
/* cdp - Diamond Mine BBS */
/* telnet://bbs.dmine.net */
/* The Programmers' SIG @ DelphiForums */
/* http://forums.delphiforums.com/prosig/start */ /***********************************************/

---
■ Synchronet ■ Diamond Mine Online BBS - bbs.dmine.net

On 10/22/2011 5:13 PM, Chris Perrault wrote:

Ok, problem solved.
It was a dumb mistake as expected.
I needed to specify a length for VARCHAR:
description VARCHAR NULL,
Should have been:
description VARCHAR(20) NULL,
Of course '20' could have been any number between 1 and 255 according to my slightly out of date book.

VARCHAR's and NVARCHAR's limits depend on the database in particular... in this case MySQL (still 255 limit, 256 - 1 for null byte.)... there may also be limits with regards to an index size on a varchar field.

MS-SQL introduced a VARCHAR/NVARCHAR(MAX) that basically combines varchar/nvarchar, and text/ntext for example.

YMMV.

--
Michael J. Ryan - http://tracker1.info/

---
■ Synchronet ■ Roughneck BBS - telnet://roughneckbbs.com - www.roughneckbbs.com

Re: Re: Mysql Table Creation Issue
By: Tracker1 to Chris Perrault on Thu Nov 17 2011 09:20 pm

Hi Michael,

MS-SQL introduced a VARCHAR/NVARCHAR(MAX) that basically combines varchar/nvarchar, and text/ntext for example.

YMMV.

--

This was the first I heard of NVARCHAR. I did a quick google of it and it sounds like the only difference is that it stores unicode characters. Does that sound right?

/***********************************************/
/* cdp - Diamond Mine BBS */
/* telnet://bbs.dmine.net */
/* The Programmers' SIG @ DelphiForums */
/* http://forums.delphiforums.com/prosig/start */ /***********************************************/

---
■ Synchronet ■ Diamond Mine Online BBS - bbs.dmine.net

On 11/18/2011 2:37 PM, Chris Perrault wrote:

Hi Michael,

MS-SQL introduced a VARCHAR/NVARCHAR(MAX) that basically combines
varchar/nvarchar, and text/ntext for example.

YMMV.

This was the first I heard of NVARCHAR. I did a quick google of it and it sounds like the only difference is that it stores unicode characters. Does that
sound right?

That's correct, essentially characters assume utf-16 format, so no encoding issues.

--
Michael J. Ryan - http://tracker1.info/

---
■ Synchronet ■ Roughneck BBS - telnet://roughneckbbs.com - www.roughneckbbs.com