Hi all,
Due to the severe security issue released last week for mysql, we had to
upgrade all our 3.22.32 servers to the latest 3.23 release.
However, this introduced us to some problems across several of our 80+ DB
servers:
1. Weird resolve issues:
tries to connect to
Hi,
Having a problem with accessing the mysql database from a remote
machine. I am typing in mysql -h ???.??.???.?? -u ?? -p. It asked
for password .. do that then the reply message is ERROR 2013: Lost
connection to MySQL server during query.
Have even tryed replacing IP with a host name and
Hi all,
I'm woundering if Mysql can use Database link, like Oracle can???
Eg. If i have some tables at my labtop, and want to make the same table(s) at my
server with this command:
create table test as select * from test@database_link (This is how you do it on
Oracle), but how do I do th
Yep Jermey are right what he says - Anyone know about using Database link in Mysql???
Regards
Frank
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "Egor Egorov" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, January 2
I stated to implement something like Oracle's ROWNUM ...
but noone's listening ... therefore I build an UDF ...
> -Ursprüngliche Nachricht-
> Von: Luc Foisy [mailto:[EMAIL PROTECTED]]
> Gesendet: Donnerstag, 13. Februar 2003 20:00
> An: MYSQL-List (E-mail)
>
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category:
>Description:
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables
/usr/lib/dld.sl: Unresolved symbol: _GLOBAL__FI_libstdc___sl_5_0 (code) from /u
sr/local/mysql/libexec/mys
>Description:
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables
/usr/lib/dld.sl: Unresolved symbol: _GLOBAL__FI_libstdc___sl_5_0 (code) from /u
sr/local/mysql/libexec/mys
I have mysql installed on Red Hat 7.3. I have created a table like the
example below:
create table test(f1 char(30), f2 char(30))
Here is my problem I am trying to update this table with this:
update test set f2 = 'c:\temp' where f1 = 'location'
There is already a record
Hi all,
It seems that MS Access can't find out how to "convert" the mysql Time Type
in a table.
Lets say i got 3 colums in a table like this:
create table test (id int(4)auto_increment,dato date,tid time, primary key
(id));
insert into test values ('',curdate(),cur
Hi,
Well I had the same "problem" when I installed Mysql the first time.
I solved this problem by using a symbolic link like this.
cd /tmp
ln -s /mysql/mysql.sock mysql.sock
Remeber to be Root when you do a symbolic link :-)
Now make a ls -lia in your /tmp folder, then you s
when I try to connect to mysql (on the same host as mysqld):
mysql -h mysql.vhost1.com
I get: Access denied for user [EMAIL PROTECTED]
mysqld runs at hostname.domain.com
mysql.vhost1.com and hostname.domain.com have the same ip
mysql first looks up the ip of mysql.vhost1.com
then resolves it
UB_ID, EBA_USERS.REP_LOCATION_ID =
IMPO' at line 1
I did note in the comments section at the bottom someone else with
same/similar problem, but have been unable to find a thread in the mail
archive. My apologies if this has been dealt with already, or a workaround
suggested...
MySQL 3.23.51-nt on a
:-)
>Submitter-Id:
>Originator: Guido A.J. Stevens
>Organization:
NFG Net Facilities Group BV (Coal Connectivity)
>MySQL support: licence (certificate serial #51)
>Synopsis: duplicate rows in SELECT DISTINCT
>Severity: non-critical
>Priority: me
I am running MySQL on both NT4 and Win2K servers across a 64k WAN with over
600 users at 60 geographical sites - It rocks !!!
Jeff
- Original Message -
From: "Bernhard Döbler" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 01, 2003 7:34 PM
Subject
I'd like to connect a local sql server to a remote server and get 1
database synchronized between them. For various reasons, I need to
try to run this from within the sql protocol (i.e. no ftp, etc.).
Replication is not the answer, and I can only work with one database
at a time, so a SELECT is
In Callbacks or External Procedures?, <[EMAIL PROTECTED]> wrote:
>
>Is there _any_ way to do something like Oracle's OCI callback functions?
>
>What I need to do:
>Whenever my MySQL database changes data (inserts, updates, whatever) I need
>to call some of my own c
In Re: Selecting records with the highest value no greater than x,
<[EMAIL PROTECTED]> wrote:
>
>Hi Brent,
>
>I cannot think of a single query doing your job. But it can be done
>with two.
>
>SELECT @maxrating := MAX(RATING) FROM NEWS WHERE RATING <= 4;
>SELECT * FROM NEWS WHERE RATING=@maxrating
In Re: Selecting records with the highest value no greater than x,
<[EMAIL PROTECTED]> wrote:
>
>IMO, there is one, if I did understand the question correctly:
>
>SELECT * FROM NEWS WHERE RATING <= 4 ORDER BY RATING DESC, RAND() LIMIT 1;
>
>This give back a random news entry of the highest score
I currently have a PHP script performing the following query
mysql_query("SELECT * FROM Stuff WHERE Release LIKE \"%$var2%\"",$var1)
It works great except that the search is coming out case sensitive.
According to the MySQL Docs all searches are done without case se
In Re: Database synchronization, <[EMAIL PROTECTED]> wrote:
>
>On Thu, Feb 14, 2002 at 09:35:58PM -0800, MySQL wrote:
>
>> I'd like to connect a local sql server to a remote server and get 1
>> database synchronized between them. For various reasons, I need to
&g
In Faxing from MySQL, <[EMAIL PROTECTED]> wrote:
>
>Hi there. Anybody know how I can fax using MySQL? I might have an
>application for this.
Pretty simple problem for the APIs, you would probably spend longer on
a web search for a software package then writing it. Of course, o
grant tables failed!
Examine the logs in /var/db/mysql for more information.
You can also try to start the mysqld daemon with:
/usr/local/libexec/mysqld --skip-grant &
You can use the command line tool
/usr/local/bin/mysql to connect to the mysql
database and look at the grant tables:
shell> /
I record some stock data into MySQL, I'm looking for the correct
syntax for a SELECT statement.
SELECT min(Tmin) FROM quotes WHERE low=min(low)
In short, I want the time of the occurance of the low for the day,
Tmin is time column. Once the low is achieved, all the remaining data
for th
Hello.
How to load binary data into a table using
Perl DBI module (the data is uploaded from a HTML
form)?
I failed to find any information on MySQL site.
Thanks in advance.
-
Before posting, please check:
http
Greetings,
This is my first post to this list, hope you can help me.
I'm trying to automate nighly exports from MySQL to a Filemaker Pro database.
I figured out that the following syntax will get me a tab delimited export file:
mysqldump -u root --tab=/directory MyDataBase
This is
Hi all,
I am in the process of designing a MySQL database that will run on Redhat
7.1, but I am fairly sketchy on MySQL and performance.
What I want to do is have a database that keeps track of large distribution
lists. Each list has a unique ID, an owner (which is a reference to an ID in
Folks,
The database I setup 2 weeks ago was operating fine, if a bit slow. Yesterday, I tried
running the OPTIMIZE TABLE command on it, as recommended on this list for improving
performance.
Yesterday there were 75,000 records in my database.
Today, there are 13,000 records.
Apart from the Op
[EMAIL PROTECTED] writes:
>Not sure what to tell you - check to see if you have logging enabled on your
Logging is not enabled.
>
>This is a longshot, but you might have had a corrupted index that
>inaccurately reported 75k records when you really were only at 13k, and
>optimizing the table did s
Hello,
I have a table with text data in English in one column, same data in
Russian (cp1251) in another, and so on. I'd be happy to retrive that
data sorted alphabetically according to the *respected alphabets*. I
couldn't figure out how to perform this despite I compiled MySQL with
a
om: Dieter Munnik [mailto:[EMAIL PROTECTED]]
GO> Sent: Wednesday, April 17, 2002 8:48 AM
GO> To: [EMAIL PROTECTED]
GO> Subject: sorting
GO> Hi,
GO> I'm looking for an easy way to select "room numbers" in a numerical/
GO> alphabetical sequence in Mysql
GO> Ex : Th
Hi all,
I was trying to repair a table with myisamchk and got the following message:
"error: 'x.MYD' doesn't have a correct index definition. You need to recreate it before
you can do a repair"
(If I try to access the table from mysql, it tells me that the file x.MYD
SET NULL
) TYPE=INNODB;
But, the constraint does not work propperly. If i add 1 and 2 in the parent table, and
1,1 and 1,6 in
the child table, it still works.
Does anyone know if there is a Bug in the mysql, or im just getting it all wrong
If you know howto make the constraints work please
accepted in the child table - Thats Strange!!!
Does anyone know if there is a Bug in the mysql, or im just getting it all wrong
If you know howto make the constraints work please write a little example - Thanks :-)
Regards
Frank Jørgensen
I currently am a MySQL dba and am having issues from a security/linux
administrator that doesn't want me to have access to the /etc/my.cnf.
What can't I do with local database .cnf files that I can only do with
my.cnf?
Any ideas? I have looked at the documentation and it doesn&#x
This date formatting is how mysql handles dates. If it cannot parse the
date then is will store an invalid date.
Please see http://www.mysql.com/doc/D/A/DATETIME.html as this will
answer some of your datetime questions.
Accept your rebuke. You should have read up on datetimes before
posting
Has anyone ever had an error when using phpmyadmin to access MySQL similiar
to the following error:
Warning: Wrong parameter count for extract() in
./libraries/grab_globals.lib.php3 on line 18
I could not find the answer in any other lists.
Any assistance in how to correct this might be
if you need table or datarow locking , why don't you use innodb table type
with transactions ?
bye, thomas
> First user locks a table write:
> mysql> lock tables mytablename write;
> Query OK, 0 rows affected (0.00 sec)
>
> Then,second user wishes to query something fr
s to the daemon stops - mysql queries simply
hang.
ktrace -p -t+ shows this repeating endlessly:
44113 mysqld PSIG SIGPROF caught handler=0x812d58c mask=0x0 code=0x0
44113 mysqld CALL gettimeofday(0x81c634c,0)
44113 mysqld RET gettimeofday 0
44113 mysqld CALL sigprocmask(0x3,0x81
have a look at the HAVING clause:
mysql> SELECT user,MAX(salary) AS sum FROM users
->group by user HAVING sum>10;
http://www.mysql.com/doc/S/E/SELECT.html
> Okay, I thought I'd done this before but maybe not. I can't figure it
> out now.
>
> W
his almost belongs on the bugs list, but I don't have a stable, sure way
to trigger it.
Symptoms:
mysqld locks itself in a tight loop, consuming all available CPU cycles.
a simple "kill" sometimes kills the daemon, other times a -9 is required.
While in this state, any access to
On Sat, 17 Aug 2002, Jeremy Zawodny wrote:
> On Fri, Aug 09, 2002 at 04:20:42PM -0400, David Miller wrote:
> > On Sun, 4 Aug 2002, Jeremy Zawodny wrote:
> >
> > Hi Jeremy;
> >
> > I didn't think my server would be doing any name resolution, particularly
> > while replace()ing millions of rows i
The patch below syncs AC_SYS_LARGEFILE with the version shipping with
autoconf 2.50. This is against MySQL 3.23.39.
--
albert chin ([EMAIL PROTECTED])
-- snip snip
--- acinclude.m4.orig Sun Jul 1 12:51:18 2001
+++ acinclude.m4Sun Jul 1 12:58:47 2001
@@ -1035,122 +1241,85 @@
dnl
, your reply will go through. However, you should
first review the text of the message to make sure it has something to do
with MySQL. You have written the following:
We are online advertising company, I just visited your web site and I
think you may be interested to have more visitors to deliver to
Hi,
I just want to know how to insert a BLOB data type in a field of a
table. I want to put the binary data stream not the file link in the
filed. The language i m using is PERL5.
Thanks in advance.
Regards,
Thakur Gyawali
Nepal
--
, your reply will go through. However, you should
first review the text of the message to make sure it has something to do
with MySQL. You have written the following:
Below is the result of your feedback form. It was submitted by
([EMAIL PROTECTED]) on Friday, July 27, 2001 at 05:51:09
Hi !
I get:
"@HOSTNAME@: command not found"
Does anyone know how to solve that ? I didn't find anything on the net or on the
mysql.com homepage.
Thanks.
Jan-Hendrik
-
Before posting, please check:
http://www.mysql.com/man
hi
i using linux 6.2,mysql and coldfusion 4.5
the odbc connection in cold fusion is failed for setup
can anyone help ? i don know how to start on checking.
wong
-
Before posting, please check:
http://www.mysql.com
Description:
After having installed binaries, or compiled source code, mysql_install_db
ends in a coredump
How-To-Repeat:
Fix:
Submitter-Id: [EMAIL PROTECTED]
Originator:
Organization:
MySQL support: [none ]
Synopsis: install ends in coredump
Severity
Dear Sirs :
I'm attempting to install mysql 3.23.33 from source
distribution (I need source , not binary)
on my Digital Unix 4.0F , (I have a previous mysql 3.22.32
installed).
I follow the steps :
CC=gcc CXX=gcc ./configure
I can view on at config.log , that's all is fine, but w
Dear Sirs:
Please can you tell me where I can get the Perl DBI interface
for Windows ???
Ernesto
-
Este mensaje fue enviado a través de Qnet
http://www.qnet.com.pe
-
Before postin
Remove unsubscribe
neither one of the 2 methods listed below for name remove seem to function
please remove me from this list ASAP...
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://
Can someone tell me how to insert an selct back a directory into mysql using sql? I'm
trying to insert and reselect
c:\My Documents into a varchar field and I keep having a problem with the special
character \
Jeff
2:08 PM
Subject: Re: Special Character \
> use \\ combination
>
>
> - Original Message -
> From: <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, March 15, 2001 11:55 PM
> Subject: Special Character \
>
>
> Can someone tell me how to
Please I would want how I can get the list of records from a
table1 that do not appears on a table2, supossing a column
e.g code is used as connector or joiner present at both
tables;
Thanks
Ernesto
-
Este mensaje fue enviado a través de Qnet
http
least a few
more months. I have a PHP and a MYSQL list db, here are the URLs:
http://www.summittech.com/mysqlmail.php3
http://www.summittech.com/phpgenmail.php3
They are free and I am not doing anything with the data.
Let me know,
David Fordham
Hi Donna,
Try this. That was the way i've installed Mysql on my server.
rpm -ivh MySQL-3.23.44-1.i386.rpm
rpm -ivh MySQL-client-3.23.44-1.i386.rpm
Please notice, that you have to use the RPM command 2 times.
Regards
Frank
Denmark.
<--->
http://www.tuffy.dk
<--->
Hello,
I know this is offtopic, but the new PostgreSQL book from OReilly is in
production. You can read it online at http://www.postgresql.info/ .
No we are not trying to start a flame war, but there is some really good
info on SQL queries in the book. It may be useful to some MySQL folk.
J
Hi
We have 2 Redhat 6.1 servers and MySQL 3.22.32 and both boxes
appear to have been hacked on Friday last and MYSQL client just hangs
when connecting to the localhost MYSQL server.
MySQL is running on both boxes and suffer the same problems.
We also have to use kill -9 pid number to kill the
I have 2 tables in my mysql database.
table1 is a master list with just one field -- email.
table2 is smaller, and contains three fields -- date, email, client
I need to run a querry to return the following: date, email, client from
table2 where the email address in table2 isn't alrea
s to keep users identified at login, "timers" as to
when memberships expire, make easy updates as needed.
I am working with a Unix server that runs both PHP and Perl in conjunction
with a MySQL database.
Please let me know if you have any scripts, tutorials or off-the-shelf
software you
gt; My root user password get lost. I just can't get in
zc> the database again.
zc> Anyone know the way to get access to mysql without
zc> password. Or is there a way to change the password?
zc> I get access denied with the Error No. 1044, and 1045.
You will find more about it a
dear all,
hi, i have a question that bother me in last few days and would you help me
to solve it, please. i have a master-detail table: hinvoice and dinvoice.
the table structure of those two table shown as below :
create table hinvoice (
nof varchar(7) not null,
noso varchar(7),
tg
me configure as previously (other than the innodb):
CFLAGS="-O3" CXX=gcc CXXFLAGS="-O3 -felide-constructors
-fno-exceptions -fno-rtti" ./configure --with-mysqld-user=mysql
--prefix=/usr/local/mysql --without-bench
--with-unix-socket-path=/usr/local/mysql/tmp/mysql.sock
--with-cli
ASC Limit 50;
Time:0.00 secs.
Handler_read_next: 49
Fix:
-
Synopsis:optimizer bug in selecting fields that don´t belong to the index used by
mysql/innodb
Exectutable: mysqld-max-nt
---
Sin
script write all the records from Machine "A" to a file (I saw an e-mail
on this list once about dumping all the tables and their info to one .sql
file, and using that for a backup copy) and then transfer that file to
Machine "B", then on machine "B" have the fi
7 -0500 9/18/02, William Martell wrote:
>Hello.
>
>Can anyone tell me whether we can represent fractions in MySQL 4.0. I have
>data representing different lengths of objects measured in inches. Can I
>load this data as is into a field in MySQL or do I have to convert it
00
Importance: Normal
News-Group: list.mysql
Reply-To: <[EMAIL PROTECTED]>
Hi all.
Anybody uses MySQL InnoDB with RAID-0?
Yes, works nicer than RAID5 I had before (but mine is RAID1+0).
Wich would be the best chunk-size for a raid-0 where put the datafiles?
Probably a
ng
select ID from table ORDER BY rand() LIMIT 1
however, this seems like a very slow method, like mysql first organizes a
few thousand records in a random 1 and only returns 1
Any help would be great!
If you have a unique and continous index, then perhaps something like
m
a float add is faster than 3 integer multiplies and
sum.
]-Original Message-
]From: MySQL [mailto:[EMAIL PROTECTED]]
]Sent: Thursday, September 19, 2002 7:51 PM
]To: [EMAIL PROTECTED]
]Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
]Subject: Re: Fractions
]
]
] Mailing-Li
Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm
(http://www.ezmlm.org)
From: "Richard Fox" <[EMAIL PROTECTED]>
Date: Fri, 20 Sep 2002 11:19:37 -0400
X-Priority: 3
X-MSMail-Priority: Normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.
News-Group: list.mysql
Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm
(http://www.ezmlm.org)
From: "gbu" <[EMAIL PROTECTED]>
I'm experiencing very strange innodb behavior.
What version of mysqld?
-
Before posting, please check:
ht
Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm
(http://www.ezmlm.org)
Cc: [EMAIL PROTECTED]
From: [EMAIL PROTECTED]
Date: Tue, 24 Sep 2002 11:04:35 +0100
I thought the InnoDB doesn't support a few MyISAM features. FULLTEXT for
one.Those features it does support will not
Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm
(http://www.ezmlm.org)
Date: Tue, 24 Sep 2002 12:07:14 +0200 (CEST)
From: Gabriele Carioli <[EMAIL PROTECTED]>
-- mysql, query
I wonder if you're using any RBL to avoid spam.
They're quite effective, si
From: Dana Diederich <[EMAIL PROTECTED]>
Date: Mon, 23 Sep 2002 09:40:45 -0500
Perhaps the InnoDB/MyISAM gurus can comment on this. I want to switch from
MyISAM to Innodb, because we have database tables that have many updates,
inserts, deletes and selects going on at the same tim
s is a permission denied error, but the MySQL deamon is running as
mysql, so it shouldn't
be trying to write to /root/tmp anyway. It should be writing to /tmp
Adjust the safe_mysqld file, you will find a temp setting within.
---
Hi all,
I'm a DBA in the Oracle World.
I want to make a sql query in mysql, with a concat (||) known i Oracle
world.
Like this.
select numer ||','|| text from Table:
Where the output will be eg.
1,HI
2,Frank
And so on
Hope one of you can see my problem. I've tri
Hi all,
I'm a DBA in the Oracle World.
I want to make a sql query in mysql, with a concat (||) known i Oracle
world.
Like this.
select numer ||','|| text from Table:
Where the output will be eg.
1,HI
2,Frank
And so on
Hope one of you can see my problem. I've tri
Sender: [EMAIL PROTECTED]
Date: Tue, 24 Sep 2002 08:21:20 +0200
From: Lars Heidieker <[EMAIL PROTECTED]>
on solaris it probably a good idea to change the tmp directory from /var/tmp ->
/tmp
I recalled this feature and decided to look into linux for it's
paral
From: [EMAIL PROTECTED]
Date: Tue, 24 Sep 2002 13:41:23 +0800 (WST)
I've got a problem with HEAP tables (undoubtedly the way
that I'm using them).
I'm running MySQL v.3.23.51 under Debian Linux with a
2.4.17 kernel.
If anyone can help clear some
Hi everybody there!
This isn't the first time I build mysql on Sparc-Solaris but is the
first time on Solaris 9, following the manual suggestions I build
gcc-3.2 on the same box as well as gnu-binutils-2.13, but I'm not
being successful on mysql-3.23.52.
Does any body have an idea
Please Help
Can't compile on Sparc Solaris 9
Following the manual suggestions I build
gcc-3.2 on the same box as well as gnu-binutils-2.13, but I'm not
being successful on mysql-3.23.52.
Could be the gcc? it was configure --with-as=/usr/ccs/bin/as --with-
ld=/usr/ccs/bin/ld and not
../strings/libmystrings.
>> a -lpthread -lthread -lz -lcrypt -lgen -lsocket -lnsl -lm -
>> lpthread -lthread
>> make[4]: Leaving directory `/web/compile/mysql-3.23.52/sql'
>> ./gen_lex_hash > lex_hash.h
>> ld.so.1: ./gen_lex_hash: fatal: libstdc++.so.5: open failed
Hi there!
After include /usr/local/bin on the library path as was suggested
by ED appears to work because isn't complaining about any more but
It broke again on something different.
Please any Idea?
Thanks
Jose Albert
Here the output
\...
I'm still trying to build mysql-3.23
Hi everyone!
I'm trying to build /mysql-3.23.53 on a sparc Solaris 9 box but
without any luck
Please guys can anyone give me an idea about?
Any help will be highly appreciated
-Jose
Specs: solaris 9, gcc-3.2, mysql-3.23.53
configured as:
CC=gcc CFLAGS="-O3" \
CXX=gcc CXXFLA
Hi,
Well I've tried to export 12 million rows with success from mysql to Oracle.
I used MS Access and created an ODBC connection to get the data from Mysql,
then i exported all rows to a .csv file. Then i used Oracle Sql-loader,
because I wanted em in an Oracle DB.
But you can import
Thanks very much for your replay
Is very interesting but how to change that declaration on mysql or
on the headers if there is any to modify. I have others Linux boxes
running mysql fine but each time I have to deal with the others
sparcs Solaris is really a real nightmare .
Regards
Jose
Well try mysql -u root -p
it will prompt asking for the password I really don't remember if
the derault password is mysql but you could try empty too.
-jose
>Hi!
>
>I installed the full version of Mandrake 8.2.
>The problem is that i can't setup the mysql server.
&
>I've gotten mysql server running but am getting lots of errors
when I
>try to run any of the scripts that come with it.
>for example when issuing the following command.
>
>[HDSK-Laptop:/library/mysql/sql-bench] haridass# ./run-all-tests
>
>The result I get is:
>
on Solaris/Intel
They where dealing with Intel platform but it took me out of the
water it builds fine on SPARC Solaris 9 too.
Ending Tests
Shutting-down MySQL daemon
Master shutdown finished
Slave shutdown finished
All 137 tests were successful.
Thanks again
--jose
>Thanks very much for your repl
27;
LEFT JOIN childTABLE2 AS c2
ON m.c2id = c2.id
AND c2.active = 'Yes'
WHERE m.pid=1
AND (c1.id IS NOT NULL OR c2.id IS NOT NULL)
the Result will be "5" which is probably wrong.
The expected Result ist "4".
The correct Result will be returned if you remove
both UNIQUE KE
Hmmmnn ... I don't think so ... COUNT() is also an
aggregate function and a SELECT COUNT(*) FROM table
should work on every database without grouping.
I think it's an error in MySQL. Why else this different
behaviour with and without unique index?
> -Ursprüngliche Nachric
Hi all.
3 tables. "Ticket" "Pipeline_Dept", and "Ticket_Matrix". Ticket_Matrix
matches tickets to pipeline depts. A ticket can be posted to multiple pipeline
depts. I want to select all tickets and the pipeline departments they are
posted to but only one row per ticket. So:
SELECT
My last post wasn't titled accurately. Sorry for the repost.
I have 3 tables. "Ticket" "Pipeline_Dept", and "Ticket_Matrix". Ticket_Matrix
matches tickets to pipeline depts. A ticket can be posted to multiple pipeline
depts. I want to select all tickets and the pipeline departments they are
pos
Greeting to all. Here is some data on my server :
[student:99] /usr/local/bin> mysqladmin -u root -p version
9:18
Enter password: ***
mysqladmin Ver 8.23 Distrib 3.23.52, for hp-hpux11.00 on hppa2.0w
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This sof
Greetings to everyone. I have trouble getting mysql shell to use
mysql.sock file which is not located in /tmp. I fixed all entries in
/etc/my.cnf but mysql shell still complains about /tmp/mysql.sock missing.
The only workaround I have found is --socket. Is there a way to make the
shell use the
Hi,
I'm trying to delete from a table where col <=> null, but it doesn't
seem to work. I don't see anything in the manual that says that <=>
can't be used in the where clause of a delete statment, but:
mysql> select * from t;
++--+
| id | num |
+---
not require one to be a list member to read or respond to
the author. You must be a list member to post to the list, though.
Thanks again to those that wrote me and enjoy.
David Fordham
-- Original Message --
From: "mysql" <[EMAIL PROTECT
Hello,
I am trying to find some information on MySQL. Could you folks help me
out. I need:
Max Database Size
Max Table Size
Max Size for a row
Max Number of rows
Max Number of Columns
Max number of indexes per table
Thanks!
Joshua Drake
Hi folks! I have a question for you all...
I've got two separate mysql servers running on one
machine. Both are 3.22.23b but used for separate
instances of separate webservers.
I'm having trouble with the "1030: Got error 127 from
table handler" error on only one of th
201 - 300 of 711 matches
Mail list logo
