Hi,
We are using the binary distribution of mysql for solaris 9 64bit on 2
machines that are replicating to each other for redundancy:
mysql-standard-4.0.14-sun-solaris2.9-sparc-64bit
I am successfully able use replicate-ignore-db=blah to stop replication
on a database, however when I specify
Hi,
We are considering using mySql or postgreSql for an app that handles large
volume of data. Somehow, it appears (mostly from the mailing lists) that mySql
does not handle large volumes of data very well (crashes, db corruptions, etc).
Would ppl who use mySql for large volumes of data share
Hi guys,
Just wanted to say that I think I remember a recent commit to the source
tree to correct a problem or problems with max_user_connections
counting. I think one of them was a race condition if 2 threads tried to
increase/decrease the counter at once. But it seems like that would
rarely
Hi
Using MySql 3.23
Can I have multiple values in one column and then index the column, I
have used different delimiters but the index only seems find the whole
contents of the column no matter what I separate the data with
Regards
John Berman
[EMAIL PROTECTED]
Hi,
I removed idbdata and iblogs and recreated idbdata and iblogs. But I keeps
getting Can't init databases. I still have a lot of disk space. Could any
one please tell me what's wrong?
Here are message from error log
InnoDB: Database physically writes the file full: wait...
InnoDB: Progress in
Hi Hsiu-Hui,
I havent followed the threat, excuse if this was mentioned before.
Did you try to start the server with the
--skip-innodb
option yet ?
--
kind regards
Nils Valentin
Tokyo/Japan
http://www.be-known-online.com/mysql/
On Thursday 13 November 2003 17:38, Hsiu-Hui Tseng wrote:
Dear friends
We have our application with data tier as mysql database in our office running on
windows platform which we need to synchronize with the same database on a remote
system at data centre on Linux.
Awaiting your reply at the earliest,
Thanks Regards,
Prashant A
Hi
I did something stupid: I locked myself out of the
MySQL server...
My problem: I use MySQLFront to change the allowed
hosts and did it for all users. They were 'localhost'
and I set them to 'localhost; EcolMod1' where the
EcolMod1 is the name of my computer where the MySQL
server is
Hi
I did something very stupid: I locked myself out of the
MySQL server (all accounts, incl administrator)...
My problem: I use MySQLFront to change the allowed
hosts and did it for all users. They were 'localhost'
and I set them to 'localhost; EcolMod1' where the
EcolMod1 is the name of my
I did something very stupid: I locked myself out of the
MySQL server (all accounts, incl administrator)...
My problem: I use MySQLFront to change the allowed
hosts and did it for all users. They were 'localhost'
and I set them to 'localhost; EcolMod1' where the
EcolMod1 is the name of
Hi,
I tried it in 4.0 and got the desired result - but at least the select
part should not depend on version, as long as it's recent.
The select should return all combinations of first and last names
available in the source table ordered by random to be more interesting.
You can try that by
Hi there
I have a question regarding replication.
This is the situation:
Mysql-Max4.0.16
192.168.0.10 master
192.168.0.11 slave
I would like to use the slave as the backup server
and use it in case the master goes down for any reason.
I'm looking for a safe method to re-update the master
On Nov 12, 2003, at 17:52, Gelu Gogancea wrote:
bk pull http://mysql.bkbits.net/mysql-5.0
Try bk clone http://mysql.bkbits.net/mysql-5.0
Cheers!
--zak
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Nov 12, 2003, at 20:37, Paul Fine wrote:
Unless I am misinformed, subscription to the DIGEST format of this list
should cause all messages to come in one daily e-mail? Can someone
else who
is subscribed this way please at least let me know that this is at
least the
case for them?
While I do
Hi
thanks a lot for your prompt reply. The second email
went out on accident - apologies.
I managed to fix it - I found localhost; EcolMod1
in user.myd.
Thanks again,
Rainer
On 13 Nov 2003 at 10:41, nm wrote:
Hi there
I have a question regarding replication.
This is the situation:
On Thursday 13 November 2003 10.41, nm wrote:
Hi there
I have a question regarding replication.
This is the situation:
Mysql-Max4.0.16
192.168.0.10 master
192.168.0.11 slave
I would like to use the slave as the backup server
and use it in case the master goes down for any reason.
I'm
Hi!
Thanks for the info. We ARE getting tons of connections/second, so that
might be the problem... We hoped that 4.0.16 would solve it, which it
didn't, so now we're hoping for 4.0.17...
-- Henrik
Matt W skrev:
Hi guys,
Just wanted to say that I think I remember a recent commit to the
Hi
I set a 2-way replication on 2 servers.
I made some test transactions and it is working.
I can make the clients go to any of my servers and the replication
is done in real time, or so. It looks great.
What are the potential problems I could have? Suggestions?
Do you have any experience?
Hello!
Does mySQL support a thing like Pascal/C++ unions for attribute types,
i.e. an attribute can be of two types at the same time.
Thanks in advance.
Florian
Hello
I'll compile mysql on Solaris 2.6 with gcc 2.95.2 and gnumake and
and GNUtar and such error has been present
Making all in isam
make[2]: Entering directory `/export/home/pekasz/src/mysql-3.23.58/isam'
/bin/ksh ../libtool --mode=link gcc -O3 -DDBUG_OFF -DHAVE_RWLOCK_T
-lbind -o isamlog
Thanks but if I am not mistaken, you are talking about SSH tunneling the
connection not what I am looking for. I am interested in how to
implement SSL. Thanks!
-Original Message-
From: Ferguson, Michael [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 12, 2003 2:47 PM
To: Paul
Can anyone please tell me what if anything happens with database locking
during the execution of a mysqldump? Ie. What happens to database
transactions occurring while performing a dump?
Thanks!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hi
I am pretty new to mysql.
I am porting an access driven website to mysql.
All has gone pretty much to plan bar one final page.
This page is basically a listing of duplicate users based on the email field.
In the access db I had a predefined query called emailduplicate
The site asp page
Digest mode for this list is 2 digests a day.
-Original Message-
From: Paul Fine [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 12, 2003 3:37 PM
To: [EMAIL PROTECTED]
Subject: Digest Again, PLEASE SOMEONE HELP?
Unless I am misinformed, subscription to the DIGEST format of this list
Your syntax is wrong, or at least not standard, if you are trying to do
multiple left joins.
Your ordering is not your typical for a query.
And you say there instead of where.
Your query should be structure like this:
SELECT fields
FROM table, table,...
LEFT JOIN table ON join condition
LEFT
Hi all:
Need some clarification on this because the books and
articles don't make it clear.
Let's say I have a program in php or whatever language
that contains the username and password for access to
mysql and the program executes once anyone visits the
site.
Can multiple visitors to my site
Hi there . How can i passwords so i can login into
myqsl. With current configuration anyone is allowded
to login.
__
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree
--
MySQL General Mailing List
For list
Hello,
I have got problem with ordering records selected by LEFT JOIN, there
is a SQL select:
SELECT so.label, so.price, o.name, o.id id, o.location, p.filename, p.format
FROM offers o, offers_soffer so
LEFT JOIN offers_photos p ON o.id = p.record_id
WHERE so.rec_id = o.id
GROUP BY (o.id)
ORDER
Thanks. Well I can't figure out what the problem is, I keep getting single
e-mails for each post :( even after unsubscribing and resubscribing with
digest selected.
-Original Message-
From: Rob A. Brahier [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 13, 2003 7:44 AM
To: Paul
On Thursday, Nov 13, 2003, at 02:55 US/Eastern, John Berman wrote:
Can I have multiple values in one column and then index the column, I
have used different delimiters but the index only seems find the whole
contents of the column no matter what I separate the data with
It seems like you'd be
On Nov 13, 2003, at 14:02, Alaios wrote:
Hi there . How can i passwords so i can login into
myqsl. With current configuration anyone is allowded
to login.
See the REVOKE command at http://mysql.com/GRANT
Cheers!
--zak
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Hi i have just installed the mysql_client
and i am trying to remotely connect to the database of
the other pc so i gave the following command
mysqlshow -h 192.168.64.12 -u [EMAIL PROTECTED]
mysqlshow: Host 'akroneiro' is not allowed to connect
to this M
What i msut do in order to gain access to
I am sure that this problem has already been answered but some how I can't
figure it out.
When I try to start the mysqld I get the error 2002 can't start server: Bind
or TCP/IP port: Address already in use or...
I check that the damoen is not runnig (ps -ef |grep mysqld ) and shows
nothing
I just started logging slow queries. Today I found the following lines in
the slow query log.
# Query_time: 14 Lock_time: 0 Rows_sent: 293 Rows_examined: 293
use storyboards;
SELECT /*!40001 SQL_NO_CACHE */ * FROM `rwt_screens`;
What exact does the third line mean?
thanks,
Luis R. Lebron
I am try to copy a couple of fields from one table to another. Here is my
query
Insert into users_test (firstName, lastName) Select firstName, lastName from
users;
The users table has 1,263 rows. However, only 1 row is inserted into
users_test.
If I perform the following query
Insert into
I am trying to change a column specification, a date column, so that the
default value is the current date. Is this possible? I just get an error
on the change query:
alter table Hits modify modify Date date NOT NULL default CURDATE();
ERROR 1064: You have an error in your SQL syntax. Check
i believe you'll need to use a timestamp column, which will set to the
current date/time at each insert/update. I don't think you can set the
date default to a function.
You are also using a reserved word Date for your column name without
escaping it, i.e. `Date`, also you have two modify's in
http://www.mysql.com/doc/en/CREATE_TABLE.html
A DEFAULT value has to be a constant, it cannot be a function or an
expression.
...
Default values must be constants. This means, for example, that you cannot
set the default for a date column to be the value of a function such as NOW()
or
Mike Morton [EMAIL PROTECTED] wrote:
I am trying to change a column specification, a date column, so that the
default value is the current date. Is this possible? I just get an error
on the change query:
alter table Hits modify modify Date date NOT NULL default CURDATE();
ERROR 1064:
Mikael:
Thanks - I must have missed that in the create table docs - I did look there
first - honest!
And you are correct - in that the timestamp is too much precision, and
unfortunately due to the thousands of distributed apps that access this DB,
I cannot modify all the queries - oh well,
From: Mikael Fridh [mailto:[EMAIL PROTECTED]
or read about the TIMESTAMP type, but I guess that's too much
precision since you only wanted the date, not the time.
http://www.mysql.com/doc/en/DATETIME.html
It's only too much precision when you're selecting the whole field. You can simply
Do you know how to test a crash and a rollback?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
Do you know how to test a crash and a rollback?
You mean a client app crashing on you?
How about disabling/unplugging the network?
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL MS SQL
Server.
Upscene Productions
http://www.upscene.com
At the command prompt, I'm supposed to type:
mysql -h host -u user -p
Does that mean that I type, for example:
mysql -h localhost -u admin -p
with localhost=host and admin=user?
When I'm asked for the password, I hit return and it lets me in.
But if I try to create a database, by using:
A full table scan was performed on the rwt_screens table. The /* ... */
means that if the dbms is 4.0.x then do not cache this query.
-Original Message-
From: Luis Lebron [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 13, 2003 8:52 AM
To: Mysql (E-mail)
Subject: Question on slow
From: Scott Yamahata [mailto:[EMAIL PROTECTED]
At the command prompt, I'm supposed to type:
mysql -h host -u user -p
Does that mean that I type, for example:
mysql -h localhost -u admin -p
with localhost=host and admin=user?
When I'm asked for the password, I hit return and it
restart mysql with the skip-grants option
-Original Message-
From: Rainer M. Krug [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 13, 2003 3:03 AM
To: [EMAIL PROTECTED]
Subject: Urgent problem
Hi
I did something very stupid: I locked myself out of the
MySQL server (all accounts,
William R. Mussatto wrote:
Joe Lewis said:
We're experiencing the same issues, but not neccesarily after an
upgrade. We're using MySQL 4.0.12 and FreeBSD 4.7 Release. We're
getting max'd connections only on specific users, and the show
processlist is returning only the show processlist
Hi there,
I am not sure I understood your question correctly. What exactly is it that
you want to test ?
a) the recovery possibility in case of power down
b) the recovery possibility in case of client disconnection (network
interruption, timeout etc.)
c) Recovery possibilities in general
On Wed, Nov 12, 2003 at 08:10:58PM -0600, Mike Blezien wrote:
Hello,
we've set up many displays using the Previous and Next simple linking
set up of search results. But now would like to implement the page number
style, IE. Previous [1] [2] [3] Next style format and was hoping
someone
You need to do a count before your select, use limmit to only select a set
number of records. That way you can work out how many pages there are and
just have a link. You run the same query for each page except that the start
record for the limit is the pagenumber * number of records per page.
On Wed, Nov 12, 2003 at 08:10:58PM -0600, Mike Blezien wrote:
Hello,
we've set up many displays using the Previous and Next simple linking
set up of search results. But now would like to implement the page number
style, IE. Previous [1] [2] [3] Next style format and was hoping
someone
Hm
Lost me a bit, if you can all bear with me I will give a little more
info
I have a single table with 120 fields (its full of genealogical data)
All the records apart from marriages have an entry in the surname field
Every record has a set identifier (uniqueref)
When I search I have a
Hi ,
I am using mySQL on windows 98 machine.
In my (java)program I want to run the following query
query = Select * from kids_books where item_id = 'itemId' ;
I get the itemId as a parameter from one of the functions.
When i run this query I am not getting any out put.
I have checked that
Hi,
I am using mySQL on windows 98 machine.
In my (java)program I want to run the following query
query = Select * from kids_books where item_id = 'itemId' ;
You are comparing values in column item_id with the string
'itemId'. I guess this is not what you want, is it?
With regards,
what type is item_id?
That query is looking for a value in the field item_is that is equal to the
a constant string itemId. is there a record with the value in it?
- Original Message -
From: florentina kore [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, November 13, 2003
Got it Harald, thanks. OK, I've got this working
now, so I'll do a quick overview of what I've
learned... for the archives:
I am setting up mysql with msyslog to be a
centralized logging server. My servers (Windows
Red Hat) will send their logs to this mysql
box. To keep the mysql db from
Description:
configure contains the lines
compile_readline= no
compile_libedit= no
which causes a message
./configure: line xxx: no: command not found
unless you happen to have a program named no in your path.
How-To-Repeat:
I have a mysql db where via a web page I access a database
I have set the permissions to
grant select, insert, update, delete on test.* to [EMAIL PROTECTED]
identified by 'nestor';
flush privileges;
The database has 3 tables. I can select via PHP code all the tables,
but when I try to insert
or
two last gotchas I thought of...
1- the routine will erase all the old records, but the day's logs will increment
between executions, so you may want to give it a day's worth of 'padding' if the 20GB
is a hard limit (disk size). No worries if it's flexible
2- until you have filled to your
I forgot to mentioned that this same code works on the same database on
my W2K
but I am having problems on my Mac OS X (Darwin). I sqldump the
database from my W2K
to my Mac Os X.
Nestor :-)
Nestor A. Florez
Nestor Florez 11/13/2003 10:17:37 AM
I have a mysql db where via a web page I
I have two tables EVENT and PROJECTCODE
EVENT.ID
EVENT.ID_PROJECTCODE
PROJECTCODE.ID
PROJECTCODE.Name
EVENT PROJECTCODE
ID = 1 ID_PROJECTCODE = 0 ID = 1
ID = 2 ID_PROJECTCODE = 0 ID = 2
ID = 3 ID_PROJECTCODE = 1 ID = 3
execute show grants for nestor@'%' and see what that user has.
-Original Message-
From: Nestor Florez [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 13, 2003 12:21 PM
To: Nestor Florez; [EMAIL PROTECTED]
Subject: Re: Grant permissions problems - help
I forgot to mentioned that this
Hi Nestor. What does the mysql_error() report as the exact error
message? This could help you identify what kind of access control
issue it is.
Alternatively, you could try running the same query from the command
line (using the mysql client) and see if you get the same error.
Also, I'm not
Got it, thanks
SELECT PROJECTCODE.ID AS 'ID', PROJECTCODE.Name AS 'Reference', EVENT.ID,
EVENT.ID_PROJECTCODE FROM PROJECTCODE LEFT JOIN EVENT ON PROJECTCODE.ID =
EVENT.ID_PROJECTCODE WHERE EVENT.ID IS NULL ORDER BY PROJECTCODE.Name
-Original Message-
From: Luc Foisy
Sent: Thursday,
+-+
| Grants for [EMAIL PROTECTED]
|
+-+
| GRANT USAGE ON *.* TO 'nestor'@'%'
I just realized that if I login to mysql as the user I can insert
records.
It must be somehting with my code
I will try the trace_on
It is just amazing that the same code works in my W2K machine
and when I ftp it to the Mac OS X only adding to th eschools fails.
Thanks,
Nestor :-)
Nestor A.
I created the .my.cnf file in root's home dir, added the directives below
setting the correct password. Restarted mysqld, re-logged in as root, but
nothing works. It's not getting the password.
The simplest solution is to keep the password in the .my.cnf file in
your home directory. See
OK guys this is beyond me.
I just found out that I can NOT insert into my SCHOOL table
when I login into mysql as user nestor on my Mac OS X.
The table is autoincremented. how do I find out what is the next
number to be incremented?
Nestor :-)
Nestor A. Florez
Nestor Florez [EMAIL
Hi all,
I have a MyISAM table with a decimal field (12,2)
I have loaded a bunch of data into this table, from ascii dumps of data being
migrated from other systems. Some of these dumps include a value for the
decimal field in the form of 00078000.00
My understanding was that decimal fields
Their are two nestor users. One with a password and one without a password.
The one with connect from anywhere is only allowed to modify the test
database. Fix your privileges and you should be okay.
-Original Message-
From: Nestor Florez [mailto:[EMAIL PROTECTED]
Sent: Thursday, November
Thanks to You Brent and Bill Easton
and Sorry
Hrmm , that what happen when not clipping direct into mail program ,
here is the Original :-) :
Select A.DepartmentName,A.Address,P.Postcode,P.cityname,CP.firstname
from caddress A,cpostinfo P
left Join CContactPerson CP , caddresscontactperson
Anyone? Hope that does not mean that mySql is not used with large dbs ... :)
Thanks
--- ow [EMAIL PROTECTED] wrote:
Hi,
We are considering using mySql or postgreSql for an app that handles large
volume of data. Somehow, it appears (mostly from the mailing lists) that
mySql
does not handle
The client (mysql) reads the .my.cnf file when you start it, so
restarting mysqld and relogging in as root are not necessary.
Let's see if I have this straight: While logged in as root, you created
.my.cnf in root's home directory. This file contains the password for
the mysql user root.
Victor,
I will fixed this, but I do not think this is th eproblem.
I have the same settings on both W2K and Mac OS X and it only fails on
the Mac
Also When I log in as nestor with a password on the Mac I can not
insert a record
from the ocmmand line. I can do this on my W2K database.
Thanks I
I actually took a look at the mysql.user table and user nestor has a
password in both entries to the table.
One entry is for localhost and the other is for '%';
I try inserting from the command line and I get:
mysql insert into School (school_desc) values ('Nestor');
Query OK, 1 row affected
You should search the archives. This topic has been covered quite a few
times before, mainly in reference to increasing performance. Of course,
peoples definition of large differs.
If you think large is 10 or 20 millions records, then you will find
stuff in the archives discussing databases
Hello all,
I have a problem storing an SHA1 hash generated as user password for an application...
This is the original SELECT Command:
INSERT INTO Auth$ VALUES ('System',
'%X;Z(B9?(?U?NE?$03?#j???-#N?[. 6?^?', 3)
but the stored values are:
%X;Z(B9?(?U?NE?$03?#j???-#N?[. 6?^?
this
On Thursday, Nov 13, 2003, at 12:03 US/Eastern, John Berman wrote:
I have a single table with 120 fields (its full of genealogical data)
All the records apart from marriages have an entry in the surname field
[snip]
Now marriages don't have an entry in surname but they do in
groomsurname
and
on 11/13/03 3:57 PM, Michael Stassen at [EMAIL PROTECTED] wrote:
The client (mysql) reads the .my.cnf file when you start it, so
restarting mysqld and relogging in as root are not necessary.
Let's see if I have this straight: While logged in as root, you created
.my.cnf in root's home
-Original Message-
From: Matt Babineau [mailto:[EMAIL PROTECTED]
I am running 4.0.15-standard on RH9. My mysql database just stopped
working, is there a way I can log information about why it stops like
this? the *.err was unhelpful.
Did you just install a glibc upgrade/bugfix?
Thanks for the reply, I'm getting the message
A shorter question
I have seen that you can create an index across multiple columns, is
there any way one can tell which column returned the results (this would
help me short term). Or indeed have more than one word that's indexed in
a single column.
Paride De Gasperis wrote:
I have a problem storing an SHA1 hash generated as user password for
an application...
I do the same thing (although not with a MySQL database) and I anticipated
problems in storing the binary hash, so I chose to perform a simple Base64
encoding of the hash result
Hello,
I've posted this before, but did not get a fix or find out what I am not doing
coreectly.
I've established several merge tables. 3 out of the 5 of my merge tables work
fine...but when I try to access (e.g. describe or query) the other two, I get the
following error:
mysql describe
Nestor Florez wrote:
I actually took a look at the mysql.user table and user nestor has a
password in both entries to the table.
One entry is for localhost and the other is for '%';
I try inserting from the command line and I get:
mysql insert into School (school_desc) values ('Nestor');
Query
In the last episode (Nov 13), Paride De Gasperis said:
Hello all,
I have a problem storing an SHA1 hash generated as user password for an
application...
This is the original SELECT Command:
INSERT INTO Auth$ VALUES ('System', '
% 3/4
X;Z^E(xB9?(?U?N~oSSE?$03^O?#^1j?'U'Y??-#N^A?`U[.
In the docs is says that you can define your own stopwords file for fulltext
searching. The following is under show variables...
ft_stopword_file The file from which to read the list of stopwords for
full-text searches. All the words from the file will be used; comments are
not honored. By
We make extensive use of full text searches, but have run into some problems
with backslashes. If a word like somebody's is entered into our database,
we escape the string using mysql_escapes_string in php. So,
mysql_escape_string(somebody's) becomes somebody\'s when it is saved in
the database.
Thanks for the help to ALL
I got it to work.
I do not know how but I think that they might have been hidden
characters in the program doing insert
in the actuall insert statements. I retyped the insert code in the
program and things started to
work. Probably when I ftp the code somethin
Hi,
I'm trying to load some data into a MySql table, but some of the srtings
that I try to load come with colons in them and then I get an error... is it
possible to insert colons and special characters into MySql? How?
Thanks!
--
MySQL General Mailing List
For list archives:
I have Mysql 4.0.14 with MyODBC3.51 and Access97.
I have a query
SELECT inquiry_data_simple.inquiry_id, inquiry_data_simple.organization,
inquiry_data_simple.event_date, inquiry_data_simple.event_id FROM
inquiry_data_simple ORDER BY inquiry_data_simple.organization;
The organization field does
Hi Jason,
There is no format per-se of the stopword file. The words are parsed
in the same way as when they're being indexed. e.g. A word is a
sequence of aplhanumeric characters, _ and '
So one line per word (which is how I do it) will work fine. As would
separating with spaces, commas, etc.
I posted this before, Subject: 64bit G5 Panther compiles but
received no reply.
Is there any answer yet for the ability to compile a working, 64bit
Mysql on OSX Panther?
Would you use GCC compiler flags-mpowerpc-gpopt and -mpowerpc64 ?
--
Adam Goldstein
White Wolf Networks
I have the following...
tSql = SELECT l.team, l.link, lc.category, l.age, l.date
FROM league AS l
INNER JOIN league_category AS lc
ON l.category = lc.id
WHERE lc.id = prepSQL(tConn, id) AND l.status = '1'
ORDER BY l.age, l.date;
L.age has data in it as
Hi Jason,
Of course somebody's isn't going to match somebody\'s. :-) somebody\'s
should match somebody\'s -- because it's really matching the somebody
part. If you're using 4+, you can use IN BOOLEAN MODE to match
somebody\'s exactly:
MATCH (col) AGAINST (' somebody\\\'s ' IN BOOLEAN MODE)
Hi Tony,
shell perror 143
Error code 143: Unknown error
143 = Conflicting table definition between MERGE and mapped table
Matt
- Original Message -
From: [EMAIL PROTECTED]
Sent: Thursday, November 13, 2003 4:00 PM
Subject: Merge Tables not working...
Hello,
I've posted this
Hi Scott,
This kind of ordering thing has come up before and there's never a great
answer I don't think.
You could try this ORDER BY
ORDER BY l.age + 0.0, l.age, l.date
But I think that might cause sorting problems if age has leading 0s.
Maybe not...
Matt
- Original Message -
Hi Gabriel,
No, the order of the WHERE clause shouldn't have anything to do with how
the query is executed. The only exception may be if MySQL thinks 2
different ways of doing something are of equal cost. In that case it may
choose one or the other depending on how the query is written.
Matt
Thanks for your answer, you can see my comments below.
-Original Message-
From: Matt W [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 13, 2003 3:36 PM
To: Jason Ramsey; [EMAIL PROTECTED]
Subject: Re: Backslash and full text searches
Hi Jason,
Of course somebody's isn't going to
Mysterious. I assume `mysql -p` prompts you for root's password and
works as expected, since without -p it says you're not using a password,
rather than saying there's something wrong with the password.
When you tried the defaults-file option, did you use the full path?
That is,
mysql
1 - 100 of 103 matches
Mail list logo
