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 gi
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
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 ti
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 t
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-ty
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 archives
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: http://lists.my
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
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 s
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 proces
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 m
14 matches
Mail list logo
