I just tried it and it works fine. It doesn't solve my similar problem,
which is related to letters coming *before* numbers, but the parser doesn't
reject it.
Wish I could offer a solution, but I'm not very knowledgable about MySQL
internals config.
-Derek
-Original Message-
From:
Hi All,
I've built a survey application in MySQL that allows people to enter
free-form comments. In processing the input, if the comments string is less
than 256 characters long, I save it to a varchar column; if longer, I use a
mediumtext.
This works fine, but I'm wondering if I'm getting any
Where might I find information about optimizing inserts to MySQL tables.
In Paul DuBois's excellent MySQL from New Riders, there is a section about
loading data efficiently in which he talks a little about inserts. In a
nutshell, LOAD DATA is faster than INSERT, the fewer the indexes the
I have db that has two tables that I am needing to post the same
information
into both tables, I can't use ID. So I am want to see if there is a sql
statement that will let me or how I can do with a php page.
I'm not a SQL guru, but I'm pretty sure SQL doesn't allow this. (Objects in
Hi All,
This is a little OT, but I'm looking for a report writer/server for
Apache/MySQL. There are lots of report writer/servers out there, but the
ones I've found so far either 1) work only on Windoze or 2) cost a lot of
money. I'm just looking for a basic tool that allows me to design