If I understand you correctly Basically you want to convert this query
output:
+---+---+---+
|A.value|B.value|C.value|
+---+---+---+
| a1 | b1 | c1 |
| a1 | b1 | c2 |
| a2 | b1 | c3 |
| a2 | b1 | c4 |
| a1 | b2 | c5 |
| a1 |
SELECT * FROM TABLE
if( mysql_num_rows() == 0) table is empty
HTH
Peter
-Original Message-
From: D. K. [mailto:[EMAIL PROTECTED]
Sent: 29 July 2003 08:12
To: [EMAIL PROTECTED]
Subject: no subject
Hello List;
I am developing a php-mysql application for my term project at school and
At 9:27 +0100 7/29/03, Peter Lovatt wrote:
SELECT * FROM TABLE
That will perform a complete table scan and transfer the entire
contents of the table over the network. Much better to run
SELECT COUNT(*) FROM tbl_name
Which will be very quick (for MyISAM tables, at least), and in all
cases will
I just had the same exact error two days ago.
td checking for termcap functions library... checking for tgetent in
-lncurses... no
td checking for tgetent in -lcurses... no
td checking for tgetent in -ltermcap... no
td configure: error: No curses/termcap library found
BWhen you installed your
On Monday 08 April 2002 9:49 am, Chuck \PUP\ Payne wrote:
Ok, I know I am going to get yell about this but how can I do an SQL and
only show to fields from a table. For example I only like to see the names
and birthday? Or will as so all fields for a given table.
SELECT field1, field2 FROM
Chuck,
Monday, April 08, 2002, 6:49:20 PM, you wrote:
CPP Ok, I know I am going to get yell about this but how can I do an SQL and
CPP only show to fields from a table. For example I only like to see the names
CPP and birthday? Or will as so all fields for a given table.
If you want to see data
SELECT name,birthday FROM mytable
-Original Message-
From: Chuck PUP Payne [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 08, 2002 10:49 AM
To: MySQL Mailing List (E-mail)
Subject: no subject
Ok, I know I am going to get yell about this but how can I do an SQL and
only show to fields
select name, birthday from ??? order by name;
Along those lines anyway.
Chuck \PUP\ Payne wrote:
*
This Message Was Virus Checked With : SAVI 3.54 Feb 2002
Last Updated 25th March 2002
Thanks, I got it :) I am using phpMySQL and command line and I couldn't see
anything because it was showing everything but now I am cool. Again everyone
thanks.
Chuck Payne
On 4/8/02 12:03 PM, Rick Emery [EMAIL PROTECTED] wrote:
SELECT name,birthday FROM mytable
-Original Message-
I am not sure it that would provide everything you want to know, but I was
looking for the same thing last week and I setup this replication database
and it work great and make it very easy.
http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Adm
inistration.html#Replication
At 20:31 13-4-01 +, [EMAIL PROTECTED] wrote:
Hi,
Can i make a user friendly interface for Sales people to make a
contact to my data base on mysql running on my linux server.
PHP, Perl also seen message from people who use VB and ODBC to connect to
MySQL. Take a look at this lists
On Fri, 13 Apr 2001 [EMAIL PROTECTED] wrote:
Hi,
Can i make a user friendly interface for Sales people to make a
contact to my data base on mysql running on my linux server.
Sure.
--
/"\
\ /ASCII RIBBON CAMPAIGN
X AGAINST HTML EMAIL
/ \AND POSTINGS
You sure can. How is left as an exercise for the reader. Read up on HTML,
Perl, and DBI. That should get you started.
j- k-
On Friday 13 April 2001 12:31, [EMAIL PROTECTED] wrote:
Hi,
Can i make a user friendly interface for Sales people to make a contact
to my data base on
[EMAIL PROTECTED] wrote:
Can i make a user friendly interface for Sales people to make a contact
to my data base on mysql running on my linux server.
Your question is pretty vague. You'll probably want to investigate a web
scripting language such as PHP or Perl, which can interact with MySQL
14 matches
Mail list logo