Grant Peel wrote:
Hi all,
I recently migrated a script called perldesk from mysql 4 to mysql 5.
When I envoke the script from the web, I am now getting an error. I suspect
its a version syntax thing.
Here is what I see:
Couldn't execute statement: You have an error in your SQL
Michael Dykman wrote:
One problem you might be having is the column named 'call'.. It's a
keyword, so perhaps you might get away with backticking it?ie.
`call`
Also, you shouldn't need that final semi-colon inside your statement
string.. I have had preparedstatement interfaces give me
On 04/21/2010 02:21 PM, Tom Worster wrote:
I'd go with the 4G 4-core server. If you're running apache and a sensible
OS, the extra cores can be helpful. So, unless you know you have a need for
very large key buffers, 4G should leave the OS plenty for FS cache.
Not that I actually have a
On 04/05/2010 02:06 PM, chen jia wrote:
Hi there,
I run simple statement like this:
create table c
select * from a
union
select * from b;
where table a has 90,402,534 rows, and table b has 33,358,725 rows.
Both tables have the same three variables.
It's taken a long time, more
On 01/29/2010 07:24 PM, Shawn Green wrote:
Rudy Lippan wrote:
On 01/29/2010 02:57 PM, Chris W wrote:
Hardcore stupid if you ask me. I suppose it is possible to have a
valid reason (can't imagine what it might be) for using more than 61
How about complex data requirements? Depending
On 01/29/2010 02:57 PM, Chris W wrote:
Hardcore stupid if you ask me. I suppose it is possible to have a
valid reason (can't imagine what it might be) for using more than 61
How about complex data requirements? Depending on the resolution of
your data set, I could see a simple person-type
On Fri, 24 Aug 2007, Michael Dykman wrote:
calculating the max key + 1 , as it has been noted, must be done
transactionally and will therefore require a transactional table
And with a transaction isolation level greater than Read Commited...
-r
--
MySQL General Mailing List
For list
If this trend is real, it doesn't seem like a very good trend to me. For
example, if you were keeping track of parts in a warehouse, why would anyone
make a table that looked like this:
ID (autogenerated PK) PART_NOPART_DESCRIPTION
1 A01
On Thu, 9 Jun 2005, Philippe de Rochambeau wrote:
Hello,
is there a way to switch from emacs binding to the vi binding in mysql?
The mysql client should pick up your .inputrc settings. 'man readline' for more
info.
-r
--
MySQL General Mailing List
For list archives:
On Thu, 6 Jan 2005, sam wun wrote:
Steve Buehler wrote:
At 08:11 PM 1/5/2005, you wrote:
Hi list,
How can I traverse the recordset moret than once?
For example, the recordset $sth is returned from executing the sql
statement.
The following statement is writen with the for
On Mon, 15 Nov 2004, Patrick Galbraith wrote:
William,
I'm not sure about this, because it involves windows/active state, and
those ppm packages used for active state perl are pre-compiled to run.
I'll talk to the current maintainer about this and see if he knows
about how active state
On Mon, 3 May 2004, Leon Sonntag wrote:
I am having problems with installing the DBD::MySQL Perl module. My system
is: RedHat 8 (patched current) Perl 5.8.4 (installed from RPM but upgraded
manually) Apache 2.0.40 Modperl 1.99
I am heading toward being able to install Best Practicals
On Mon, 29 Sep 2003, Kevin wrote:
I've fixed my swapping issues, but the system continues to get stuck in
a 'sending data' phase from time to time.
With mod_perl + mysql, this phase SHOULD be when mysql collects the rows
(after sorting, etc) and sends them to the perl handler for
On Mon, 24 Mar 2003, Casella, Richard A wrote:
I am having a problem getting this to work and the documentation
I have found doesn't seem to be helping, hopefully someone out there
can help me.
I am using MySQL 4.01-Gamma on a Debian Linux box. I have configured
MySQL exactly as the manual
14 matches
Mail list logo