creating table - can't

**Eric Kincl** · Jul 17 '05, 01:03 AM

Re: creating table - can't

Works fine for me... just tried it with phpMyAdmin... try not using quotes,
or single quotes? Then again I do believe im on MySQL 3.X... maybe thats
it?

-Eric Kincl

Andreas Paasch wrote:
[color=blue]
>
> I've read around, especially at mysql.com to see if there are any
> limitations to tablenames, one is 64 characters and the other one seems to
> be that a tablename can't exist only numeric.
>
> So, within PHP I try to create a table with name "12345-name" and it fails
> entirely.
>
> It get's me rather puzzled as it should be possible according to the mysql
> manual.
> Of course, the table definition follows as it should. If i change the
> tablename to only "name" .. then I can create the table under Mysql
> 4.0.11a.
> But I want my tablenames to consist of faxnumber-name, nothing else.
>
> Is there anything I missed somewhere that prevents me from doing what I
> want?
>
> I'm sorta confused here ...
>
> /Andreas
>[/color]

**Andy Hassall** · Jul 17 '05, 01:03 AM

Re: creating table - can't

On Mon, 10 Nov 2003 23:39:34 +0100, Andreas Paasch <Andreas@Paasch .Net> wrote:
[color=blue]
>I've read around, especially at mysql.com to see if there are any
>limitations to tablenames, one is 64 characters and the other one seems to
>be that a tablename can't exist only numeric.
>
>So, within PHP I try to create a table with name "12345-name" and it fails
>entirely.[/color]

Post error messages and example code.

To create a table with a bad name like that requires quotes around the name.
The type of quotes depends on with what options the MySQL server was started.
If you ever need to quote identifiers, it almost always means you chose a bad
name for the identifier...
[color=blue]
>It get's me rather puzzled as it should be possible according to the mysql
>manual.
>Of course, the table definition follows as it should. If i change the
>tablename to only "name" .. then I can create the table under Mysql
>4.0.11a.
>But I want my tablenames to consist of faxnumber-name, nothing else.[/color]

Why are you encoding data in the table name?

