Gossamer Forum: General: Databases and SQL: CREATE TABLE....

Jan 13, 2003, 3:17 PM

Andy

Veteran / Moderator (17364 posts)

Jan 13, 2003, 3:17 PM

Post #1 of 11

Shortcut

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

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates

Jan 13, 2003, 4:44 PM

Paul

Veteran (19537 posts)

Jan 13, 2003, 4:44 PM

Post #2 of 11

Shortcut

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 (17364 posts)

Jan 14, 2003, 1:51 AM

Post #3 of 11

Shortcut

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

Jan 14, 2003, 1:58 AM

Paul

Veteran (19537 posts)

Jan 14, 2003, 1:58 AM

Post #4 of 11

Shortcut

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 (17364 posts)

Jan 14, 2003, 2:04 AM

Post #5 of 11

Shortcut

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

Jan 14, 2003, 2:55 AM

Paul

Veteran (19537 posts)

Jan 14, 2003, 2:55 AM

Post #6 of 11

Shortcut

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 (17364 posts)

Jan 14, 2003, 3:00 AM

Post #7 of 11

Shortcut

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

Jan 14, 2003, 3:18 AM

Paul

Veteran (19537 posts)

Jan 14, 2003, 3:18 AM

Post #8 of 11

Shortcut

Re: [Andy] CREATE TABLE.... In reply to

Financial management tool meaning?

Jan 14, 2003, 3:22 AM

Andy

Veteran / Moderator (17364 posts)

Jan 14, 2003, 3:22 AM

Post #9 of 11

Shortcut

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

Jan 14, 2003, 5:27 AM

Wil

Veteran / Moderator (4108 posts)

Jan 14, 2003, 5:27 AM

Post #10 of 11

Shortcut

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 (17364 posts)

Jan 14, 2003, 6:27 AM

Post #11 of 11

Shortcut

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

CREATE TABLE....

Last edited by:

Attached Files:

Last edited by: