MySQL Database Forum

hello, i have what seems to me a very common operation i'm performing. i need to find the balance on an invoice. i was not having any problems until the production server was upgraded to mysql v4.0.13-standard for pc-linux. there must be a better way to query for this information than the method i'm using, since the result with v4.0 is...

I have 2 tables t and t1. In this case, t1 is a copy of t. I want to delete rows from t1 based on criteria on the t table and a relationship between t ad t1 (in this case the id column). In the results below, I would think that the delete should have deleted row 1 {1 5 me) and not row 3 (1 5 they) when I run this statement delete t1...

Hi, Not sure if the problem here is PHP or MySQL, but here we go. I am trying to do two queries on a database - one after the other, but the second one never seems to get executed. The two queries are identical except for two variables. I have checked my form and they are correct and are being sent to the PHP script the way they should be....

-----Original Message----- From: Moritz Steiner =20 Sent: Wednesday, July 16, 2003 10:46 AM To: Jay Blanchard Subject: AW: monitoring I want to see: Number of queries =20

Hello: I have 2 tables t1: id age 1 7 2 6 3 7 4 8 5 9 6 4

------=_NextPart_000_0001_01C34BC2.26B3C4C0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Wy can't I start the service in windows 2003 server have any one a solusion? Pleas help

------_=_NextPart_001_01C34BAF.37722FA5 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable =20 How are you monitoring on your databases? Who has a good solution? =20 Moritz =20

------=_NextPart_000_000D_01C34B95.4BFBA860 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi Everybody I have acidentally deleted an index file (.MYI) from a table. Is there = another way, besides its backup, to recover this table ?

I'm having some trouble updating a mysql database with a perl cgi. Here's the perl: $sql = "UPDATE grants SET agency2 = \"$agency2\" WHERE agency2 = \"$key\""; $rv = do($sql) or die "Can't execute $sql: $dbh->errstr\n<br>"; Here's the error returned in the browser:

Try this instead: SELECT pubishers.pub_id, titles.pub_ID FROM pubishers JOIN titles ON pubishers.pub_id = titles.pub_id HTH. ** For great Emap magazine subscription & gift offers visit http://www.emapmagazines.co.uk **

I have 2 tables with the following fields : table : publisher field1: pub_id - Primary, int, auto table : titles field1: title_id - Primary, int, auto field1: pub_id - int Using sqlyog I noticed that the indexes had already been created for the

--0-1370207171-1058366654=:75594 Content-Type: text/plain; charset=us-ascii Good morning all, I have a problem with inceasing connection to my database that eventually result in connections being rejected. I know I have an application that is terminating a thread without closing the database handle. Problem is I'm waiting for the fix on...

I have 2 tables with the following fields : table : publisher field1: pub_id - Primary, int, auto table : titles field1: title_id - Primary, int, auto field1: pub_id - int Using sqlyog I noticed that the indexes had already been created for the

Hi, I installed MySql with the installation of RH 7.1 The daemon is running, /etc/init.d/mysql start. I am unable to find the path to mysql to so I can use the command line. I installed the MySql GUI and it works fine. My concern is when this box goes to its permanent location I won't be able to work with MySQL. I will ssh into the box from...

------=_NextPart_000_000E_01C34B89.9A9A1DA0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi List I got an "no space left on device" error. Is there a way to drop an index without having MySQL create a temporary =

------_=_NextPart_001_01C34B9E.A3ABD810 Content-Type: text/plain; charset="windows-1256" Content-Transfer-Encoding: quoted-printable I have noticed that mySQL Control Center (beta 092), will only return = back 1000 rows=20 whenever I doubleclick on a table that I know contains an amount =

Ok, but this only works for the current session, if I close and restart = the client the settings are reset... -----Urspr=FCngliche Nachricht----- Von: Victoria Reznichenko =20 Gesendet: Mittwoch, 16. Juli 2003 11:19 An: mysql@lists.mysql.com Betreff: Re: switch query logging while the server is running

Hi, I have installed MySQL on Windows98se twice under different paths, and then deleted the second installation. When i run MySQL as usual using the line "C:\Program Files\nusphere\mysql\bin\mysqld-opt.exe" , i get the following error msg: C:\Program Files\nusphere\mysql\bin\mysqld-opt.exe: Fatal error: Can't find messagefile 'C:\Program...

Hi, If I insert data that contains spanish characters to my database (MySQL 3.23.56 on Slackware 9), it doesn't get stored correctly. For example, if I insert "maricón", MySQL stores it as "maric??n". I am new to MySQL, so any information (doesn't matter how basic it is) will be appreciated. Thanks.

While accessing MySQl data base by means of perl the value of variable $! sometimes equals " Resource temporarily unavailable". At the mean time everything works correct. What does that mean? _______________________________________________________________ http://chat.bigmir.net/ - ñàìûé óäîáíûé ÷àò ñ ôîòîàëüáîìàìè -- MySQL General Mailing...

I'm trying to build mysql from the development sources of mysql 4.1., retreived using bitkeeper under win2k using cygwin. I have made "bk -r edit", and now I'm having a problem running aclocal: aclocal: configure.in: 450: macro `AM_PROG_AS' not found in library When I make "automake --version" and "aclocal --version" it prints me...

--=====================_11749194==_.ALT Content-Type: text/plain; charset="us-ascii"; format=flowed I am new in mysql.... I wrote this query: INSERT INTO testo (id_lingua, id_categoria, id_campo, riga, sezione, ordine, codice) VALUES (10 ,6 ,5 ,"10 - 99:" ,12 ,50 ,'S12IT3' ) and server reply to me:

Dear my friends... I am trying to develop a database application with PHP Version 4.3.2, MS Window 2000, MySQL 4.0.13-nt and Apache 2. I tried to insert a record onto my MySQL but I got this error messages. What do I have to defined to overcome this problem? "

Hi there, i am half way through a project and looking at using sub-selects, which is only available in ver 4.1.0 alpha. I was just wondering if anyone new when the gamma version whas scheduled for release. As you can understand i dont want develop around a product that isnt in at least the Gamma stage by the time i have to go live Regards...

Hi Everybody, 1- I am trying to upsize an access database to my MySQL server on my website. I tried to get connected within access and failed. Please advise. I am using Win XP as the operating system and MS Office XP Pro. 2- How to connect a Visual Studio.NET project to a MySQL data base located on a MySQL server on a web. I tried to...