MySQL's Documentation:
A name may start with any character that is legal in a name. In particular,
a name may start with a number (this differs from many other database
systems!). However, a name cannot consist only of numbers.
MyQuestion:
Why can't a column name be just a number?
For example:
Has anyone setup MySQL 3.23.44 with ColdFusion 5.0 Enterprise Edition. I
have heard that there may be problems with transactions. I was wondering if
anyone knew how to do this, and if they could point me to some reading
material.
I was also wondering if MySQL 4.0 would include transactions and
mysql create database colors;
Query OK, 1 row affected (0.01 sec)
mysql use colors
Database changed
mysql CREATE TABLE Colors(
-
- cid INT UNSIGNED NOT NULL,
- data VARCHAR(10) NOT NULL
- );
Query OK, 0 rows affected (0.06 sec)
mysql insert into Colors
am trying to design a good database, that has a matrix of data per record.
For example, 1 record already has 80x43 = 3440 datafields which each need to
hold real numbers. The way I would do it would be to hold a row of 3440
columns, but I do not know if that will be a mistake or if that would
mysql create database colors;
Query OK, 1 row affected (0.01 sec)
mysql use colors
Database changed
mysql CREATE TABLE Colors(
-
- cid INT UNSIGNED NOT NULL,
- data VARCHAR(10) NOT NULL
- );
Query OK, 0 rows affected (0.06 sec)
mysql insert into Colors
Sorry I misread what the question was asking since I have run into MySQL
related problems that are not problems in other databases, so I just wanted
to check that out. You would have to have some function that could read a
resultset similar to the select * from colors where data !='blue'; since