Found it (after some days of searching):
https://code.launchpad.net/ubuntu/+source/mysql-workbench must be the
official repository according to
https://dev.mysql.com/doc/refman/5.7/en/installing-development-tree.html.
-Kalle
Am 15.10.2015 um 22:11 schrieb Karl-Philipp Richter:
> Hi,
> The only li
Hello Steve,
To what list should I post with a post-installation config and startup
> question?
>
>
This list, the MySQL General Mailing List, is the right place if the
question is about MySQL!
Cheers
--
Claudio
On 04/26/11 05:32, Halász Sándor wrote:
2011/04/25 18:45 +, Larry McGhaw
CREATE VIEW `myview2` AS
SELECT a.*, IF(b.`Name` IS NULL, '', b.`Name`) AS `TypeName`
FROM `mytable` a
LEFT JOIN `types` b ON a.`Type` = b.`ID`;
Well, for this construct
IF(b.`N
2011/04/25 18:45 +, Larry McGhaw
CREATE VIEW `myview2` AS
SELECT a.*, IF(b.`Name` IS NULL, '', b.`Name`) AS `TypeName`
FROM `mytable` a
LEFT JOIN `types` b ON a.`Type` = b.`ID`;
Well, for this construct
IF(b.`Name` IS NULL, '', b.`Name`)
there is a spe
Hi,
On 04/25/11 20:45, Larry McGhaw wrote:
My best advice is to not use a custom MySQL function in a view when the
parameter to that function
is a column or expression that has the potential to result in NULL because of
being on the right side
of a left outer join (or the left side of a right
11 2:03 PM
To: Larry McGhaw
Cc: Daevid Vincent; mysql@lists.mysql.com
Subject: Re: WHERE does not work on calculated view field - Found word(s) list
error in the Text body
On 04/22/11 22:41, Larry McGhaw wrote:
> It does appear to be some type of bug to me.
Hm... do you have an idea how to wo
essage-
From: Daniel Kraft [mailto:d...@domob.eu]
Sent: Friday, April 22, 2011 1:05 PM
To: Daevid Vincent
Cc: mysql@lists.mysql.com
Subject: Re: WHERE does not work on calculated view field - Found word(s) list
error in the Text body
Hi,
thanks for the fast reply!
On 04/22/11 21:39, Daevid V
Hi,
thanks for the answer!
On 04/23/11 11:33, ars k wrote:
Could you check the 'myview' once again? I think you thought to create the
view as follows:
" CREATE VIEW `myview2` AS SELECT a.*, EMPTY_STRING(b.`Name`) AS
`TypeName`FROM `mytable` a LEFT JOIN `types` b ON *a.ID* *= b.`ID`*;
Hi Daniel,
Could you check the 'myview' once again? I think you thought to create the
view as follows:
" CREATE VIEW `myview2` AS SELECT a.*, EMPTY_STRING(b.`Name`) AS
`TypeName`FROM `mytable` a LEFT JOIN `types` b ON *a.ID* *= b.`ID`*;
"
Now your select queries will give results as fol
On 22.04.2011 22:41, Larry McGhaw wrote:
It does appear to be some type of bug to me.
I agree. I was thrown by Daniels "first and third" comment, which I
guess should read "second and third"
I reproduced the behavior in 5.1.53-community on Windows.
/ Carsten
--
MySQL General Mailing List
F
mysql@lists.mysql.com
Subject: Re: WHERE does not work on calculated view field - Found word(s) list
error in the Text body
Hi,
thanks for the fast reply!
On 04/22/11 21:39, Daevid Vincent wrote:
>> DROP DATABASE `test`;
>> CREATE DATABASE `test`;
>> USE `test`;
>>
>> CREATE
Hi Carsten,
On 04/22/11 22:11, Carsten Pedersen wrote:
On 22.04.2011 21:37, Daniel Kraft wrote:
DROP DATABASE `test`;
CREATE DATABASE `test`;
USE `test`;
CREATE TABLE `mytable`
(`ID` SERIAL,
`Type` INTEGER UNSIGNED NULL,
PRIMARY KEY (`ID`));
INSERT INTO `mytable` (`Type`) VALUES (NULL);
CREAT
On 22.04.2011 21:37, Daniel Kraft wrote:
Hi all,
I'm by no means a (My)SQL expert and just getting started working with
VIEWs and stored procedures, and now I'm puzzled by this behaviour:
DROP DATABASE `test`;
CREATE DATABASE `test`;
USE `test`;
CREATE TABLE `mytable`
(`ID` SERIAL,
`Type` INTE
Hi,
thanks for the fast reply!
On 04/22/11 21:39, Daevid Vincent wrote:
DROP DATABASE `test`;
CREATE DATABASE `test`;
USE `test`;
CREATE TABLE `mytable`
(`ID` SERIAL,
`Type` INTEGER UNSIGNED NULL,
PRIMARY KEY (`ID`));
INSERT INTO `mytable` (`Type`) VALUES (NULL);
CREATE TABLE `t
> -Original Message-
> From: Daniel Kraft [mailto:d...@domob.eu]
> Sent: Friday, April 22, 2011 12:37 PM
> To: mysql@lists.mysql.com
> Subject: WHERE does not work on calculated view field
>
> Hi all,
>
> I'm by no means a (My)SQL expert and just getting started working with
> VIEWs and
Putting the 'HAVING' in there, works perfectly :)
THANKS!
Steven Staples
> -Original Message-
> From: SHAWN L.GREEN [mailto:shawn.l.gr...@oracle.com]
> Sent: June 10, 2010 8:03 PM
> To: Steven Staples
> Cc: 'MySql'
> Subject: Re: WHERE clause fr
On 6/10/2010 4:38 PM, Steven Staples wrote:
Ok, I have done it before, where I have used the AS result in an ORDER BY,
but now, I can't figure out why I can't use it in a WHERE clause?
SELECT `email`, (SELECT CONCAT(`phone_pref`, '-', `phone_suff`) FROM `pnums`
WHERE `id`=`usertable`.`id`) AS pn
You can use an Alias in ORDER BY but not in WHERE clauses.
Keith
On Thu, 2010-06-10 at 16:38 -0400, Steven Staples wrote:
> Ok, I have done it before, where I have used the AS result in an ORDER BY,
> but now, I can't figure out why I can't use it in a WHERE clause?
>
> SELECT `email`, (SELECT C
Hello Chris,
Your Query Build
EXPLAIN SELECT COUNT(FlightRoutes.FlightID) AS Count, FlightRoutes.Dep AS
Dep, FlightRoutes.Des AS Des FROM FlightRoutes LEFT JOIN IVAOData ON
FlightRoutes.FlightID=IVAOData.FlightID WHERE IVAOData.TrackerTime >=
UNIX_TIMESTAMP('2010-04-01 00
You could be running into this:
http://dev.mysql.com/doc/refman/5.0/en/how-to-avoid-table-scan.html
On Fri, May 7, 2010 at 10:05 AM, Peter Brawley
wrote:
> something tells me I need to rethink this yes.
>>
>
> If you were to add a computed column yearmonth, you could write WHERE
> yearmonth=20
something tells me I need to rethink this yes.
If you were to add a computed column yearmonth, you could write WHERE
yearmonth=201004.
PB
-
Chris Knipe wrote:
On Fri, May 7, 2010 at 10:42 AM, Rob Wultsch wrote:
Second thing:
How selective is
"WHERE IVAOData.TrackerTime >=UNIX_TIME
On Fri, May 7, 2010 at 10:42 AM, Rob Wultsch wrote:
> Second thing:
> How selective is
> "WHERE IVAOData.TrackerTime >=UNIX_TIMESTAMP('2010-04-01 00:00:00')
>AND IVAOData.TrackerTime <=UNIX_TIMESTAMP('2010-04-30 23:59:50') "
>
> Test by running
> SELECT COUNT(*)
> FROM IVAOData
> WHERE I
Added whitespace for readabilty:
SELECT
COUNT(FlightRoutes.FlightID) AS Count,
FlightRoutes.Dep AS Dep,
FlightRoutes.Des AS Des
FROM FlightRoutes
LEFT JOIN IVAOData ON FlightRoutes.FlightID=IVAOData.FlightID
WHERE IVAOData.TrackerTime >=UNIX_TIMESTAMP('2010-04-01 00:00:00')
My appologies for leaving that bit out...
mysql> EXPLAIN SELECT COUNT(FlightRoutes.FlightID) AS Count,
FlightRoutes.Dep AS Dep, FlightRoutes.Des AS Des FROM FlightRoutes LEFT JOIN
IVAOData ON FlightRoutes.FlightID=IVAOData.FlightID WHERE
IVAOData.TrackerTime >= UNIX_TIMESTAMP('2010-04-01 00:00:00'
Hey Chris,
Please send the explain plan for this query, the estimated table sizes (in
MB or GB) and the RAM capacity.
These are also the requisites for helping optimizing your query if
required...
Thanks.
Anirudh Sundar
On Fri, May 7, 2010 at 12:14 PM, Chris Knipe wrote:
> Hi All,
>
> I hav
On 06/02/2010, at 5:31 PM, MuraliKrishna wrote:
Hi
I am in need to know about handlers and cursors.. if any site giving
detailed explanation and examples on these. thanks in advance
Cursors: http://dev.mysql.com/doc/refman/5.1/en/cursors.html
Handlers: http://dev.mysql.com/doc/refman/5.1/en
Andy Shellam wrote:
My thoughts exactly!
This article might help:
http://dev.mysql.com/tech-resources/articles/mysql-54.html
It worries me though that 5.1 went through a large number of alpha
releases, then a set of beta releases before the GA release came out.
It looks like they've thrown
.
From: Andy Shellam [andy-li...@networkmail.eu]
Sent: Thursday, April 30, 2009 2:19 PM
To: Daevid Vincent
Cc: mysql@lists.mysql.com
Subject: Re: Where the hell did 5.4 come from?
My thoughts exactly!
This article might help:
http://dev.mysql.com/tech-resources/articles/mysql-54
My thoughts exactly!
This article might help:
http://dev.mysql.com/tech-resources/articles/mysql-54.html
It worries me though that 5.1 went through a large number of alpha
releases, then a set of beta releases before the GA release came out.
It looks like they've thrown 5.4 straight out wit
Hi, Dan Nelson & Rolando Edwards
It works, thank you. :-)
2009/3/26 Rolando Edwards :
> The table mysql.proc always contains the hard code of stored procedures and
> functions.
>
> Triggers in 5.0 are stored in a .TRG file
> Make sure, if you used mysqldump, to include --triggers as a dump op
The table mysql.proc always contains the hard code of stored procedures and
functions.
Triggers in 5.0 are stored in a .TRG file
Make sure, if you used mysqldump, to include --triggers as a dump option
Rolando A. Edwards
MySQL DBA (CMDBA)
155 Avenue of the Americas, Fifth Floor
New York, NY 100
In the last episode (Mar 26), Cui Shijun said:
> It seems that the stored functions isn't stored in a seperated file
> like trigger does.
> Where are them?
> If I copy the database directory from a server to another, can I get
> the same functions on the both servers?
They're stored in the m
2009/2/4 Baron Schwartz
> On Tue, Feb 3, 2009 at 12:24 PM, Jerry Schwartz
> wrote:
> > Somebody, I think it was somebody from MySQL, said that you should never
> put
> > anything into a WHERE clause that could be put into the ON clause of a
> JOIN.
> > My guess is that this helps with the optimi
Never tried it in MySQL and Im not
in a position to do so
at the moment
but in Oracle you can do a left outer join in the where
clause something
like this
SELECT t1.col1, t2.col2
FROM table1 t1, table2 t2
WHERE t1.join_col_name = t2.join_col_name(+)
Does this not work in MySQL?
Luckily, it
>-Original Message-
>From: John Daisley [mailto:john.dais...@mypostoffice.co.uk]
>Sent: Wednesday, February 04, 2009 10:41 AM
>To: mysql@lists.mysql.com
>Cc: Jerry Schwartz
>Subject: Re: WHERE vs. ON
>
>Never tried it in MySQL and Im not
>in a position to d
Never tried it in MySQL and Im not
in a position to do so
at the moment
but in Oracle you can do a left outer join in the where
clause something
like this
SELECT t1.col1, t2.col2
FROM table1 t1, table2 t2
WHERE t1.join_col_name = t2.join_col_name(+)
Does this not work in MySQL?
Never tried it be
>-Original Message-
>From: baron.schwa...@gmail.com [mailto:baron.schwa...@gmail.com] On
>Behalf Of Baron Schwartz
>Sent: Wednesday, February 04, 2009 10:03 AM
>To: Jerry Schwartz
>Cc: mysql@lists.mysql.com
>Subject: Re: WHERE vs. ON
>
>On Tue, Feb 3, 2009
On Tue, Feb 3, 2009 at 12:24 PM, Jerry Schwartz
wrote:
> Somebody, I think it was somebody from MySQL, said that you should never put
> anything into a WHERE clause that could be put into the ON clause of a JOIN.
> My guess is that this helps with the optimization, but it seems
> counter-intuitive
On Tue, Feb 3, 2009 at 1:54 PM, Jerry Schwartz
wrote:
> From: Martin Gainty [mailto:mgai...@hotmail.com]
> Sent: Tuesday, February 03, 2009 1:03 PM
> To: Jerry Schwartz; mysql@lists.mysql.com
> Subject: RE: WHERE vs. ON
> ON condition uses the same columnname from both source an
From: Martin Gainty [mailto:mgai...@hotmail.com]
Sent: Tuesday, February 03, 2009 1:03 PM
To: Jerry Schwartz; mysql@lists.mysql.com
Subject: RE: WHERE vs. ON
ON condition uses the same columnname from both source and target tables
whereas any column expressions can go in the WHERE
On Tue, Feb 3, 2009 at 12:24 PM, Jerry Schwartz
wrote:
> Somebody, I think it was somebody from MySQL, said that you should never put
> anything into a WHERE clause that could be put into the ON clause of a JOIN.
> My guess is that this helps with the optimization, but it seems
> counter-intuitive
ON condition uses the same columnname from both source and target tables
whereas any column expressions can go in the WHERE clause...
Martin
__
Disclaimer and confidentiality note
Everything in this e-mail and any attachments relates to the official
Thanks for alll of you reply.
I know this version is too old and it has many bugs and security issues, but
this is our current using edition .I have no choice for it.
Thanks for you again!
On Fri, Nov 7, 2008 at 4:31 AM, Eric Bergen <[EMAIL PROTECTED]> wrote:
> If you still want it you can downlo
If you still want it you can download it from the Proven Scaling mirror.
http://mirror.provenscaling.com/mysql/community/source/4.0/
-Eric
On Thu, Nov 6, 2008 at 1:58 AM, Joerg Bruehe <[EMAIL PROTECTED]> wrote:
> Hi!
>
>
> Moon's Father wrote:
>> Hi.
>>Where can I download a mysql 4.0.12? I
Hi!
Moon's Father wrote:
> Hi.
>Where can I download a mysql 4.0.12? I found nowhere to download it.
You will not find it anywhere at MySQL, it is out of support since more
than 2 years (September 2006).
For an explanation, read the text here:
http://downloads.mysql.com/archives.php?p=mys
Hi
If you're searching for, effectively, %123% you probably can't use IN(). You
could get away with wildcard patterns - if it's a heavily used field
consider an index to increase performance. Hard to tell if this may be a FK
of sorts, but if so you should use it as one which may involve normalisin
On Thu, 2008-07-24 at 09:34 +0530, Sivasakthi wrote:
> How can we normalize the tables? could you explain bit more?
>
>
> Thanks,
> Siva
>
>
Normalization is a complex subject. I suggest you search the web for
tutorials. Try the search terms: RDBM normalization
--
Just my 0.0002 milli
How about: WHERE ( field1 LIKE '123,%' OR field1 LIKE '*,123,%' OR
field1 LIKE '%,123' OR field1 = '123' )
Note that this could that a long time on large tables. You'd be better
off to normalize your tables ;)
How can we normalize the tables? could you explain bit more?
Thanks,
Siva
On Wed, 2008-07-23 at 17:05 +0300, Ali Deniz EREN wrote:
> Hi all,
>
> I have a problem as below:
>
> A text field -Lets call it 'field1'- contains datas seperated by
> commas(,) like this (123,5764,8795,9364,11,232,. and go on) And so
> my lines like these:
>
> id title filed1
> -
>A text field -Lets call it 'field1'- contains datas seperated by
commas(,)
> like this (123,5764,8795,9364,11,232,.
The solution is to normalise the data.
PB
Ali Deniz EREN wrote:
Hi all,
I have a problem as below:
A text field -Lets call it 'field1'- contains datas seperated by
comma
On Fri, February 8, 2008 13:09, Paolo Amodio wrote:
>
> Il giorno 08/feb/08, alle ore 21:55, Riccardo Perotti ha scritto:
>
>> Hi all:
>>
>> Our sistem crashed and we're trying to recover our data. The disc is
>> fine but the OS is gone, so I'm trying to get at the actual mysql
>> databases documen
Il giorno 08/feb/08, alle ore 22:29, Riccardo Perotti ha scritto:
On Feb 8, 2008, at 4:02 PM, Paolo Amodio wrote:
Il giorno 08/feb/08, alle ore 21:55, Riccardo Perotti ha scritto:
Hi all:
Our sistem crashed and we're trying to recover our data. The disc
is fine but the OS is gone, so
RedHat centric systems store them in /var/lib/mysql
On Feb 8, 2008, at 2:55 PM, Riccardo Perotti wrote:
Hi all:
Our sistem crashed and we're trying to recover our data. The disc is
fine but the OS is gone, so I'm trying to get at the actual mysql
databases document. Does anybody know where
Il giorno 08/feb/08, alle ore 21:55, Riccardo Perotti ha scritto:
Hi all:
Our sistem crashed and we're trying to recover our data. The disc is
fine but the OS is gone, so I'm trying to get at the actual mysql
databases document. Does anybody know where to look for them in a
*nix system?
On Sat, 2008-01-19 at 19:02 +, Apple wrote:
> Fatal error: Call to undefined function mysql_connect() in
> /home/re/script.php on line 3
>
>
> I've googled and found out that I need to add extension=mysql.so
> in CLI's php.ini file (separate php.ini file that works for CLI only).
>
>
Hi,
Try the following link
ftp://ftp.pbone.net/mirror/remi.collet.free.fr/rpms/fc6.x86_64/php-mysql-5.2.5-1.fc6.remi.x86_64.rpm
if that doesn't match your need search http://rpm.pbone.net
Saravanan
--- On Sun, 1/20/08, Apple <[EMAIL PROTECTED]> wrote:
> From: Apple <[EMAIL PROTECTE
Olav Mørkrid wrote:
hello
does anyone know what is returned when you do a where column without
further parameters?
SELECT * FROM TABLE WHERE COLUMN;
for integer columns it seems to return non-zero columns, but for other
types of columns the results seemed unpredictable.
The value of the co
- Original Message -
From: "Olav Mørkrid" <[EMAIL PROTECTED]>
To:
Sent: Friday, August 24, 2007 1:07 AM
Subject: where column
hello
does anyone know what is returned when you do a where column without
further parameters?
SELECT * FROM TABLE WHERE COLUMN;
for integer columns it se
@lists.mysql.com
Subject: Re: WHERE (NOT) EXISTS problem
Michael Fischer wrote:
> Having a very bad time with the subject sorts of queries.
> Here is a simple reproduction of the problem for me.
> Perhaps I'm blind/stupid while looking at the docs,
> or there's a bug...
>
> m
Hello Michael. Here is the query you wanted - you were almost there.
SELECT DISTINCT NAME FROM PEOPLE
WHERE ID IN
(SELECT PID FROM PEOPLE_CITY_MAP
WHERE CID = 1)
Thanks.
-Original Message-
From: Michael Fischer [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 31, 2007 11:53
Michael Fischer wrote:
Having a very bad time with the subject sorts of queries.
Here is a simple reproduction of the problem for me.
Perhaps I'm blind/stupid while looking at the docs,
or there's a bug...
mysql version 5.0.24-standard
simple schema:
mysql> desc people;
+---+
Daniel Kasak wrote:
> VeeJay wrote:
>> Where one can find Source Distribution of MySQL Server 5.0 Standard for
>> FreeBSD?
>
> Not on the website, that's for sure.
> Have you tried the usual warez sites, p2p networks, etc?
Really? Seems pretty straightforward to me. One the downloads page,
unde
On Thursday 14 December 2006 14:37, Bruce Ferrell wrote:
> >> Where one can find Source Distribution of MySQL Server 5.0 Standard for
> >> FreeBSD?
> >
> > Not on the website, that's for sure.
> > Have you tried the usual warez sites, p2p networks, etc?
>
> Actually the source tarball IS on the mys
Daniel Kasak wrote:
VeeJay wrote:
Hi
Where one can find Source Distribution of MySQL Server 5.0 Standard for
FreeBSD?
Not on the website, that's for sure.
Have you tried the usual warez sites, p2p networks, etc?
Actually the source tarball IS on the mysql download site.
--
One day at
VeeJay wrote:
Hi
Where one can find Source Distribution of MySQL Server 5.0 Standard for
FreeBSD?
Not on the website, that's for sure.
Have you tried the usual warez sites, p2p networks, etc?
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Aus
Peter Van Dijck wrote:
>
> Thanks.. the problem is I'm running MySQL 4.1.16
>
> I might try FULLTEXT...
U can create normal indexes on text columns if u specify a prefix
length.
--
Chris Wagner
CBTS
GE Aircraft Engines
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http:
Thanks.. the problem is I'm running MySQL 4.1.16
I might try FULLTEXT...
On 9/27/06, Dan Buettner <[EMAIL PROTECTED]> wrote:
You can create FULLTEXT indexes on text fields - but that may not be
the best solution for your situation since you are querying for an
exact match.
In MySQL 5.0.3 and l
You can create FULLTEXT indexes on text fields - but that may not be
the best solution for your situation since you are querying for an
exact match.
In MySQL 5.0.3 and later, you can create VARCHAR columns of up to
65,535 character lengths:
http://dev.mysql.com/doc/refman/5.0/en/char.html
I seem
I think you have to specify a key length when you use an index on a
text field...
mysql> alter table t2 add index i2(t1(3));
That would create an index (called "i2") on the first 3 characters of
field "t1" of table "t2".
I think that's right?
Douglas Sims
[EMAIL PROTECTED]
On Sep 27, 2
To Jimmy Guerrero, Paul DuBois and Fred Ballard,
Your information was very valuable, I already solved the problem, thank you.
Misingo :-)
> Hello,
>
> A default install should drop data and databases into C:\Program
> Files\MySQL\MySQL Server 5.0.\data
>
> If you run something like:
>
--
MySQL
ly thoroughly mess up your
access to the underlying stored database data.
Fred
> -Original Message-
> From: Paul DuBois [mailto:[EMAIL PROTECTED]
> Sent: Thursday, September 07, 2006 5:49 PM
> To: [EMAIL PROTECTED]
> Cc: mysql@lists.mysql.com
> Subject: Re: where are the .MYI and
[EMAIL PROTECTED] wrote:
I've installed MySQL, created a database and tables and then loaded fields
into them. I use the command line client and can see the fields, use the
select command and every thing is OK, but when I look for the table files
in the data directory, only the .frm ones appear,
Hello,
A default install should drop data and databases into C:\Program
Files\MySQL\MySQL Server 5.0.\data
If you run something like:
mysql> CREATE DATABASE test1;
Query OK, 1 row affected (0.00 sec)
mysql> USE test1;
Database changed
mysql> CREATE TABLE t (i INT) ENGINE = MYISAM;
Query OK, 0
Greg 'groggy' Lehey wrote:
I have downloaded a code on c++ to talk to MySQL database from net which
included a file "sqlplus.hh" , where may I find the file?Please help me
soon.
That's the main header file for MySQL++ v1.7.9. You can download that
release from the official MySQL++ page:
On Thursday, 3 August 2006 at 22:56:54 -0700, Ratnadeep Nayak wrote:
> Hello,
> I have downloaded a code on c++ to talk to MySQL database from net which
> included a file "sqlplus.hh" , where may I find the file?Please help me
> soon.
It's not in our code. It must be in the code you downloaded.
nayak_ratnadeep wrote:
I found in net but can't get the file. please help me..
Always reply to the list.
Here's a hint: look for "C++ API" in the documentation.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROT
nayak_ratnadeep wrote:
Hello,
I have downloaded a code on c++ to talk to MySQL database from net which
included a file "sqlplus.hh" , where may I find the file?Please help me
soon.
Why have you posted this 5 times?
Did you look at the mysql website at ALL?
It took me 30 seconds to find i
That did it, thank you all!
-Original Message-
From: Michael Stassen [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 27, 2006 2:10 AM
To: Peter Lauri
Cc: mysql@lists.mysql.com
Subject: Re: WHERE problem, or is it a problem?
Peter Lauri wrote:
> Best group member,
>
> I have t
Use the HAVING clause:
SELECT part.memberid, part.prefname, part.email, COUNT(*) AS numberofans
FROM tblparticipants part
LEFT JOIN tblanswers answer ON (answer.par_num=part.memberid)
LEFT OUTER JOIN profilepdfauth pdfauth ON (part.memberid=pdfauth.memberid)
WHERE pdfauth.id IS NULL
GROUP BY part.
Peter Lauri wrote:
Best group member,
I have this query on MySQL version 4.0.27:
SELECT part.memberid, part.prefname, part.email, COUNT(*) AS numberofans
FROM tblparticipants part
LEFT JOIN tblanswers answer ON (answer.par_num=part.memberid)
LEFT OUTER JOIN profilepdfauth pdfauth ON (part.membe
Hi Rick, all!
Rick Robinson wrote:
The documentation shows MySQL 5.0.23 as released on July 4 - but I do not see it on any mirror anywhere? Does anyone know where MySQL
5.0.23 is? Is it released, as the doc says? Is it being held until release 5.0.24?
The "release date" in the documentatio
On 6/1/06, Patrik Wallstrom <[EMAIL PROTECTED]> wrote:
Easy setup: two mysql 5 servers, one running master, the other one is
slave. The database have triggers to create history of rows in history
tables.
What is expected from the slave? Is it expected to run the triggers,
as well as receiving th
[EMAIL PROTECTED] wrote:
>I want to select a list, where it was registered in tbl
club_get_match with Id-
>Member in tbl detail_club_member, but it's not registered in tbl
wager.
Your schema has a problem: wagers.name_club is too short. If no
club_get_match.name_club value is longer than 20 c
CREATE TABLE `club_get_match` (
`id_match` bigint(100) NOT NULL default '0',
`name_club` varchar(30) NOT NULL default '',
`status` varchar(30) default NULL,
`prediction_match` varchar(5) NOT NULL default '',
`equal_match` char(3) NOT NULL default '',
`score` varchar(50) default NULL,
[EMAIL PROTECTED] wrote:
Sory if my question makes you confused
I've a problem with my sintax,
I don't know how to select a list, whether it's not registered in another
table, but it have 2 IDs.
Not enough info. Show the Create Table statements, a bit of data, and
the desired result.
PB
I
Solved =)
From: "Quentin Bennett" <[EMAIL PROTECTED]>
Have you tried turning on the logging on the MySQL server, and seeing
exactly what command the server is receiving - it may be different from the
one (you
think) you are sending.
Turning on the logging on the MySQL server, I saw PHP
Solved =)
From: "Quentin Bennett" <[EMAIL PROTECTED]>
Have you tried turning on the logging on the MySQL server, and seeing
exactly what command the server is receiving - it may be different from the
one (you
think) you are sending.
Turning on the logging on the MySQL server, I saw PHP
5:00 a.m.
To: mysql@lists.mysql.com
Subject: Re: WHERE doesn'r works
From: "Jay Blanchard" <[EMAIL PROTECTED]>
>Post the line of PHP where this query exists.
Well, I think that show
$result = mysql_query($command);
won't help us, because the $command in
From: "Jay Blanchard" <[EMAIL PROTECTED]>
Post the line of PHP where this query exists.
Well, I think that show
$result = mysql_query($command);
won't help us, because the $command indeed begins to be constructed 120
lines before this. Only looking the code =(
Tom
--
My
Tom,
Maybe a comunication trouble... Let me confirm. Are you saying that
http://www.spalha.com.br/spalha/DB_code.html
http://www.spalha.com.br/spalha/insert_client_code.html
are not the code Im having troubles? As the code Im having trouble
were some secret or so?
if ($yes){
$communicat
From: "Jay Blanchard" <[EMAIL PROTECTED]>
Find a place online to post your code or paste it into the message (only
the relevant parts). Usually no one will open an attachment on a mailing
list.
Oh Yes, sorry. In really, I indeed uploaded the files to the server
www.spalha.com.br/spalha.
T
[snip]
Find a place online to post your code or paste it into the message (only
the relevant parts). Usually no one will open an attachment on a mailing
list.
[/snip]
Post the line of PHP where this query exists.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To un
[snip]
The php and db structure and data are attacheds. Two infos: 1) Im
not a
expert 2) The code is in the beggining of the development, so are too
many
uglyness yet =)
[/snip]
Find a place online to post your code or paste it into the message (only
the relevant parts). Usually no one will
The code of insert_client.html which wasn't attached last mail:
http://www.spalha.com.br/spalha/form_client.html
Tom
From: "Tom Lobato" <[EMAIL PROTECTED]>
From: "Peter Brawley" <[EMAIL PROTECTED]>
Tom,
> UPDATE command is not working for only the record that I want, but
> for
>all in t
From: "Peter Brawley" <[EMAIL PROTECTED]>
Tom,
> UPDATE command is not working for only the record that I want, but for
>all in the table. I sees WHERE is not interpretated by Mysql server. At
>least the result is identic to it. For example, If my php execute
> UPDATE clientes SET
Tom,
> UPDATE command is not working for only the record that I want, but for
>all in the table. I sees WHERE is not interpretated by Mysql server. At
>least the result is identic to it. For example, If my php execute
> UPDATE clientes SET tipo='r', nome_fantasia='cc', estado='24'
>W
- Original Message -
From: "Tom Lobato" <[EMAIL PROTECTED]>
To:
Sent: Saturday, April 22, 2006 4:18 PM
Subject: Re: WHERE doesn'r works
From: "Rhino" <[EMAIL PROTECTED]>
Most of the time, when I see a column named 'id', it is
From: "Rhino" <[EMAIL PROTECTED]>
Most of the time, when I see a column named 'id', it is defined as an
integer. If _your_ 'id' column is defined as an integer, then the reason
your WHERE clause is failing is very simple: Your WHERE clause is looking
for all the rows where the 'id' value is a ch
- Original Message -
From: "Tom Lobato" <[EMAIL PROTECTED]>
To:
Sent: Saturday, April 22, 2006 4:03 AM
Subject: Re: WHERE doesn'r works
From: <[EMAIL PROTECTED]>
you really need to show your php code and the output from an echo of
the update line so
From: <[EMAIL PROTECTED]>
you really need to show your php code and the output from an echo of
the update line so that people can try to spot what you're doing wrong.
from what i've seen, people are basically just guessing at the issue
with you saying "tried that, didn't work".
updating mysql r
1 - 100 of 377 matches
Mail list logo
