I got this and I think You must have it.
You seem to have found a bug in the SQL parser.
Please submit a bug report with the data chunk below:
--BEGIN CUT--
JElkOiBzcWxwYXJzZXIubGliLnBocCx2IDEuMTUgMjAwMi8wNy8yNiAxODozMDo1OSBsZW05IEV4
H,
Suppose I have a field named title that contains
one
of these
I am a Man
I am a Woman
We are Men
We are Women
Why not split this into two fields:
pronoun enum('I','WE')
gender enum('MAN','WOMAN')
OR a SET
title SET(I,WE,MAN,MEN,WOMAN,WOMEN)
...and then get your
I tried to upgrade from 4.01 to 4.03 -apparently I did something wrong and
now got a bad server. Anyone can givew advice on how to cleanly unistall
now(e.g. rm /usr/bin/mysql*)?
linux:/home/db/TMPOUT # rpm -e MySQL-4.0.3-0.i386.rpm
error: package MySQL-4.0.3-0.i386.rpm is not installed
Hi!
- Original Message -
From: TH Leung [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Saturday, September 07, 2002 6:44 AM
Subject: FW: Fail to run version 4.0.3
Hi,
I am using 4.0.2 with Innodb in Windows 98 platform, and I have
downloaded
4.0.3 and install it
You could do something like:
linux:/home/db/TMPOUT # rpm -e MySQL-4.0.3-0.i386.rpm
error: package MySQL-4.0.3-0.i386.rpm is not installed
Don't add the RPM on the end.
Also, what does:
* rpm -qa | grep MySQL
...show. It will be in there. Use that name.
mysql,query
DSL
--
Con te
I'd try using MySQL's regular expression functions:
Select where title regexp '[[::]]m[ae]n[[::]]'
or if you are generating this query programmatically, it might be
simpler to do something like
Select
where
title regexp
I would like to make use of multiple physical drives.
Is there a way to have one mysqld but have databases on separate partitions?
OS is linux.
Thanks
Hudson
-
Before posting, please check:
http://www.mysql.com/manual.php
My guess on your problem is that you're running a database in WinME. It is
the worst, buggiest product out from a company that is famous for their
buggy OSs. Microsoft doesn't even support it worth a damn anymore, I'd
suggest going and getting a real OS. Nothing against you, many people don't
Hello everyone,
First of all, I am new to this list, so please let me introduce myself
quickly : I am Jean-Marc and I work in research in a university in Belgium.
I would like to make a very simple and basic C program that would just list
the data I have in a field of a table. Even though I
I would like to make use of multiple physical drives.
Is there a way to have one mysqld but have databases on separate partitions?
OS is linux.
Thanks
Hudson
-
Before posting, please check:
http://www.mysql.com/manual.php
At 16:58 -0400 9/7/02, hudson kingery wrote:
I would like to make use of multiple physical drives.
Is there a way to have one mysqld but have databases on separate partitions?
Shut down the server.
Copy the database directory to the other drive
Make a symlink to the moved directory in the
Hello group!
I'm using MySQL 3.23.47 and I got this question.
I have got two tables which share a same field - somewhat one is a foreign key of
another.
Values of the field in one table are a subset of values of the same field of the other.
Ex
TABLE A
ID Name Information
1
.
.
.
On Friday 06 September 2002 05:39 pm, Ilyas Keser wrote:
What I also not understand is that one can also compile Mysql with
MIT-Pthreads. What is a MIT-Pthread? Where can I read more about this?
Thanks
ilyas
'PThreads' is short for POSIX Threads, which is the Posix API specification
for
Hi,
suppose there is a database with lots of tables.
I want to add a function to this database to return the following SQL query:
SELECT SUM(IF(HOUR(start)'02:00:00' AND
HOUR(stop)='08:00:00',50*sessiontime,0)+IF(HOUR(start)'08:00:00' AND
Hello,
I am sorry if this is a painfully easy question, but I have been
looking everywhere, and I cannot find out how to do what I need. My
query is simply have: select * from table build_stats where stat_date
like blah blah
My only problem is that I dont want the field stat_date to
On Fri, Sep 06, 2002 at 04:25:42PM -0400, Mark Hennessy wrote:
Is there any way to just force the MySQL server to reload from the
table data on disk? The recipient servers are read-only, and the
sending server has a relatively infrequent rate of change, but just
enough that it's important
Are you even reading the manual before posting questions?
http://www.mysql.com/doc/en/Date_and_time_functions.html
SELECT NOW() + INTERVAL 14 DAY AS exp_date;
Gurhan
On Fri, 2002-09-06 at 21:40, Clemson Chan wrote:
hi guys,
I have a column expire_date DATETIME.
How do I add 2 weeks to
Ilyas try this site, Marc has great instructions on setting everything up
and all the downloads you need...
http://www.entropy.ch/software/macosx/mysql/
--
* Stephen Rosenberg
* http://www.lifug.org
* [EMAIL PROTECTED]
* [EMAIL PROTECTED]
On 9/6/02 5:36 PM, Ilyas Keser [EMAIL PROTECTED]
On Fri, Sep 06, 2002 at 04:29:24PM -0400, Mark Hennessy wrote:
I don't want to use replication as IIRC it would require that the
sending MySQL server be listening externally.
Why not setup an SSH tunnel, since you're planning to use SSH anyway.
Then you can use MySQL's native replication.
Hello,
After a year of doing database programming, try to actually normalize. Read
a couple online tutorials (phpbuilder, devshed) and the book mysql 2nd
edition and it just can't seem to stick. Understanding the concept/theory
but freeze up every time I try to implement. Trying to go from
Hi,
From my experience with MySQL, i think you can create a function(UDF - you
can look in documentation at 9.2.2 Adding a New User-definable
Function.Also you can find samples in MySQL source distribution) to avoid
this conditional filtering and not to create/generate this SQL query.
In this
You wrote:
I apologize for asking such a basic SQL question, but I am failing in
finding
the solution...
Consider the following table:
id | option
---
1 | a
2 | a
2 | b
I want to find the ids with only a specific set of options.
For example, if I wanted to get the ids
On Friday 06 September 2002 05:50 pm, Marcelo Simon wrote:
Well, I'm not 100% certain since I don't know what environment you're working
in, but a typical example from perl might be something like
my $query = INSERT INTO foo
Neil,
- Original Message -
From: Neil Malkani [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Saturday, September 07, 2002 7:46 PM
Subject: Innodb error on windows ME platform
Hi,
I have just installed and setup MySQL unfortunately I do not seem to be
able
to resolve
Based on the prefix for your MySQL installation (--prefix=/usr/local/mysql
'), you're not using the right paths. You need to set the -Idirectory to
be where your mysql.h file is, and the -Ldirectory to be where your
libmysqlclient.so (or .a if compiling static) file is. I'd recommend trying
the
Hi,
I have just installed and setup MySQL unfortunately I do not seem to be able
to resolve this issue concerning the Innodb functionality in MySQL. Any help
would be much appreciated.
Thanks,
Neil Malkani
020907 17:24:29 InnoDB: Assertion failure in thread 4294335835 in file
Specify the fields you want in your query.
example:
SELECT stat_id, stat_name, stat_data FROM build_stats
WHERE stat_date LIKE ...
I would also recommend you pick up this book. It will
save you hours and intro you to some simple but
powerful SQL functions.
Sams Teach Yourself SQL in 10 Minutes
Hello
Im having a problem compiling the version of the subject, the problem is
with the gethotsbyname function and the message is the next:
libmysql.c: In function `mysql_real_connect':
libmysql.c:1325: warning: passing arg 5 of `gethostbyname_r' from
incompatible pointer type
Hi,
I got a small problem I can't seem to do a sql statement that will pick on
the first letter of word in a feild. I have over 700 record in a database,
but I like to be able only to see those that let say start with D. How can
I do a statement that will let me do that.
Chuck Payne
Magi Design
Hi,
Try :
SELECT * FROM yourtable WHERE word LIKE 'D%';
Regards,
Jocelyn
- Original Message -
From: Chuck PUP Payne [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, September 08, 2002 2:42 AM
Subject: Have A problem
Hi,
I got a small problem I can't seem to do a sql
Hmmm...
Specify the fields you want in your query.
example:
SELECT stat_id, stat_name, stat_data FROM build_stats
WHERE stat_date LIKE ...
I think you miss the point of the question. What if you have table with
50 fields and you just don't want field 45, 46 and 48? It would be much
Hi,
I would like to know if there is a way that I can pass on an information
from a pull down menu into a sql query. Right now I have to right a PHP page
for each piece I am wanting to pass on. Example I have a movie database and
now if I want to see what is in my Anime Category that starts with
You may want to check out CPAN for:
Apache::DBIx
...
(kill the mysql query spam thingo)
DSL
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
On Fri, Sep 06, 2002 at 03:52:24PM +, Sam Przyswa wrote:
Hi,
Does the next MySQL 4.x version will support cross replications
between several master servers in cluster ?
Multi-master replication works as well in 4.x as it does in 3.23.xx.
Jeremy
--
Jeremy D. Zawodny | Perl, Web,
Jeremy Zawodny ([EMAIL PROTECTED]) écrivait:
On Fri, Sep 06, 2002 at 03:52:24PM +, Sam Przyswa wrote:
Hi,
Does the next MySQL 4.x version will support cross replications
between several master servers in cluster ?
Multi-master replication works as well in 4.x as it does in 3.23.xx.
On Sun, Sep 08, 2002 at 03:30:35AM +, Sam Przyswa wrote:
Jeremy Zawodny ([EMAIL PROTECTED]) écrivait:
On Fri, Sep 06, 2002 at 03:52:24PM +, Sam Przyswa wrote:
Hi,
Does the next MySQL 4.x version will support cross replications
between several master servers in cluster ?
36 matches
Mail list logo