sec)
Defines the properties of an empty table
The request id field for an inserted object will default to one if not
supplied. But the object must be supplied.
Hugh
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
p building instructions, of course, so it's
tricky to find the answer to this.
This is with Mysql 4.1.x, cygwin and Solaris.
Thank you
Hugh
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ointed by the responses that failed to recognise this as
the simplest specification for a more complicated case.
Hugh
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
dump from every signle day?
SCCS, RCS, cvs, svn. All of these use differential systems for
archiving versions of a file. I've links to information at
http://www.eng.cse.dmu.ac.uk/~hgs/#RCS
if that's any help.
>
> Any ideas?:)
>
> Thankyou!
> Aktvists
>
Hu
-side function and tried to run
it, but it only works so long as I log in as root. Any other user throws up an
error, regardless of permissions granted. And even logged in as root, I cannot
GRANT permission to EXECUTE for any other user.
What's happening here???
Hugh de Saram
--
MyS
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
ame (
>
> which made your first column definition (the id column) appear on line 2.
> Make better sense?
Yes. Thank you.
>
> For more details on ` vs. " please read
> http://dev.mysql.com/doc/refman/4.1/en/legal-names.html
>
Thank you, I'm off there now.
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;
>
the rest is missing. My editor's syntax highlighter doesn't
show anything awful. This is actually for lines 7 and 8 of the
input, the first 4 lines being comments, so the numbering in the
output is wrong.
Are there any tools (like lint for C) to be more verbose and helpful
about this?
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
linker can't do it's job here.
--
Pooly
Thank you,
Hugh
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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
tch/hgs/mysql-4.1.13'
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
ins
utting-down MySQL daemon
Master shutdown finished
Slave shutdown finished
All 282 tests were successful.
neelix hgs 19 %>
So that seems to be OK to me. Innodb looks like is is there and
working so I'll proceed with installation.
Thank you,
Hugh
--
MySQL General Mail
un as it should."
I understand that the effect for Hugh and you is the same ;-)
Nobody was claiming *deliberate* breakage! :-)
[...]
quite a few commented-out, "fix me" sections.
Correct. A Perl script for the test suite is being worked on. Reasons:
1) A shell script
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
r
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
d I invoked the script directly, and also tried with bash.
Not sure what else to pass on.
GNU Make version 3.79.1, by Richard Stallman and Roland McGrath.
Built for sparc-sun-solaris2.9
gcc (GCC) 3.4.3
Thank you
Hugh
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
After much searching (and trying to read non-English posts), I've
stumbled across the solution. I installed the mysql-MAX rpm, changed the
my.cnf file and Viola! it works!
--
Hugh
mailto: [EMAIL PROTECTED]
Hugh Taylor wrote:
Running MySQL 4.0.15 on SuSE 9 Professional. MySQL works fine un
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
This is how it looks when I try to enable innodb, however, MySQL won't
start with them uncommented, but it runs fine when I comment them out.
--
Hugh
mailto: [EMAIL PROTECTED]
Victor Pendleton wrote:
Can you post the
mysqldaemon816 2004-06-28 15:29 phpmyadmin
drwx--2 mysqldaemon 48 2003-11-12 18:13 test
Any ideas?
(I'm also posting this to the SuSE list.)
--
Hugh
mailto: [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Hi List,
Ok, I'm a moron... problem solved:
Should have been:
grant CREATE TEMPORARY TABLES ...
and not
grant Create_tmp_table_priv ...
Well atleast this is now in the archives for search engines to pick up on...
I swear I sat there for 10 minutes thinking "Should I clutter the list wit
Hi List,
I hate to bother the list with what should be a simple question but I've been unable
to get this
to work or find anything on mysql.com or google.
I need to grant :
Create_tmp_table_priv
on a particular database.
As root (mysql user) I tried :
grant Create_tmp_table_priv on mydatabas
Hi List,
I've recently started seeing quite a few errors with MySQL servers I admin, they are
all
requests to run:
mysqladmin flush-hosts
The only change I can identify is our upgrade to 3.23.58 (mysql.com provided RPM -
running on
redhat 7.3)
Is anyone aware of an issue with this version or
Hi List,
I've searched the archives and the web many times in the past for answers to the
following
questions but never really got a complete understanding of what is going on. Hopefully
someone on
the list will be able to take the time to set me straight.
I have a typical php + mysql + linux s
Hello All,
I've read many different methods to expand the number of file descriptors that mysql
(and apache)
can use. However I've not been able to find the perfect method, many guides seem to be
out of
date, etc.
I am wondering, does anyone have any advice on their own preferred methods of set
Original Message
Subject: Bug Report
Date: Thu, 16 May 2002 21:28:21 -0400
From: hugh <[EMAIL PROTECTED]>
Organization: The Dualies
To: [EMAIL PROTECTED]
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-P
Responsible Person,
We have been asked by a client, to use your products in our intergration
efforts. Your MySQL 3.23.49a [Stable version?] for Sun Solaris x86,
version, 5.8, is offered without the installation file
./scripts/mysql_install_db. The ./scripts/mysql_install_db, that comes
with i
Try
SELECT lastip,username FROM users HAVING count(*) > 1 GROUP BY lastip;
(or possibly
SELECT lastip,username FROM users GROUP BY lastip HAVING count(*) > 1;
)
david
On Wednesday 24 October 2001 2:21 pm, David Wolf wrote:
> I'm trying to come up with a query to do the following... I'm no
gt; [EMAIL PROTECTED]
>
>
> -Original Message-
> From: David Hugh-Jones [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, 23 October, 2001 13:10
> To: [EMAIL PROTECTED]
> Subject: selecting rows where all rows meet a criterion
>
>
>
> OK, I have a tricky SQL syntax pro
ere students.id=grades.id
> and min(grades.grade - students.average_grade) > 0
> group by students.id
>
>
> Tom Haapanen
> [EMAIL PROTECTED]
>
>
> -Original Message-
> From: David Hugh-Jones [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, 23 October, 2001 13:1
OK, I have a tricky SQL syntax problem I would like to share.
For simplicity's sake, I'll use an analogy. I have two tables, of students
and grades, each with a "ID" column for use in joins, corresponding to a
student's ID.
The student table has an "average grade" column which shows that stud
, but just wanted to check.
sql sql sql. dumb email filter.
--
David Hugh-Jones
iDomainCart
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive
i need a mysql binary distribution with chinese big5 charset compiled...WINDOWS
version.
i have ever download an source code for windows version, but i cannot be compile as
big5 version, coz there seems not has a file named "configure" might exist in Unix
platform. i dont know how to compile i
35 matches
Mail list logo
