 | | | MySQL General | | Then you need to tell us what operation needs to be performed on t1.postcode
before making the comparison. That is describe what you want rather than
what didn 't work.
Michael
zzapper wroHello List
I 've recently compiled and installed the latest stable version of MySQL from
source file mysql-4.0.20.tar.gz on Red Hat Linux Advanced Server 3 (without
installing the version of MySQLYou might also want to read these articles
http //www.onlamp.com/lpt/a/4397
and
http //dev.mysql.com/tech-resources/articles/wizard/index.html
In addition there 's a Perl module - DBIx S "Chip Bell " <cbell@(protected) > wrote
> Hello I run a toaster email server which is having trouble
> authenticating at times. Both methods of authentication imap AND web
> for some reason just Marten Lehmann <lehmann@(protected) > wrote
> what are the defaults for the following options?
>
> net_read_timeout
30 seconds.
> net_write_timeout
60 seconds.
See http //dev.mysql.com/mysql@(protected) wrote
> We are currently running with one big ms sql-server.
> Is it possible to do federated servers on mysql?
> What I want to do is to purchase one more server and split the wHello
SQL Maestro Group is happy to introduce a new release of SQL Maestro -
a powerful Win32 GUI solution for MySQL server administration and
database development. A fully functional trial vehi
How to complie MySQL in MIPS platform?
I have tried but no success.
jy
"Matt Eaton " <mattsnews0303@(protected) > wrote
Try to profile application from that point ...
> if (mysql_real_query(&dbase sqlBuff strlen(sqlBuff))) {
> printf( "Pool AttAt 7 53 +0300 6/29/04 Dainis Polis wrote
>Hi All!
>
>Where to find subj.?
strings/ctype-utf8.c I believe.
--
Paul DuBois MySQL Documentation Team
Madison Wisconsin USA
MySQL AB wAt 10 24 PM 6/28/2004 you wrote
>I am looking for information on the proper way to code full text queries
>and more information on how they work.
http //dev.mysql.com/doc/mysql/en/Fulltext_SeaWhy don 't you use the export utility in ms access to load the data into
mysql. The export will create the table in the database. All you need is
a dsn connection and the mysql odbc.
Osvaldo SommeThis one I can help you with
SELECT year-field FROM table WHERE YEAR(year-field) < YEAR(CURDATE())
- John
on 6/28/04 4 49 PM Robb Kerr at rkerr@(protected) wrote
> Need help witI 've a funny feeling the kernel authors re-wrote much of the SMP code for
2.6 with the aim of getting it to scale better to 8 processor systems so I
would expect there to be a few stray bugs in it.The company I 'm hiring is looking for somebody very senior to help
architect a very modular MySQL Linux and Java based infrastructure.
The "official " posting is below but what we need is
- "Matthias Eireiner " <matthias.eireiner@(protected) > wrote
> problem is that I want to save the time with the fraction of seconds.
> as far as I know MySQL is fine with something like "D HH MM SS.frJim <mysql@(protected) > wrote
> I 'm just wondering if anyone can tell me exactly what happens when one
> is using the mysql client on a remote server and the connection to that
> server (in thI had this same problem. This isn 't fool proof or recomended but what
i ended up doing was calling mysqlbinlog over and over again
incrementing --position (or --offset i can 't remember) until it picHi there
I have Mysql 4.1.1 runing on Redhat Linux 9 both of them are English
Version.
Now I need a table which my user can input both Chinese and English so I
create a DB as following
I 've seen job announcements posted on other lists (and I think this one
as well). I think it 's relevant and shouldn 't offend anyone.
David
Michael Halligan wrote
>Greetings.
>
>My compa-----BEGIN PGP SIGNED MESSAGE-----
Hash SHA1
Oliver Chua wrote
> To be able to use subqueries I 'm now using mysql-4.1.2b-alpha-win.zip
> I 'm using mysql-connector-java-3.1.2-alpha.zip as myNoticed something interesting about UNION and INTO OUTFILE
If I do this
(SELECT a FROM b)
UNION
(SELECT a INTO OUTFILE 'out.txt ' FROM c)
The query executes - no results printed to the scrOn Mon 2004-06-28 at 09 32 Joseph Norris wrote
> Group
>
> First of all thanks to anyone who can respond to this - I am really stumped.
>
>
> I have been trying to figure this one out and ma
I 'm assuming you want the rows with the top 1000 usage values. Why not just
do it in 1 UPDATE statement?
UPDATE yourtable SET checked 1 ORDER BY usage DESC LIMIT 1000
This should workDo a show variables from the MySQL monitor.
show variables
-----Original Message-----
From Scott Fletcher
To mysql@(protected)
Sent 6/28/04 10 27 AM
Subject MySQL Storage Engines andHello
do I need the character sets on the client side or just on the server?
Client and server are different servers so I want to reduce the
client-package to a minimum
/usr/bin/mysql
/uCan you post the code or sql that you are attempting to execute that is
throwing tis error?
-----Original Message-----
From Oliver Chua
To mysql@(protected)
Sent 6/28/04 5 08 AM
SubjectHave you ran an explain plan on the query to identify the execution path?
-----Original Message-----
From Aasef Iqbal
To mysql@(protected)
Sent 6/28/04 6 15 AM
Subject slow query when sHi everyone
I need have a row counter in a query but I 'm not sure if there is any way to
do this. In essence all I need is get a result like this
Counter column-A column-B
1 Hi Carlos
> What is more important? triggers or stored procedures.
>
> I think that triggers they are a lot more important than stored proc.
because stored procs they can be implemented in the |
|
|
