> 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 fast
> 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
Post
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 relativ
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 r
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,
I'm getting some very strange (and nerve-wracking) behavior and hope
someone here has some ideas.
The subject says mysql_pconnect, but I get the same problem using
mysql_connect. I'm using PHP 4.2 & MySQL 3.23.44 on Red Hat 7.2
In PHP I have a simple db class that more or less serves as a wr
