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 propertie
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 popul
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 signl
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
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 thi
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;
>
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(
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-rt
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
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
i
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 vers
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 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 Databas
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
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 f
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
insta
Attempts to do make test prior to installation, to check that I'm
installing something workable, give:
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
Installi
18 matches
Mail list logo
