o.k o.k ive thrown together this code Inwich DOES work but i have 4
Colombs i need to get this value for and then Sum the bstotals in a sum
right now i have this SAME routine
but just changing the name of (" btstotal ") to bstotal1 , bstotal2 ,
bstotal3
so my code in diffrent area's looks like
Jim
- Original Message -
From: "Jim Winstead" <[EMAIL PROTECTED]>
To: "Mike Blezien" <[EMAIL PROTECTED]>
Cc: "MySQL List"
Sent: Thursday, April 13, 2006 7:28 PM
Subject: Re: Download older versions
On Thu, Apr 13, 2006 at 07:13:55PM -0500, Mike Blezien wrote:
Hello,
I'm trying to
On Thu, Apr 13, 2006 at 07:13:55PM -0500, Mike Blezien wrote:
> Hello,
>
> I'm trying to locate the RPM downloads for MySQL version
> 4.0.26(4.0.26-pc-linux-gnu-i686), for a RH/7.3 system, but can't seem to
> find them. Doesn't MySQL site have older version archives where these older
> RPM's ca
Hello,
I'm trying to locate the RPM downloads for MySQL version
4.0.26(4.0.26-pc-linux-gnu-i686), for a RH/7.3 system, but can't seem to find
them. Doesn't MySQL site have older version archives where these older RPM's can
be downloaded ... if so, where would they be located ??
TIA,
Mike(mi
I don't think your code should work anyway, you should really check PHP
manual to get this work. mysql_query doesn't actually return the result, but
a resource id that can be used with mysql_fetch_xxx functions. Try this :
$link = mysql_connect("localhost","root","goobers") or die(mysql_error());
- Original Message -
From: "Brian E Boothe" <[EMAIL PROTECTED]>
To:
Sent: Friday, April 14, 2006 5:09 AM
Subject: arrg need help summing Colum's
why cant i get this to sum > ???
$link = mysql_connect("localhost","root","goobers") or
die(mysql_error());
why cant i get this to sum > ???
$link = mysql_connect("localhost","root","goobers") or
die(mysql_error());
mysql_select_db("workorder", $link);
$result = mysql_query("SELECT SUM(`ElecRem`) AS
total FROM orders", $link);
Hello
Does anyone know why a user would show up in a select from user query
but
not in a show grants command. What I am trying to say is I tried SHOW
GRANTS FOR 'user1'@'%' and received that there is no such grant defined for
'user1'... But when I run SELECT * FROM user WHERE User = 'user
At 12:51 AM 4/14/2006, Brian E Boothe wrote:
HI all ;
i wanna be able to sum a colum in a mysql database and display the sum
on the page field name <"Bondrem">
so if someone adds to the database the bondremaining colom would add
together and show the total on the page
record1 - ["bondrem"]=
Imran,
Thanks for your reply.
I tried what you asked, and it did the same.
I then went onto a couple of other boxes with EXACTLY the same MySQL install
and they worked (added the auto_increment).
The box that fails is running Redhat 7.3 (for customer backward
compatibilty). I dont have any other 7
[snip]
i wanna be able to sum a colum in a mysql database and display the sum
on the page field name <"Bondrem">
so if someone adds to the database the bondremaining colom would add
together and show the total on the page
record1 - ["bondrem"]=100
record2 - ["bondrem"]=450
total bondrem
Interesting. I have never heard of that option.
LX09:/home/rduz/backup # mysql -p -h. --port=3307
Enter password:
ERROR 2005 (HY000): Unknown MySQL server host '.' (1)
Perhaps it no longer functions?
Thanks.
Regards,
Rich
>
--
MySQL General Mailing List
For list archives: http://lists.mysq
hi chuck...
i don't use windows, but are you able to get a cmd window up/running, and
what happens if you type "mysql" in the dir where the mysql.exe resides? do
you also have this dir in your path?
-bruce
-Original Message-
From: Chuck Wildeman [mailto:[EMAIL PROTECTED]
Sent: Thursday,
You might want to look get the mysql admin tool. It will call the query
browser if needed (so don't get rid of that), but its what you use to
supervise the server (set up users etc.)>
Hope this helps.
Chuck Wildeman said:
> Hi,
>
>
>
> I am very new to mysql. In the past I was using Access. I d
--- "Duzenbury, Rich" <[EMAIL PROTECTED]> wrote:
>
>
> > -Original Message-
> > From: Barry [mailto:[EMAIL PROTECTED]
> > Sent: Thursday, April 13, 2006 9:41 AM
> > To: mysql@lists.mysql.com
> > Subject: Re: MySql Error Number 1130
> >
> > Duzenbury, Rich wrote:
> > >>localhost mean
Hi,
I am very new to mysql. In the past I was using Access. I don't have any
other experience setting up databases. I bought a book on MYSQL and
downloaded the installation file to one of our server and then installed it
using most of the defaults. I am now at my XP Pro laptop and want to a
HI all ;
i wanna be able to sum a colum in a mysql database and display the sum
on the page field name <"Bondrem">
so if someone adds to the database the bondremaining colom would add
together and show the total on the page
record1 - ["bondrem"]=100
record2 - ["bondrem"]=450
total bondr
Hi all,
I have two servers that have production data on them, and then one
server where I would like to keep an active copy of the data.
Currently, there is a job that runs in the middle of the night that
basically does a
mysqldump --host=production_server --all-databases | mysql
--host=backup
Going from 3 to 5 can break a number of important things. For example, join
syntax semantics and precedence rules have changed since 3, and it is
certainly possible this could break your code in important and dramatic
ways.
You should plan on spending time checking out all the SQL. Just as
i
In the second example you are enclosing field values
with ticks ` instead of single quotes '
You don't get any errors because you don't check for errors,
if you put :
echo mysql_error();
after mysql_query () you will see the error.
To solve this problem simple replace ticks enclosing values
Brian E Boothe wrote:
i have two php Forms to insert data into a Mysql 4.0.20d Database, one
is just a simple form to test if it works the other is the Actual
application,
here is the test form and works Perfectly
>>
NOW , / here is the Form data submitter that doesn't Work Iv
> -Original Message-
> From: Barry [mailto:[EMAIL PROTECTED]
> Sent: Thursday, April 13, 2006 9:41 AM
> To: mysql@lists.mysql.com
> Subject: Re: MySql Error Number 1130
>
> Duzenbury, Rich wrote:
> >>localhost means socket.
> >
> >
> > Hmm, I don't believe it does. localhost is a DN
i have two php Forms to insert data into a Mysql 4.0.20d Database, one
is just a simple form to test if it works the other is the Actual
application,
here is the test form and works Perfectly
>>
NOW , / here is the Form data submitter that doesn't Work Ive
checked and checked a
Hmmm, I have omited that :
I also have an index on (ip,type) in that order
"Barry" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Puiu Hrenciuc wrote:
>> Hi,
>>
>> I have a table ( MyISAM, MySQL 5.0.20, FreeBSD ) containing network
>> traffic data :
>>
>> record_time datetime -
Puiu Hrenciuc wrote:
Hi,
I have a table ( MyISAM, MySQL 5.0.20, FreeBSD ) containing network traffic
data :
record_time datetime - time when recording was added
ip char(15) - ip that generated the traffic
type tinyint(3) - traffic type ( 1 - local, 2 - internet )
inbound int(10) - in bytes
o
Hi,
I have a table ( MyISAM, MySQL 5.0.20, FreeBSD ) containing network traffic
data :
record_time datetime - time when recording was added
ip char(15) - ip that generated the traffic
type tinyint(3) - traffic type ( 1 - local, 2 - internet )
inbound int(10) - in bytes
outbound int(10) - out by
Duzenbury, Rich wrote:
localhost means socket.
Hmm, I don't believe it does. localhost is a DNS shortcut to the IP
address of the local machine.
If that is how mysql wants to treat things, then it should issue an
error message on connect because --host=localhost and --port=anything
would
> localhost means socket.
Hmm, I don't believe it does. localhost is a DNS shortcut to the IP
address of the local machine.
If that is how mysql wants to treat things, then it should issue an
error message on connect because --host=localhost and --port=anything
would then be mutually exclusive
Duzenbury, Rich wrote:
Wow, I found the problem! I think this may be a bug.
In my case, I've got three instances running on ports 3306, 3307, and
3320. On the local machine, I connect to them via
mysql -p --port-3306 --host=localhost
mysql -p --port-3307 --host=localhost
mysql -p --port-3
Wow, I found the problem! I think this may be a bug.
In my case, I've got three instances running on ports 3306, 3307, and
3320. On the local machine, I connect to them via
mysql -p --port-3306 --host=localhost
mysql -p --port-3307 --host=localhost
mysql -p --port-3320 --host=localhost
Excep
In MySql 5 you can write a filter function (plugin)
Santino
At 17:04 +1000 13-04-2006, Taco Fleur wrote:
Yes I have been thinking about the same, and already started collecting
search words, but its not really the direction I want to go in if I can
avoid it.
Kind regards,
Taco Fleur
Free Ca
At 11:56 +0200 13/4/06, Barry wrote:
Make a real downgradeable SQL Dump (without collations n stuff) and
have it saved.
Upgrade to MySQL 5.x and execute that sql dump.
Be warned that for example CONCAT behaves in a different way than in 3.x.
If you have PHP scripts with some functions in their
Hello,
I hope someone can help me with my problem. I want to join 2 tables. One
contains data about start and finish dates of a machine install, the
second table conatins data of install costs and a commencing date.
Table 1:
+-+++-+-+
| Machine
From: Mohammed Abdul Azeem Sent: 13 April 2006 07:29
>
> Hi
>
> Iam having a problem using "select into outfile" command, iam getting
> the following error. can anyone help me trace the problem.
>
> mysql> SELECT * INTO OUTFILE'/home/public1/data.txt' FROM temp_table
> WHERE last_time_update =
From: starmonkey Sent: 13 April 2006 01:51
>
> hey guys,
>
> A while ago I remembered using SQLYog or some other tool that could
> look at two databases (say dev and test versions) and work out the
> differences in structure between the two, and generate some SQL to
> 'upgrade' one to the
Chris Sansom wrote:
Our web host is currently running MySQL 3.23.something, but we're
shortly to be upgraded to MySQL 5.
Can I be sure that this is absolutely backwards compatible? Are there
any nastinesses lurking that I should know about that might cause my
databases to collapse in a heap?
Our web host is currently running MySQL 3.23.something, but we're
shortly to be upgraded to MySQL 5.
Can I be sure that this is absolutely backwards compatible? Are there
any nastinesses lurking that I should know about that might cause my
databases to collapse in a heap? My use of MySQL (as m
Quoting Mohammed Abdul Azeem ([EMAIL PROTECTED]):
> Then it hit a mysql bug with signal 6. The mysql db was throwing the
> following errors on the shell prompt ie the OS shell prompt.
I had exactly the same behaviour on MySQL 5.0.19 running on AMD64.
What helped in my case was re-creating all the
Hi,
I got confused looking to see if this was a known problem - so thought I'd
try again.
mysql_standard 4.1.16 on Linux...
Synopsis:
Create table with auto_increment
mysqldump database
output doesn't create table with auto_increment.
Example:
Create a table in a junk database using,
create
Hi,
Iam having a mysql version 5.0.15-standard-log installed on redhat es4.
It is configured as slave server. It was running fine till yesterday.
Then it hit a mysql bug with signal 6. The mysql db was throwing the
following errors on the shell prompt ie the OS shell prompt.
*** glibc detected **
If you are not rebuilding the FULLTEXT indexes, then that
is probably why the change to the ft_min_word_len is not
being recognised.
It seems like mysql uses this value to set the index it
builds for the FULLTEXT search.
I don't know how to rebuild this index.
You may need to delete your .MYI
What about letting the user make the right choice in the
first place?
Like when you use Google, you only get what results from
what you type into standard Google.
Keith
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMA
Do you have any idexes on the table?
What does your
mysql> show create table tbl_name \G
statement look like please?
Keith
In theory, theory and practice are the same;
in practice they are not.
On Thu, 13 Apr 2006, Luke Vanderfluit wrote:
> To: mysql@lists.mysql.com
> From: Luke Vanderfluit
Yes I have been thinking about the same, and already started collecting
search words, but its not really the direction I want to go in if I can
avoid it.
Kind regards,
Taco Fleur
Free Call 1800 032 982 or Mobile 0421 851 786
Pacific Fox http://www.pacificfox.com.au an industry leader with c
Not being an expert on FULLTEXT functions yet, I suppose you
could hard code some type of search function into your
application code, then create all the relevant search
options for the FULLTEXT query in your app logic, then post
the FULLTEXT query off to mysql.
Or store the different search o
45 matches
Mail list logo
