On Tue, 21 Feb 2006, Patrick Duda wrote:
Why, when I create a table as follows:
mysql create table requestid ( request_id int not null default 1,
constraint requestid_innodb_pk_cons primary key(request_id) ) ENGINE=InnoDB;
Query OK, 0 rows affected (0.02 sec)
Defines the properties of
I have a database backed-website in development. (It's Rails based,
but for this question it probably doesn't matter.) To make sure
things are clean during development I re-generate things from a
script. Some things I generate depend on tables existing. Other
things depend on tables being
On Sun, 18 Dec 2005, mos wrote:
How do I square a number in MySQL 4.1? I thought it would be something simple
like:
select 3**2
but that produces a syntax error. I can use Pow(3,2) but that produces a
float. Is there a Square function? TIA
mysql select floor(pow(3,2));
On Mon, 14 Nov 2005, [EMAIL PROTECTED] wrote:
We are making whole database sql dump every night.
Now I have a bunch of sql dumps, that covers much space.
Is there opensource tools with whom I could make one
smaller differencial backup file with possibility to
get dump from every signle
I'm fairly new to MySQL and am getting an error messages like:
ERROR 1064 (42000) at line 5: You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for
the right syntax to use near 'id int(14) unsigned NOT NULL auto_increment,
forename varchar(40)
On Thu, 13 Oct 2005, [EMAIL PROTECTED] wrote:
Hugh Sasse [EMAIL PROTECTED] wrote on 13/10/2005 16:27:44:
I'm fairly new to MySQL and am getting an error messages like:
ERROR 1064 (42000) at line 5: You have an error in your SQL syntax;
check the manual that corresponds to your MySQL
On Thu, 13 Oct 2005, [EMAIL PROTECTED] wrote:
MySQL does not normally use (double quotes) as name identifiers, it
uses ` `(backticks). Change all of your to ` to make your syntax
correct. That would mean that part of your original statement will look
like
Thank you.
In this case
On Thu, 13 Oct 2005, Peter Brawley wrote:
Hugh,
Agreed that the MySQL error reporter is primitive, and that 'lint for MySQL'
If I were familiar with the code base I'd happy send patches, but I
was hoping improve diagnostics might get nudged up somebody's
list by raising it.
would be a
On Tue, 20 Sep 2005, Dan Nelson wrote:
In the last episode (Sep 20), Hugh Sasse said:
So I started again and built using this script:
#!/bin/bash
CFLAGS=-O3 -L$LD_LIBRARY_PATH CXX=gcc MAKE=gmake \
CXXFLAGS=-O3 -L$LD_LIBRARY_PATH -felide-constructors -fno-exceptions
-fno-rtti ./configure
On solaris 9 Sparc I built originally by modifying
mysql-4.1.14/BUILD/compile-solaris-sparc thusly
neelix hgs 81 % display_diffs.rb .
--- ./compile-solaris-sparc.orig2005-08-17 18:06:41.0 +0100
+++ ./compile-solaris-sparc 2005-09-06 18:36:25.386697000 +0100
@@ -11,6 +11,6 @@
On Tue, 20 Sep 2005, David Logan wrote:
Hugh Sasse wrote:
On solaris 9 Sparc I built originally by modifying
mysql-4.1.14/BUILD/compile-solaris-sparc thusly
[...]
gmake -j 4
neelix hgs 82 %
and I invoked the script directly, and also tried with bash.
I have:
GNU Make version
On Tue, 20 Sep 2005, Pooly wrote:
Hi,
gmake: *** [all] Error 2
neelix hgs 57 % ls /usr/lib/*pthread*
/usr/lib/libpthread.so /usr/lib/llib-lpthread
/usr/lib/libpthread.so.1 /usr/lib/llib-lpthread.ln
neelix hgs 58 %
Any suggestions as to how I get around this and get the whole thing
On Tue, 20 Sep 2005, Hugh Sasse wrote:
On Tue, 20 Sep 2005, Pooly wrote:
Hi,
gmake: *** [all] Error 2
neelix hgs 57 % ls /usr/lib/*pthread*
/usr/lib/libpthread.so /usr/lib/llib-lpthread
/usr/lib/libpthread.so.1 /usr/lib/llib-lpthread.ln
neelix hgs 58 %
[...]
I guess you're
On Fri, 9 Sep 2005, Michael Stassen wrote:
With mysql 4.1.12, `make -n test` reveals
cd mysql-test; ./mysql-test-run ./mysql-test-run --ps-protocol
For the record, here's what I got on Solaris 9 for 4.1.13
neelix hgs 18 % cd mysql-test ./mysql-test-run --force
Installing Test Databases
I've see no reply to this and I checked the archives, so please
excuse my resubmitting it. Maybe I shouldn't be using 4.1.14 but
4.0.x?
Thank you,
Hugh
On Wed, 7 Sep 2005, Hugh Sasse wrote:
Attempts to do make test prior to installation, to check that I'm
installing something
On Fri, 9 Sep 2005, Michael Stassen wrote:
Hugh,
I get the same thing on Mac OS X 10.3.9. My thinking was that rather than
replying with an unhelpful Me too, I would do some digging and then reply
with what I found. I realize now that left you hanging (sorry), so I'll
report what I've
On Fri, 9 Sep 2005, Joerg Bruehe wrote:
Michael,
you beat me in replying, and saved me from typing the analysis - thanks!
Michael Stassen wrote:
[[...]]
The test suite is broken.
Well, I would not put it that way - a diplomatic wording is:
The tool to run the test suite does not run as
Attempts to do make test prior to installation, to check that I'm
installing something workable, give:
quote
neelix hgs 63 % gmake test
cd mysql-test; perl mysql-test-run.pl perl mysql-test-run.pl --ps-protocol
No ndbcluster support
Killing Possible Leftover Processes
Removing Stale Files
18 matches
Mail list logo