Dear,
I am stuck on something,
I would like to summarize multiple columns to a total value in a query and
then display the output with php in a table.
the summarize works for 1 column but not for two or more.
any suggestions ?
Thanks alot
Why does
SELECT SUM(column1 + column2 + column3) AS combined FROM table
not work for you? The php echo is no different from any other data... your column name
is combined
if you fetch_array or fetch_assoc.
Please post more information if this does not accomplish what you require.
Cheers,
#
Dear Alainq,
I am stuck on something,
I would like to summarize multiple columns to a total value in a query
and
then display the output with php in a table.
the summarize works for 1 column but not for two or more.
any suggestions ?
So is what you are doing something like?
(would it help
Hi,
Download the binary distribution that suits your system and read the
INSTALL-BINARY file.
Also, make sure the online documentation at
http://www.mysql.com/documentation/index.html
Regards,
Jorge
For technical support contracts, visit https://order.mysql.com/
__ ___ ___ __
What is the command prompt to create a user in mysql?
Thank you,
Josiah Wallingford
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
Hello everyone,
This is my first attempt at MySQL database replication. Can't seem to get
it to work yet. The problem reported in the error log of the slave server
is as follows:
Error reading packet from server: Access denied for user 'repl@slave_host'
(Using password: YES) (read_errno
Not to be sarcastic, but Pointing us all to ducumentation I HAVE READ 100
TIMES is NO help. I have read this file, I have used the appropriate
.tar.gz, I have reinstalled, I have used the most current RPM's
How about contributing something USEFUL, like a REAL answer, that anyone can
follow. No
No need to get all snarky. People are confused because there's a whole
section in the manual that covers the installation, step-by-step, with no
cryptic mumbo jumbo. This is at
http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.html#Linux-RPM
and basically tells you to
I have been going out of 'my' mind. I am trying to install mysql on a
Macintosh OS X server. Can anyone give me instructions on how to do
this? I have been to numerous sites with no luck. We run OS 10.1.2
server, I have mySQL 3.23.49 running (from entropy). During the install I
had to
Mark,
This probably won't get you the response you wanted. How about letting
us know where you have gotten to and where things seem to be breaking. A
generalized request for what do I do often recieves little or no help.
Some basic system information would also be much appreciated; what
Leif,
I'm not sure what you mean by tbl2's population is a sub-set of that
in tbl1. tbl1 contains user id nums and hours each user spent
working on a
project. tbl2 contains user id nums and the first and last names that
correspond to each user id. There are user id nums in tbl1 that do
Thi Cao wrote:
Hello everyone,
This is my first attempt at MySQL database replication. Can't seem to get
it to work yet. The problem reported in the error log of the slave server
is as follows:
Error reading packet from server: Access denied for user 'repl@slave_host'
(Using
Josiah,
What is the command prompt to create a user in mysql?
GRANT privileges ... TO user_name IDENTIFIED BY 'password'
Manual: 4.3.1 GRANT and REVOKE Syntax
Regards,
=dn
-
Before posting, please check:
Try this like, http://www.entropy.ch/software/macosx/ , they're great
instructions and binaries.
Michael
On Tuesday, March 5, 2002, at 06:38 PM, Ray Hughes wrote:
I have been going out of 'my' mind. I am trying to install mysql on
a Macintosh OS X server. Can anyone give me
Hi again
I'm Working with PB 8.01 , mysql odbc 3.51 driver, Mysql 4.01 alpha-max-nt ,
OS Platform:w2k service pack2, using INNODB table type
I design a Datawindow using 2 retrieval arguments, in my preview seem to
works fine...but when I run my application it doesn't retrieve any data...
Dr. Michael Wittmann [EMAIL PROTECTED] writes:
one solution could be to install a more recent compiler version and try
to recompile again. be aware that actual rpm's will be created by rpm
version 4, whereas redhat 6.2 has rpm version 3 installed which possibly
cannot handle version-4-rpm's
I was the one having issues getting Lost Connection and whatnot for no
reason.
I have recompiled under glibc2.2.5 with 2.95 and 3.04.
I just tried 4.0.2 from the source tree.
Sometimes from the command line of doing mysql -uroot -p I get this:
ERROR:
And that's it.
I run it again, and it
Ok.
SuSE 7.3
Digital HiNote VP745
mysql Ver 11.17 Distrib 3.23.49a for pc-linux-gnu
Prior to completely reinstalling my SuSE system, I was running mysql 3.23.47
for SuSE
I have installed the .tar.gz and followed those instructions
I have installed the RPM's using the -i, and also installed
On Tue, 5 Mar 2002, Intrex wrote:
Ok.
SuSE 7.3
Digital HiNote VP745
mysql Ver 11.17 Distrib 3.23.49a for pc-linux-gnu
Prior to completely reinstalling my SuSE system, I was running mysql 3.23.47
for SuSE
I have installed the .tar.gz and followed those instructions
I have
I do have a mysql user, and have used the commands to assigne rights for the
mysql user per the instructions. I have no hostname.err, only linux.err
which displays the exact same errors I typed out.
Mark
- Original Message -
From: James Montebello [EMAIL PROTECTED]
To: Intrex [EMAIL
(Using mysql 3.23.38 - commercial version)
I have a table that has two indexes: one on just creationTime
(iv_alert_creation_ix), and one on (state, creationTime) (iv_alert_state_ix).
When I issue this query:
explain select uuid from iv_alert
where state = 1
and creationTime =
Hi,
On Wed, 2002-03-06 at 11:12, Shankar Unni wrote:
(Using mysql 3.23.38 - commercial version)
I have a table that has two indexes: one on just creationTime
(iv_alert_creation_ix), and one on (state, creationTime) (iv_alert_state_ix).
When I issue this query:
explain select uuid
Hi,
On Tue, 2002-03-05 at 23:55, Petre Agenbag wrote:
I have recently had some problems with web forms not updating the
website ( use PHP and the insert page should first enter the form data
into a table and then update the status field in a second table
correlating to the entry just
Steven Roussey wrote:
Any way to hint a particular index for a query?
From the manual (http://www.mysql.com/doc/J/O/JOIN.html)
Thanks. I missed that. Unfortunately, as I was afraid, this is a very
MySQL-specific way of doing it. But then, hints always are DB-specific, so
that's not too
Hi.
This is a known bug and IIRC fixed by 3.23.49a. Try that and report
back, if you still have problems.
Regards,
Benjamin.
On Tue, Mar 05, 2002 at 01:22:34PM -0800, [EMAIL PROTECTED] wrote:
I have a several Redhat machines with MySQL 3.23.* installed on it.
When I upgrade any of
Hi,
Below is the content of my my.cnf file.
I would like to get the optimum performance from MySQL and would
like to modify some of the values.
Specifically, my W2K Machine has 192MB of ram, what should I
have in order for MySQL to take advanatge of that 192MB memory
and what effect does it
DLN,
Thanks. Interestingly enough, pulling records without a sort was rather
random (rather, influence by the last sort) - but once I placed a primary
key on the table, the order of unsorted records is always constant, even
after a sort (based on numerous tests yesterday and today with the
I wrote:
Didn't see anything on this specific question in a quick search of the
database. If I just missed it, I apologize.
Okay, okay, RTWM.
What I have in mind is being able to read the Japanese error messages on
an
MSWindows box.
So I wanted to make a mysql\share\japanese_sjis
Jeremy,
Mytop is simply awesome. Thanks!
I recently updated to 0.9. I have a request: how about the qps mode show
total qps as well as breaking them out (selects, inserts, updates,
deletes, and other) as is possible with the Com_ status variable in
the later versions of MySQL (no
Hi Richard,
On Wed, 2002-03-06 at 13:02, Richard S. Huntrods wrote:
Interestingly enough, pulling records without a sort was rather
random (rather, influence by the last sort) - but once I placed a primary
key on the table, the order of unsorted records is always constant, even
after a sort
Hi,
Select Sum(ifnull(column1,0)+ifnull(column2,0)+
...+ifnull(columnn,0)) From tbl group by ..
Anvar.
At 11:34 PM 05/03/2002 +0100, you wrote:
Dear,
I am stuck on something,
I would like to summarize multiple columns to a total value in a query and
then display the output with php in a
PMFJI, but has anyone done any testing to see if persistent
connections with MySQL and PHP is actually faster in practice?
Without testing, I suspect that it is faster but that the gains are
very small. If this was Oracle, it'd be a whole different story. The
connection
At 19:10 05/03/2002 +0100, Othmar Stehlik wrote:
Hi!
Hi
I installed MySql on Win2k and everything worked fine, than I also installed
Oracel, mysql refused to work, than I deinstalled Oracle and did a new mysql
setup.
But when I try to start mysql, with mysql\binmysql
mysql.exe is the client
Hi
What I want to do is import data from some other
database to Mysql. For this the requirement is that,
each record before being added to Mysql database,
should pass through a loop say 5 times. This I want to
do using only SQL. I do not want ot use Java or any
other language. Any idea as to how
Hi,
I'm a newie to SQL, and to Linux, so please forgive my blaring blunders...
I know I have an x86 Linux machine, running Redhat 7.2, and I know that I
like RPMs better than binary installations
When I get to the Stable Version/Linux/RPMs download area, the following
options are
On Tue, Mar 05, 2002 at 05:30:31PM -0800, Steven Roussey wrote:
Jeremy,
Mytop is simply awesome. Thanks!
Thanks, glad ya like it.
I recently updated to 0.9. I have a request: how about the qps mode show
total qps as well as breaking them out (selects, inserts, updates,
deletes, and
hi
Does Mysql support Transat SQL???
Amit
__
Do You Yahoo!?
Try FREE Yahoo! Mail - the world's greatest free email!
http://mail.yahoo.com/
-
Before posting, please check:
Hi,
I run SuSe 7.2 and have upgraded to the current suse versions of
mysql.
Server version 3.23.41-Max-log
Protocol version10
Connection linux.lisse.na via TCP/IP
TCP port3306
I have added mysqld and mysqld-max to the /etc/hosts.allow and can
On Tue, Mar 05, 2002 at 09:15:59PM -0800, Amit Lonkar wrote:
hi
Does Mysql support Transat SQL???
Nope.
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
MySQL 3.23.47-max: up 26 days, processed
You can do what you asked for by making a temporary table, as follows.
create temporary table T (this varchar(..), that varchar(..));
insert into T select tbl1.this, no record from tbl1 left join tbl2 on
tbl1.id = tbl2.id where tbl2.id is null;
insert into T select tbl1.this, tbl2.that from
Any way to hint a particular index for a query?
From the manual (http://www.mysql.com/doc/J/O/JOIN.html)
As of MySQL Version 3.23.12, you can give hints about which index MySQL
should use when retrieving information from a table. This is useful if
EXPLAIN shows that MySQL is using the wrong
When I execute mysqld -u root -p password
I am presented with the default variables.
The manual says to use safe_mysqld to properly start mysqld. Also,
--user=root is clearer for that option. And, what are you doing with -p
password in starting the daemon? This is not an option, it is an
Hi,
Sorry, it didn´t help.
create table tPruefBesch (fTimestamp timestamp(14), fPruefbeschNr int
auto_increment not null, fPlanNr int, primary key (fPruefbeschNr));
mysql explain tPruefBesch;
+--+--+---+---++--+
|
Hi,
I have a requirement of storing and retrieving data in 2 languages - namely English
and Arabic.
From what I have been able to understand, that would require me to have 2 MySQL
servers running simultaneously.
Can somebody please tel me : 1)if there are any other better ways 2) if this is
101 - 144 of 144 matches
Mail list logo