MySQL Database Forum

------=_NextPart_000_0013_01C352C0.6B0A6E30 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi All, Is it possible in MySQL to use UPDATE to update fields in one table = with data from another table? For example, the following code seems to be the answer but fails with a syntax error in MySQL:

Hi, i am really new to mysql so plz dont hit me if i am wrong. Here the problem: i have 2 tables. Voters(IP,Maprated) Maps(Name,Info)

Hi all, I have a table with the following data: +--------+-----------+----------------------------------+ | lpcval | smiles_id | crhash | +--------+-----------+----------------------------------+ | 0.81 | 996 | 0597b6f84e0feaf9596869284e6e0660 | | 0.86 | 996 | 53a88ef9f72a77eeb47da15969e6fbc0 |...

I have tried to install mysql 4.0.14 and previous version on my machine. After installation when I try to run mysql, i get error: "Cannot connect to localhost port..." my machine is not connected to internet. I also have firewall installed on my machine, but this should not matter. Any suggestions why I may be getting this error.

Hi, When installing the mysql4 binary it works fine. When installing the mysql max4 binary I get the following message when I try to run mysqld_safe. I am running linux redhat 9.1. Would anyone know why this is happening? 030728 23:54:57 mysqld started 030728 23:54:58 bdb: /usr/local/mysql/data/log.0000000001: Permission

I have tried to install mysql 4.0.14 and previous version on my machine. After installation when I try to run mysql, i get error: "Cannot connect to localhost port..." my machine is not connected to internet. I also have firewall installed on my machine, but this should not matter. Any suggestions why I may be getting this error.

Hi all, I have a table with the following data: +--------+-----------+----------------------------------+ | lpcval | smiles_id | crhash | +--------+-----------+----------------------------------+ | 0.81 | 996 | 0597b6f84e0feaf9596869284e6e0660 | | 0.86 | 996 | 53a88ef9f72a77eeb47da15969e6fbc0 |...

Hi all, i want to know if the system parameter somaxconn affect the capabalities of MySQL to maintain more than five thousands of HTTP connections ? If so , any clarifications may help. think in advance -- MySQL General Mailing List

Hi all, i want to know if the system parameter somaxconn affect the capabalities of MySQL to maintain more than five thousands of HTTP connections ? If so , any clarifications may help. think in advance -- MySQL General Mailing List

I need to do CHECK TABLE on a lot of tables (actually on all tables in several databases), and hoped to do something like mysql> CHECK TABLE reports.* which ddn't work. The only thing that seems to work is using cut'n'paste (or some scritpting) to get a comme seperated list. Is there really no "smart" way of doing this? version ...

I need to do CHECK TABLE on a lot of tables (actually on all tables in several databases), and hoped to do something like mysql> CHECK TABLE reports.* which ddn't work. The only thing that seems to work is using cut'n'paste (or some scritpting) to get a comme seperated list. Is there really no "smart" way of doing this? version ...

Hi List Me again. I'm trying to return from multiple tables, the records that have field "information_sent" between two dates. The tables are all related by means of the id of the entry in the main table, ie.. main id entity_name ...

Hi List Me again. I'm trying to return from multiple tables, the records that have field "information_sent" between two dates. The tables are all related by means of the id of the entry in the main table, ie.. main id entity_name ...

Hi I have a varchar field to search. There are 5k records. I'm using: WHERE name LIKE '%outer banks%' It seems to be very slow. I was reading about full text searches. Maybe I could do something like: WHERE MATCH ('name') AGAINST ('outer banks')

--=_104E0413.12733F99 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit I am running mysql 4.0.13 and using a weblog(Geeklog) to do my web. Using geeklog as been okay until I tried creating moderators to my forum and then I got the following error: 1064: You have an error in your SQL syntax. Check the manual that...

Hi I have a varchar field to search. There are 5k records. I'm using: WHERE name LIKE '%outer banks%' It seems to be very slow. I was reading about full text searches. Maybe I could do something like: WHERE MATCH ('name') AGAINST ('outer banks')

Hi, I would like to know if you could fix the bug I reported to you some days ago. The error is: "ERROR 1030: Got error 139 from table handler" after running an update command using several blobs. Now I am using mySql 4.0.15 and Linux. If you try to do the same with mySql 4.0.14, the record that is updated is simple deleted.

--=_104E0413.12733F99 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit I am running mysql 4.0.13 and using a weblog(Geeklog) to do my web. Using geeklog as been okay until I tried creating moderators to my forum and then I got the following error: 1064: You have an error in your SQL syntax. Check the manual that...

Hi, I would like to know if you could fix the bug I reported to you some days ago. The error is: "ERROR 1030: Got error 139 from table handler" after running an update command using several blobs. Now I am using mySql 4.0.15 and Linux. If you try to do the same with mySql 4.0.14, the record that is updated is simple deleted.

Hello! I have a 2xPIV Xeon box under RedHat 8 system and want to use mysql 4.0.14. How I should setting mysql for best perfomance ? -- Mr. Andrew L. Davydov

--0-213895535-1059473173=:22372 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit HI, is there a way to obtain only the affected columns after an update query? After an update query, that involves 10 columns, I know that only 2 columns are really updated (because the values of the other cols don't change). I...

Hello! I have a 2xPIV Xeon box under RedHat 8 system and want to use mysql 4.0.14. How I should setting mysql for best perfomance ? -- Mr. Andrew L. Davydov

Hi, I was wandering is there an easy way to rebuild indexs on tables I have the .frm and .MYD files. I read in the mysql manuals about backup_tables and Restore_table that rebuild the index but is there any other way to rebuild them. I'm using Mysql 3.23.53a

--0-213895535-1059473173=:22372 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit HI, is there a way to obtain only the affected columns after an update query? After an update query, that involves 10 columns, I know that only 2 columns are really updated (because the values of the other cols don't change). I...

HI, is there a way to obtain only the affected columns after an update query? After an update query, that involves 10 columns, I know that only 2 columns are really updated (because the values of the other cols don't change). I need to know the names of that changed cols, for logging purpose. Someone can help me? Thanks