Gossamer Forum
(Advanced Search)
for
Home : General : Databases and SQL :

CREATE TABLE....

Jan 13, 2003, 3:17 PM
Andy
Veteran / Moderator (18441 posts)
Andy's avatar
Jan 13, 2003, 3:17 PM
Post #1 of 11
Views: 13942
Shortcut
Quote Reply
CREATE TABLE....
Can anyone see a problem with this SQL code? I'm using PHPMyAdmin, which seems to play around with the codes a little. Anyone got any ideas? (this is for a script I'm trying to install on my server....not just creating certain entries).

CREATE TABLE account_type (
id integer unique default nextval ('serial') PRIMARY KEY,
tag VARCHAR (50) NOT NULL
);


Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Jan 13, 2003, 4:44 PM
Paul
Veteran (19537 posts)
Jan 13, 2003, 4:44 PM
Post #2 of 11
Views: 13362
Shortcut
Quote Reply
Re: [Andy] CREATE TABLE.... In reply to
Your syntax for the id column is wrong.

What properties are you trying to use for the column and what are you wanting to achieve with nextval?

Last edited by:

Paul: Jan 13, 2003, 4:44 PM
Jan 14, 2003, 1:51 AM
Andy
Veteran / Moderator (18441 posts)
Andy's avatar
Jan 14, 2003, 1:51 AM
Post #3 of 11
Views: 13367
Shortcut
Quote Reply
Re: [Paul] CREATE TABLE.... In reply to
I don't really know. I'm simply using the .sql file included with the script (attached is the .sql file I'm trying to execute).

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!

Attached Files:

Jan 14, 2003, 1:58 AM
Paul
Veteran (19537 posts)
Jan 14, 2003, 1:58 AM
Post #4 of 11
Views: 13389
Shortcut
Quote Reply
Re: [Andy] CREATE TABLE.... In reply to
Erm, andy, that code is for POSTGRES not MySQL.
Jan 14, 2003, 2:04 AM
Andy
Veteran / Moderator (18441 posts)
Andy's avatar
Jan 14, 2003, 2:04 AM
Post #5 of 11
Views: 13343
Shortcut
Quote Reply
Re: [Paul] CREATE TABLE.... In reply to
Mmmm...interesting :/ Looking at it closer, it doesn't seem to support MySQL Crazy

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Jan 14, 2003, 2:55 AM
Paul
Veteran (19537 posts)
Jan 14, 2003, 2:55 AM
Post #6 of 11
Views: 13412
Shortcut
Quote Reply
Re: [Andy] CREATE TABLE.... In reply to
You didn't exactly have to look close. The first line says "Postgres"

Last edited by:

Paul: Jan 14, 2003, 2:57 AM
Jan 14, 2003, 3:00 AM
Andy
Veteran / Moderator (18441 posts)
Andy's avatar
Jan 14, 2003, 3:00 AM
Post #7 of 11
Views: 13378
Shortcut
Quote Reply
Re: [Paul] CREATE TABLE.... In reply to
Does anyone know of a good PHP/Perl and MySQL financial management tool in GPL?

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Jan 14, 2003, 3:18 AM
Paul
Veteran (19537 posts)
Jan 14, 2003, 3:18 AM
Post #8 of 11
Views: 13420
Shortcut
Quote Reply
Re: [Andy] CREATE TABLE.... In reply to
Financial management tool meaning?
Jan 14, 2003, 3:22 AM
Andy
Veteran / Moderator (18441 posts)
Andy's avatar
Jan 14, 2003, 3:22 AM
Post #9 of 11
Views: 13368
Shortcut
Quote Reply
Re: [Paul] CREATE TABLE.... In reply to
I.e ability to track account payments, statements, bills etc, via an online GUI. Basically a web-based version of Quicken, but obviously a bit more simple Wink

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Jan 14, 2003, 5:27 AM
Wil
Veteran / Moderator (4108 posts)
Jan 14, 2003, 5:27 AM
Post #10 of 11
Views: 13369
Shortcut
Quote Reply
Re: [Andy] CREATE TABLE.... In reply to
Sage? You'll need to spend some money, but recently I've personally found that spending money on a product that works saves me hours in trying to get a half-baked Sourceforge project to work.

- wil
Jan 14, 2003, 6:27 AM
Andy
Veteran / Moderator (18441 posts)
Andy's avatar
Jan 14, 2003, 6:27 AM
Post #11 of 11
Views: 13344
Shortcut
Quote Reply
Re: [Wil] CREATE TABLE.... In reply to
I don't/havn't really ever liked Sage. I would prefer Quicken really Tongue

Thanks for the idea though.

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!