--
Andy Hassall (andy@andyh.co. uk) icq(5747695) (http://www.andyh.co.uk)
Space: disk usage analysis tool (http://www.andyhsoftware.co.uk/space)

**Andreas Paasch** · Jul 17 '05, 01:03 AM

Re: creating table - can't

Andy Hassall wrote:
[color=blue]
> On Mon, 10 Nov 2003 23:39:34 +0100, Andreas Paasch <Andreas@Paasch .Net>
> wrote:
>[/color]
[snip][color=blue]
>
> Post error messages and example code.[/color]

Sorry, I decided not to post those as I didn't think they were of value as I
know the problem lies in the naming structure of the table to create ..
just showing it here anyways, just in case ....

Code part:

$query = "CREATE TABLE '$folder'
... then follows the table definition ...

in this instance is exactly $folder = "38747117-robertos"

[errormsg]
right syntax to use near ''38747117-robertos'
[/errormsg]

As mentioned, if I replace '$folder' with petersen, the table is created
perfectly, so it's gotta be the name of the table.

[color=blue]
>
> To create a table with a bad name like that requires quotes around the
> name.
> The type of quotes depends on with what options the MySQL server was
> started. If you ever need to quote identifiers, it almost always means you
> chose a bad name for the identifier...
>[/color]
[snip]

It's actually not data, it's a faxnumber to distinguish several conflicting
names. No workaround for the name ...

--
Registeret Linux user #292411

**Eric Kincl** · Jul 17 '05, 01:03 AM

Re: creating table - can't

Semicolon?? Can't forget those little POSes now, can we?

-Eric Kincl

Andreas Paasch wrote:
[color=blue]
> Andy Hassall wrote:
>[color=green]
>> On Mon, 10 Nov 2003 23:39:34 +0100, Andreas Paasch <Andreas@Paasch .Net>
>> wrote:
>>[/color]
> [snip][color=green]
>>
>> Post error messages and example code.[/color]
>
> Sorry, I decided not to post those as I didn't think they were of value as
> I know the problem lies in the naming structure of the table to create ..
> just showing it here anyways, just in case ....
>
> Code part:
>

> $query = "CREATE TABLE '$folder'
> ... then follows the table definition ...
>

>
> in this instance is exactly $folder = "38747117-robertos"
>
> [errormsg]
> right syntax to use near ''38747117-robertos'
> [/errormsg]
>
> As mentioned, if I replace '$folder' with petersen, the table is created
> perfectly, so it's gotta be the name of the table.
>
>
>[color=green]
>>
>> To create a table with a bad name like that requires quotes around the
>> name.
>> The type of quotes depends on with what options the MySQL server was
>> started. If you ever need to quote identifiers, it almost always means
>> you chose a bad name for the identifier...
>>[/color]
> [snip]
>
> It's actually not data, it's a faxnumber to distinguish several
> conflicting names. No workaround for the name ...
>
>
>[/color]

**Andy Hassall** · Jul 17 '05, 01:03 AM

Re: creating table - can't

On Tue, 11 Nov 2003 00:02:09 +0100, Andreas Paasch <Andreas@Paasch .Net> wrote:
[color=blue]
>Andy Hassall wrote:
>[color=green]
>> On Mon, 10 Nov 2003 23:39:34 +0100, Andreas Paasch <Andreas@Paasch .Net>
>> wrote:
>>[/color]
>[snip][color=green]
>>
>> Post error messages and example code.[/color]
>
>Sorry, I decided not to post those as I didn't think they were of value as I
>know the problem lies in the naming structure of the table to create ..
>just showing it here anyways, just in case ....
>
>Code part:
>

> $query = "CREATE TABLE '$folder'
> ... then follows the table definition ...
>

[/color]

Single quotes '' are for string literals, not identifiers.

In ANSI mode, quoted identifiers are surrounded by double quotes "" (as in
many other databases).

MySQL tends to use backticks `` though.

See the manual.

fw_error_www

http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Legal_names

[color=blue]
>in this instance is exactly $folder = "38747117-robertos"
>
>[errormsg]
> right syntax to use near ''38747117-robertos'
>[/errormsg][/color]

Doesn't look like a MySQL 3.x error, what version are you running? You're also
missing the start of the error message.
[color=blue]
>It's actually not data, it's a faxnumber to distinguish several conflicting
>names. No workaround for the name ...[/color]

You could always put the number at the end and drop the '-' so it's a normal
name, e.g. robertos3874711 7.

Looks like 'robertos' is a case of encoding data in a name too, then?

--
Andy Hassall (andy@andyh.co. uk) icq(5747695) (http://www.andyh.co.uk)
Space: disk usage analysis tool (http://www.andyhsoftware.co.uk/space)

**Andreas Paasch** · Jul 17 '05, 01:03 AM

Re: creating table - can't

Andy Hassall wrote:
[color=blue]
> On Tue, 11 Nov 2003 00:02:09 +0100, Andreas Paasch <Andreas@Paasch .Net>
> wrote:
>[/color]

[snip]

[color=blue]
> Single quotes '' are for string literals, not identifiers.
>
> In ANSI mode, quoted identifiers are surrounded by double quotes "" (as
> in
> many other databases).
>
> MySQL tends to use backticks `` though.
>
> See the manual.
>[/color]
http://www.mysql.com/documentation/m...ml#Legal_names[color=blue]
>[/color]

The backtic did the trick ... first time I realized that a single quote
isn't a single quote, it's actually a backtick.

Thanks a lot.

/Andreas

--
Registeret Linux user #292411

**Terence** · Jul 17 '05, 01:03 AM

Re: creating table - can't

Andreas Paasch wrote:
[color=blue]
> So, within PHP I try to create a table with name "12345-name" and it fails
> entirely.[/color]

Can I assume you are creating tables at runtime?
Unless you are explicityly doing this to handle bulk ware-house type
stuff, then you'r probably going about things the wrong way. You should
be able to scale your data without need to add entities (ie. modify your
data structure).

What is it that you are really trying to do?

**Andreas Paasch** · Jul 17 '05, 01:03 AM

Re: creating table - can't

Terence wrote:
[color=blue]
> Andreas Paasch wrote:
>[color=green]
>> So, within PHP I try to create a table with name "12345-name" and it
>> fails entirely.[/color]
>
> Can I assume you are creating tables at runtime?
> Unless you are explicityly doing this to handle bulk ware-house type
> stuff, then you'r probably going about things the wrong way. You should
> be able to scale your data without need to add entities (ie. modify your
> data structure).
>
> What is it that you are really trying to do?[/color]

What I'm really trying to do is write some administrative pages that handle
my import and selection of data based on a cvs-file.

As I assume to get more and more customer into my system, it's a lot easier
to automate the procedure.
So I create a customer and import that customers cvs-file according to a
very special structure which is written into the cvs-filename.
That file name in turn is split and creates then the folder structure for
easy access later on and in order to keep consensus.

I doubt I go about it the wrong way, just lack some in-depth understanding
....

/Andreas

--
Registeret Linux user #292411

**David Mackenzie** · Jul 17 '05, 01:05 AM

Re: creating table - can't

On Tue, 11 Nov 2003 10:44:55 +0100, Andreas Paasch
<Andreas@Paasch .Net> wrote:
[color=blue]
>What I'm really trying to do is write some administrative pages that handle
>my import and selection of data based on a cvs-file.
>
>As I assume to get more and more customer into my system, it's a lot easier
>to automate the procedure.
>So I create a customer and import that customers cvs-file according to a
>very special structure which is written into the cvs-filename.
>That file name in turn is split and creates then the folder structure for
>easy access later on and in order to keep consensus.[/color]

I think you're equating database tables to filesystem folders. A
relational database isn't a filesystem. If you are creating customers,
you should have a single `customer` entity (table).

This table would have fields such as customer id, name, etc.

As you create customers, add records to this table.

Your database design should reflect the logical view of the data, as
opposed to how it is physically stored.

--
David ( @priz.co.uk )
The Internet Prisoner Database: http://www.priz.co.uk/ipdb/
The Tarbrax Chronicle: http://www.tarbraxchronicle.com/

**Terence** · Jul 17 '05, 01:05 AM

Re: creating table - can't

Andreas Paasch wrote:[color=blue]
> Terence wrote:
>
>[color=green]
>>Andreas Paasch wrote:
>>
>>[color=darkred]
>>>So, within PHP I try to create a table with name "12345-name" and it
>>>fails entirely.[/color]
>>
>>Can I assume you are creating tables at runtime?
>>Unless you are explicityly doing this to handle bulk ware-house type
>>stuff, then you'r probably going about things the wrong way. You should
>>be able to scale your data without need to add entities (ie. modify your
>>data structure).
>>
>>What is it that you are really trying to do?[/color]
>
>
>
> What I'm really trying to do is write some administrative pages that handle
> my import and selection of data based on a cvs-file.
>
> As I assume to get more and more customer into my system, it's a lot easier
> to automate the procedure.
> So I create a customer and import that customers cvs-file according to a
> very special structure which is written into the cvs-filename.
> That file name in turn is split and creates then the folder structure for
> easy access later on and in order to keep consensus.
>
> I doubt I go about it the wrong way, just lack some in-depth understanding
> ...
>
> /Andreas
>[/color]

You don't want a relational database system, you want a native XML
database system.

Apache Xindice

http://xml.apache.org/xindice/

or

eXist-db - The Open Source Native XML Database

http://exist.sourceforge.net/

High-performance native XML database engine and all-in-one solution for building applications.

There are commercial ones if you need hardcore scalability. Tamino is
the best one I've seen -- it's not cheap.

creating table - can't

creating table - can't

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment