Charles:
I am not quite sure by what you mean, How do I get it to show me as I
like, one in and one out per line, rather then an in for every out and
vice-versa?
It seems for your example below you want a result set of 4 rows
I don't think your design is appropriate, however your suggestion at
Boyd,
Thank you very much for the design help... this is just what I am
looking for, just wasn't clear how to best do it :)
BTW, you can use a case statement to help with signing the number
properly. I just discovered this the other day and am really tickled
with it!
I am not very experienced
should be able to claim SQL as a second language - you can say so
much with it!
Brandon Ewing
-Original Message-
From: Dominique Plante [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 27, 2004 4:43 PM
To: 'Brandon Ewing'
Subject: RE: Need help with a SELECT statement across 3 tables
Brandon
* Soheil Shaghaghi
Hello everyone,
I need help with MySQL coding in php please if anyone can help.
I can try. :)
I have 3 tables:
-users, where the user info is stored.
-awards: contains the list of all the awards for each user
-award_types: contains different types of award
The tables
Tibby wrote:
..and I want to get this with a single query:
+-++--+
| key | desc| value |
+-++--+
| 2 | book| 7 |
| 6 | pen | 7 |
+-++--+
I need to get only one row from col. DESC, the one with the highest VALUE.
Hi,
I have already tried the 'rtfm', but it just didn't help.
But it's right there :)
3.5.2 The Row Holding the Maximum of a Certain Column
..and I want to get this with a single query:
+-++--+
| key | desc| value |
+-++--+
| 2 | book|
* Aleksandar Bradaric
select key, desc, value
from your_table t1
where value = (select max(value) from your_table where desc = t1.desc)
Anyway, when i execute this query, i get an error near 'select
max(value)'... :(
It's because the subselects are supported from version 4.1.
Try:
SELECT C.company_id, C.company_name
FROM companies C
LEFT JOIN company_group_intersect CG
ON (C.company_id=CG.company_id AND CG.group_id='1')
WHERE C.status='1' AND CG.company_id IS NULL
--
Diana Soares
On Fri, 2003-12-05 at 15:08, Robert Hughes wrote:
I have the following 3 tables:
That worked perfectly!!! Thanks so much :-)
-Original Message-
From: Diana Soares [mailto:[EMAIL PROTECTED]
Sent: Friday, December 05, 2003 10:31 AM
To: Robert Hughes
Cc: [EMAIL PROTECTED]
Subject: Re: Need help with query. Please!
Try:
SELECT C.company_id, C.company_name
FROM
On Wed, 19 Nov 2003, Mark Marshall wrote:
Hi, everyone.
I have a 4.0.4 beta install of Mysql on Red Hat 7.3. I want to upgrade
it to 4.0.16, and keep all the data intact. Do I just dump the
databases (just in case), stop the server, then ./configure, make, make
install over top of the old
PROTECTED]
To: Mark Marshall [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, November 19, 2003 10:18 AM
Subject: Re: Need Help Upgrading From 4.x to 4.x
On Wed, 19 Nov 2003, Mark Marshall wrote:
Hi, everyone.
I have a 4.0.4 beta install of Mysql on Red Hat 7.3. I want to upgrade
What if one is using rpm - should just use the --upgrade option
rpm -U MySQL-server-4.x
Is this ok to do?
Thanks
Aman Raheja
AGF Technologies
http://www.agftech.com
[EMAIL PROTECTED] wrote:
On Wed, 19 Nov 2003, Mark Marshall wrote:
Hi, everyone.
I have a 4.0.4 beta install of Mysql on Red
KEVIN ZEMBOWER wrote:
The organization hired an outside consultant to
evaluate which SQL engine to go with. This is
what he sent to us:
...
SQL Server 2000 is a complete Relational Database
Management System (RDBMS) that also includes integrated
analysis functionality for OLAP and data mining.
* John Kelly
I have a table of full URLs and IPs and am using the following
query to return
distinct web requests by domain. Using SUBSTRING_INDEX it only returns the
domain part of the URL:
SELECT SUBSTRING_INDEX(url, '/', 3) as topsites, count(distinct
ip) as count
from tablename WHERE
Hi Kevin,
I'm a system administrator for a small (200 people) branch of a large
university/medical school. I've worked with MySQL and use it as my database
of choice for web-based dynamic content. I would not consider myself an
experienced, professionally-trained, knowledgeable database
Martijn, thank you very much for your analysis. I hope others will continue to join in.
With regard to your point quoted below, are you referring to PostgreSQL, and would
that be a
stronger competitor to MS SQL Server 2000 than either the current version of MySQL or
MySQL 5?
Thanks, again, for
Hi Kevin,
Martijn, thank you very much for your analysis.
I hope others will continue to join in.
So do I :-)
With regard to your point quoted below, are you referring to PostgreSQL,
and would that be a
stronger competitor to MS SQL Server 2000 than either the current version
of MySQL or
I have not work with it but postgres is supposed to work great in
/BSD/Linux/Unix/solaris environment
Which platform are you using?
:-)
Nestor A. Florez
Martijn Tonies [EMAIL PROTECTED] 11/7/2003 10:08:53 AM
Hi Kevin,
Martijn, thank you very much for your analysis.
I hope others will
It sounds like a copy and paste from Microsoft, but that is just my
guess. An objective recommendation with show pluses and minuses of
both. It most definitely does not sound like this consultant is
qualified to suggest a database product. What about PostgresSQL,
Oracle, Sybase, DB2? They all
Nestor, thanks for your question.
The platform will actually be dictated by the SQL engine, not the
other way around, which is more typically the case. If we go with
MS SQL Server, we'll build a separate host, NT I would guess, to
host it. I'm only responsible for Unix and Linux boxes here, so
that do
very nicely without them. Why are you different?
John Griffin
-Original Message-
From: KEVIN ZEMBOWER [mailto:[EMAIL PROTECTED]
Sent: Friday, November 07, 2003 1:53 PM
To: [EMAIL PROTECTED]
Subject: Re: Need help comparing MySQL to MS SQL Server
Nestor, thanks for your question
kevin,
i tend to think the consultant really just read something that microsoft
sent him. it doesn't sound like he's qualified to suggest one database
or another.
We've been usinf mysql for a year now. We use InnoDB tables, which give
us primary key/foreign key constraints and transactions.
This should work for you:
SELECT * FROM sometable WHERE surname BETWEEN 'A' AND 'D' ORDER BY
surname
In my quick test the first parameter is inclusive while the second is
not, which is why it is D and not C.
On Thursday, October 30, 2003, at 02:22 PM, Scott Brown wrote:
I want to do a string
You can use RLIKE which is regular expressions then you should be able to execute
SELECT * FROM sometable WHERE surname RLIKE '^[A-C]' ORDER BY surname;
Kelley
Scott Brown wrote:
Hi, List,
I looked here:
http://www.mysql.com/doc/en/String_comparison_functions.html
But I am not seeing
Thanks for all of the responses!
Actually, Brent Baisley wins the syntax question of the day. The BETWEEN
syntax is what I needed.
REGEXP and RLIKE do not return any records, they return a count of the
number of rows matching the expression.
Thanks!
--Scott Brown
At 11:22 AM 10/30/2003, you
Thanks so much Brent, this is what I was looking for.
However, what do I do when I get to 'Z'?
I looked here, and now I am really confused:
http://www.mysql.com/doc/en/Comparison_Operators.html
It seems to say that BETWEEN returns a rowcount as well?
I am guessing that these all return
Oh, well, chalk it up to experience. RLIKE is what works the way I want. DOH!
Thanks,
--Scott Brown
At 12:34 PM 10/30/2003, you wrote:
Thanks so much Brent, this is what I was looking for.
However, what do I do when I get to 'Z'?
I looked here, and now I am really confused:
The BETWEEN operator works like and greater and less than search.
So, you can do the exact same query like this:
SELECT * FROM sometable WHERE surname='A' AND surname'D'
MySQL may actually optimize them the same way, but using BETWEEN is
more readable.
To include 'Z', just do a greater than
: Need help on WHERE ... LIKE Query
The BETWEEN operator works like and greater and less than search.
So, you can do the exact same query like this:
SELECT * FROM sometable WHERE surname='A' AND surname'D'
MySQL may actually optimize them the same way, but using BETWEEN is
more readable
]
: Cc: [EMAIL PROTECTED]
: Subject: Re: Need help constructing query ...
:
:
: - Original Message -
: From: Daniel Clark [EMAIL PROTECTED]
: To: [EMAIL PROTECTED]
: Cc: [EMAIL PROTECTED]
: Sent: Tuesday, October 21, 2003 2:33 PM
: Subject: Re: Need help constructing query
Hi, I have a table full of logged urls and ip addresses. The following
query returns all the urls and the number of requests. How would I
modify it to return unique requests based on distinct ip addresses?
select url, count(*) as pageviews from table group by url order by
pageviews desc
- Original Message -
From: Daniel Clark [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, October 21, 2003 2:33 PM
Subject: Re: Need help constructing query ...
: Hi, I have a table full of logged urls and ip addresses. The following
: query returns all
Then I think you want
SELECT url, COUNT(DISTINCT ip_address)
FROM tablename
GROUP BY url;
-Original Message-
From: John Kelly [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 21, 2003 3:45 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Need help constructing query
: -Original Message-
: From: John Kelly [mailto:[EMAIL PROTECTED]
: Sent: Tuesday, October 21, 2003 3:45 PM
: To: [EMAIL PROTECTED]
: Cc: [EMAIL PROTECTED]
: Subject: Re: Need help constructing query ...
:
:
: - Original Message -
: From: Daniel Clark [EMAIL PROTECTED
Patrick Shoaf [EMAIL PROTECTED] wrote:
I have a table name product defined as follows:
Item_Code
Item_Size
Item_Color
Item_img
Description
Cost
Retail_Price
Category
and other non-essential items, such as qty based on code,size,color
The data is as follows:
j2400 S BLK
I loaded MySQL 4.1, but now the text is gibberish in the Group_Concat field
SELECT Cat_Item_Img,Cat_Price,Product.Item_Code,GROUP_CONCAT(Item_Size
SEPARATOR ;) as sizes,Item_Img,
Description,Category,Retail_Price,Short_Desc,Product.Item_Color
FROM Cat_Items,Product
WHERE cat_code =BoltTech and
- Original Message -
I would use MySQL CC (command center, I think...)... I seem to remember
someone mentioning that mysql gui is discontinued...
CC is available from the mysql.org site, and is very easy to install on
windows xp (it's on my laptop...)
/originalmessage
I second that.
I would use MySQL CC (command center, I think...)... I seem to remember someone
mentioning that mysql gui is discontinued...
CC is available from the mysql.org site, and is very easy to install on windows xp
(it's on my laptop...)
-Original Message-
From: Liwen Han [mailto:[EMAIL
Dan Greene wrote:
I would use MySQL CC (command center, I think...)... I seem to remember someone
mentioning that mysql gui is discontinued...
You remember right, the MySQL GUI IS discontinued. Why it is still
availiable for download, ask MySQL
Jakob
^--
To Unix or not to Unix. That is
: [EMAIL PROTECTED]
Sent: Monday, September 01, 2003 6:18 AM
Subject: Re: Need help with oracledump (contributed program)
On Mon, Sep 01, 2003 at 01:03:48PM +0100, Jim Smith wrote:
I'm trying to figure out how to use the contributed program
oracledump in an environment where I don't have
PROTECTED]
Subject: Re: Need help with oracledump (contributed program)
On Mon, Sep 01, 2003 at 11:09:02AM -0700, Martin Gainty wrote:
Doug
I copied this from an SAP integration with Orace site
http://saphelp.cob.csuchico.edu/OraHelp/Darwin36/inst36fhp/htm
l/5-odbc.htm
5.5.3 tsnames.ora
On Tue, Sep 02, 2003 at 12:25:35PM +0100, Jim Smith wrote:
A TNSNAMES file isn't going to help unless you have the Oracle
client software installed. If you had the software, you would
already have a tnsnames file.
Thanks all for your help. I've found a free java-based application
I'm trying to figure out how to use the contributed program
oracledump in an environment where I don't have a login to the *nix
host running Oracle. All my connectivity to the Oracle host is via
port 1521 and JDBC.
The oracle dump command seems to be looking for a SID in a file called
On Mon, Sep 01, 2003 at 01:03:48PM +0100, Jim Smith wrote:
I'm trying to figure out how to use the contributed program
oracledump in an environment where I don't have a login to the *nix
host running Oracle. All my connectivity to the Oracle host is via
port 1521 and JDBC.
The oracle
.
*OracleDump is performed by (SID=ORCL)*
Keep us apprised to your progress...
Marty Gainty
- Original Message -
From: Doug Poland [EMAIL PROTECTED]
To: Jim Smith [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, September 01, 2003 6:18 AM
Subject: Re: Need help with oracledump (contributed
Are your tables indexed? http://www.mysql.com/doc/en/MySQL_indexes.html
Saqib Ali
-
http://www.xml-dev.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Absolutely! I have multiple indexes. I think it might be a problem with ODBC
Are your tables indexed? http://www.mysql.com/doc/en/MySQL_indexes.html
Saqib Ali
-
http://www.xml-dev.com
-
Visit CARMEL MUSIC ENTERTAINMENT website
When following query is pulled up, it takes about whole 1-2 minutes to come up.
inquiries table has 17000 records, contacts has about 7000,
individual_contacts has about 16000.
It has gotten worse once I upgraded to 4.0 and latest MyODBC.
Clients are separate machines (mix of Win98 and WinXP).
: Wednesday, August 20, 2003 2:52 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: Need help optimizing query, awfully slow on only
2 records
When following query is pulled up, it takes about whole 1-2
minutes to come up. inquiries table has 17000 records,
contacts
Query takes 3.4 seconds to run on the server, but it takes 1-2minutes to run via
MyODBC 3.51.06 using passthrough (Access97 is the front end, but it has query
type that allows bypass of Access interpretation.
Two Questions:
Is the same query running directly on the linux server thru mysql is
To: Michael S. Fischer
Cc: [EMAIL PROTECTED]
Subject: RE: Need help optimizing query, awfully slow on only
2 records
Result of EXPLAIN is:
table|type|possible_keys|key|key_len|ref|rows|Extra
inquiries|ALL|contact_id| | | |8253|Using filesort
individual_contacts|eq_ref
]
Sent: Wednesday, August 20, 2003 3:14 PM
To: Michael S. Fischer
Cc: [EMAIL PROTECTED]
Subject: RE: Need help optimizing query, awfully slow on only
2 records
Result of EXPLAIN is:
table|type|possible_keys|key|key_len|ref|rows|Extra
inquiries|ALL|contact_id| | | |8253
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: Need help optimizing query, awfully slow on only
2 records
When following query is pulled up, it takes about whole 1-2
minutes to come up. inquiries table has 17000 records,
contacts has about 7000, individual_contacts has about
SELECT [field list] FROM archivetable,currenttable WHERE
archivetable.username=currenttable.username
notes: can use join,left,right,select inside select aka subselect check
the manual for detail
Regards,
--
Aftab Jahan Subedar
Software Engineer
Subedar Technologies
Subedar Baag
Bibir Bagicha
Hi,
On Fri, Aug 01, 2003 at 11:55:36PM +0800, Jaime Teng wrote:
Now, I have two of these tables (archivetable,currenttable).
My problem is how do I perform a single query such that I get
results from these two tables:
mysql select * from archivetable,currenttable;
* Jaime Teng
[...]
Now, I have two of these tables (archivetable,currenttable).
My problem is how do I perform a single query such that I get
results from these two tables:
mysql select * from archivetable,currenttable;
+++-+-+
At 15:15 -0500 7/18/03, Kyle Goetz wrote:
hey, i'm new to mySQL...this meaning that i have tried ~1 times to
install it and get it working over the past few weeks...and it always gives
me the same error (scroll further down to see it) despite following the
manual's windows installation exactly
At 17:42 -0500 7/6/03, Greg Donald wrote:
my coulmn (id) is an auto_increment coulmn and lets say that i have 100
entries, so the problem is that when i delete all entries on my table, the
column (id) starts from 101 ,shouldn't is starts from 1 again!
please i need help with this
Use truncate
At 4:20 -0500 7/7/03, Anthony Scism wrote:
I am relatively new at this, but is there any way to perform the
following:
| obs_date | date | YES | | NULL |
|
| obs_time | time | YES | | NULL |
|
| object | varchar(40) | YES | | NULL
Hi Antony,
Eventually key is a reserved word ?? ;-)
nice one !!
Best regards
Nils Valentin
Tokyo/Japan
2003 7 7 18:20Anthony Scism :
I am relatively new at this, but is there any way to perform the
following:
| obs_date | date | YES | | NULL |
|
| obs_time
:
Thank you very much, I should have thought of that.
-Original Message-
From: Nils Valentin [mailto:[EMAIL PROTECTED]
Sent: Monday, July 07, 2003 4:34 AM
To: Anthony Scism; [EMAIL PROTECTED]
Subject: Re: need help with select statement
Hi Antony,
Eventually key is a reserved word
You must create the key (sku), it is not created for you.
Tom Gazzini wrote:
I would appreciate some help with a problem. I'm trying to create two
tables that have referential integrity.
If I try and create the following table it works fine:
CREATE TABLE book
(
sku INT
) TYPE=INNODB;
However,
Please ignore my last email. I made a nauseatingly dumb error in the
book table (sku should be CHAR(14), not INT).
The only help I need is to get some sleep.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
my coulmn (id) is an auto_increment coulmn and lets say that i have 100
entries, so the problem is that when i delete all entries on my table, the
column (id) starts from 101 ,shouldn't is starts from 1 again!
please i need help with this
Use truncate table, it will reset the auto_incement.
Is there any way to seed a column set to autoincrement? Say I wanted it to
begin at 1.
- Original Message -
From: Greg Donald [EMAIL PROTECTED]
To: wael fareed [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Sunday, July 06, 2003 4:42 PM
Subject: Re: need help
my coulmn (id
Is there any way to seed a column set to autoincrement? Say I wanted it to
begin at 1.
alter table table_name auto_increment = 1;
--
Greg Donald
http://destiney.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
I got it to work, if anyone's interested (see message below). Here is the
SQL:
DROP TABLE IF EXISTS ProgramRoyalties;
CREATE TEMPORARY TABLE ProgramRoyalties
SELECT UtilityID, max(Royalty) as MaxRoyalty
FROM royalties
GROUP BY UtilityID;
SELECT u.UtilityID, u.UtilityIcon, u.UtilityName,
there. When I
upgraded to 4.0.12 I just moved the data folder from the old installation to
the new installation.
-Original Message-
From: Becoming Digital [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 12, 2003 1:53 AM
To: [EMAIL PROTECTED]
Subject: Re: Need help with an update
The OS upgrade
I have no idea. sorry.
Sibananda Sahoo wrote:
Thanks for your reply. Could you please tell me is it
possible to achieve foreign key constraint in MySQL
3.23.56.
Rgds,
Sibananda
--- Jeff Mathis [EMAIL PROTECTED] wrote:
i'm not an expert by any means :)
but, you do need indexes
]
Subject: Re: need help
I have no idea. sorry.
Sibananda Sahoo wrote:
Thanks for your reply. Could you please tell me is it
possible to achieve foreign key constraint in MySQL
3.23.56.
Rgds,
Sibananda
--- Jeff Mathis [EMAIL PROTECTED] wrote:
i'm not an expert by any means :)
but, you
The OS upgrade probably just over-wrote the old MySQL install. Hopefully it
left the files intact and you can import them as described in the manual.
FWIW, MySQL is at v4.0.13 and some major improvements came with v4. You might
want to consider reading the upgrade section of the manual, too. ;)
: Need Help About mysql.sock ERROR
You have several options, here is, I think, the easiest:
First you need to locate the sock file. The location depends on the
distribution (in my system is in /tmp). Use find / -name mysql.sock. On
some distributions the name can be slightly different, for example
i'm not an expert by any means :)
but, you do need indexes on both the primary key and the foreign key.
you've got one on foo_id, but you also need on on foo_value.
check the lists for more information. there's been plenty of discussion
lately ...
good luck
Sibananda Sahoo wrote:
Dear Sir
You have several options, here is, I think, the easiest:
First you need to locate the sock file. The location depends on the
distribution (in my system is in /tmp). Use find / -name mysql.sock. On
some distributions the name can be slightly different, for example
mysqld.sock.
Then create a
On Fri, Mar 28, 2003 at 06:10:55PM +0100, Vidar wrote:
Hi
I know that you may set max binlog size with the max_binlog_size
variable. However, is it possible to control the size of the
relay-bin logs on the slave servers as well?
I don't believe it's documented (yet?) but I seem to remember
On Friday 07 March 2003 00:43, Chris Montgomery wrote:
I have been using MS Access for 5+ years and am new to MySQL. I
understand the theory behind setting relationships between tables, but
am trying to get up to speed in how to do it in MySQL.
My environment: Win2k and MySQL 3.23.54
Howdy Egor,
Friday, March 7, 2003, 7:36:00 AM, Egor Egorov wrote:
Both columns Node are indexed, so just add foreign key constraint. You can
find examples in the InnoDB manual:
http://www.innodb.com/ibman.html#InnoDB_foreign_keys
I've looked at the examples, but one thing it doesn't
Disregard my previous msg. It looks like I have it figured out.
Friday, March 7, 2003, 5:31:38 PM, Chris Montgomery wrote:
I've looked at the examples, but one thing it doesn't mention is whether
both indexes need to be unique. In the primary table they are, but does
the index in the table
This should do what you want:
UPDATE Table2, Table1 SET
Table2.DataDestination=Table1.DataSource WHERE
Table1.col1=Table2.col1 AND Table1.col2=Table2.col2
AND Table1.col3=Table2.col3;
--- PandaCoop-Krasimir_Slaveykov [EMAIL PROTECTED]
wrote: Hello mysql,
I have 2 tables :
Table1:
On Thursday 20 February 2003 09:28, saravanan saravanan wrote:
I am using mysql for my project.I am finding
problems of using FOREIGN KEY and STORED procedures in
version 4.0.please help me and send the details as
earlier as possible
Stored Procedures are not supported in MySQL yet.
Veysel Harun Sahin wrote:
select vanNumber, sum(grossPay) from usertableDaily group by vanNumber;
The above is the correct query, to save yourself some time. As for your
problem:
But when I execute I get this:
Resource id#3
Resource id#4
This means you're using a resource
select vanNumber, sum(grossPay) from usertableDaily group by vanNumber;
[EMAIL PROTECTED] wrote:
hello,
I've performed searches on this site and php.net to try and figure out
why this is occuring. I can't find any instance in my searches that
helped me. So, I'm posting my very first question
Hi
Interesting problem, normally to get a total by type, you would have a query
like,
select van, sum(pay) from ($usertableDaily) group by van;
However you are individually quering each total, your approach is correct, but
slower.
The problem you have though is the return of
Resource
Are you referencing the result set correctly in php ?
How are you dealing with what MySQL returns ?
Looks like the info is there, you just not getting it out of the result
set.
-
Jerry @
MetalCat.Net
-
- Original Message -
From: Guru Geek
Lars,
if I understand you correctly:
create table table1
(
hotel_number int
);
create table table2
(
hotel_number int,
free_day datetime
);
insert into table1 values(1);
insert into table1 values(2);
insert into table1 values(3);
insert into table2 values(1,Jan 1 2003);
At 9:24 -0600 2/5/03, Jaime Teng wrote:
I have a MySQL table:
++--+--+-+-++
| Field | Type | Null | Key | Default | Extra |
++--+--+-+-++
| id
DISTINCT?
-Original Message-
From: Tab Alleman [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 05, 2003 12:31 PM
To: Jaime Teng; [EMAIL PROTECTED]
Subject: RE: need help with GROUP BY
SELECT id,account FROM tablename WHERE detail LIKE '%pattern%' GROUP BY
Account;
-Original
SELECT id,account FROM tablename WHERE detail LIKE '%pattern%' GROUP BY
Account;
-Original Message-
From: Jaime Teng [mailto:[EMAIL PROTECTED]]
I have a MySQL table:
...
It should only return *one* result per account.
Jaime,
You should be using the DISTINCT function.
SELECT DISTINCT account, id, FROM etc.
This should give you one instant of 'account' in your SELECT output.
At 09:24 AM 2/5/03 +, Jaime Teng wrote:
I have a MySQL table:
Jaime,
You should be using the DISTINCT function.
SELECT DISTINCT account, id, FROM etc.
This should give you one instant of 'account' in your SELECT output.
At 09:24 AM 2/5/03 +, Jaime Teng wrote:
I have a MySQL table:
* [EMAIL PROTECTED]
I've been a member of this mailing list for quite a long time and very
thankful that most of my difficulty in creating queries are being answered
by just reading responses to questions. Right now I have a problem in
creating a query (in fact I'm not sure if this is
On Wednesday 22 January 2003 12:10, Haydar KOCAK wrote:
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)
[1]+ Exit 1 ./bin/mysqld_safe --user=mysql
Check with
ps ax | grep mysqld
that MySQL server is running.
--
For
What does mysqld.log say?
Manuel Velasco wrote:
I'm getting the following messages after running
safe_mysqld (as root):
leo:/usr/bin # ./safe_mysqld
[1] 4798
leo:/usr/bin # Starting mysqld daemon with databases
from /var/lib/mysql
030121 19:38:15 mysqld ended
[1]+ Done
What version of MySQL are you using? UNION is implemented in MySQL 4.0.0.
Check out http://www.mysql.com/doc/en/UNION.html
for more information.
Victor Pendleton
-Original Message-
From: Garry Rothert [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 16, 2003 8:11 AM
To: [EMAIL
Garry,
You are using mysql version 4? Unions are only supported in version 4.
If so, the only difference I can see from your example to the manual is that
each select is in brackets in the manual. Try the query:
(select cnumber from spouse where fd_status = A)
union
(select cnumber from
Hello Dolly,
Kindly state and share with us the error encountered if there were any.
Your source code would also be of help :-)
Fred.
dolly wrote:
Hi,
I installed MySQL 4.0 on Red Hat 8.0 server and able to connect from
mysqlgui application. I couldn't connect from ODBC ver 2.50 nor 3.51.
Hi. I noticed a couple of weird things with your script:
- The error DBI-connect(myd) failed: Couldn't connect to... is
happening I think because 'DBI:mysqlPP:myd' is in single quotes when you
call DBI-connect, and the syntax seems off. Maybe you'll have better
success if you follow the syntax
I Installed succefully MySQL, but i want to have a graphical interface to
create a new databases and manage my existing database.
i readed in a asp-php.net (french web site)
http://www.asp-php.net/tutorial/asp-php/iis_et_mysql.php?page=1
the steps for installing phpmyadmin, you cas see the web
I guess your question is more about configuring IIS (or PWS) than about
MySQL.
Anyway, you have to create a web site in IIS pointing to your phpMyAdmin
directory and define in it the default document (index.html. default.php
or whatever)
Adolfo
-Original Message-
From: Rachid
I have been successful (after days of trying) with Apache 2.0.43 ,
PHP 4.2.3 on Redhat 7.3
I compiled php with ./configure --with-mysql --with-apxs2=/apth/to/apxs
(apxs is under /path/to/apache2/bin)
After 'make' and 'make install' you will find libphp4.so in
/path/to/apache2/modules
Then I
301 - 400 of 524 matches
Mail list logo