test

sorry this is only a test. query MySQL -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL 3.23.54 + update

Hello dear all, i have 2 table :tbl1 and tbl2 i need to make an update on tbl1 based from tbl2 records. Ex: update tbl1, tbl2 set tbl1.conf='1' where tbl2.name='AD' and tbl2.date=tbl1.date; mysql: MySQL 3.23.54 i see this kind of query works on mysql 4.0.2 How i can do this with my

Re: alter date

On Tue, 5 Aug 2003 11:41:21 -0300 Fabio Bernardo [EMAIL PROTECTED] wrote: Hi there, Do you know a sql command which I can write to obtain the last date that I updated a table SHOW TABLE STATUS LIKE 'yourtable'; fabrizio -- MySQL General Mailing List For list archives:

possible query #2

Hello dear all, on MySQL 3.23.54 i have a table that list the number of user-time days like: 35 whellbased on curdate() function can i able to make a select wich display the sum (150-35) where 150 is date_format(curdate(), '%j') in a format like (%d/%m/%y) ? this kind of query is

possible query?

hello dear all, i need to make a select on mysql with IF funcion: if ('stop' 'start', stop, '+++') where start and stop are timestamps. and [+++] is an error char. Actually my select result are: +--++ | data | start | stop | +--+---++ | 20030301 |

Re: possible query?

Mikhail, Rich: it work! thanks again fabrizio -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysql replication

You have written the following: Hello dear all, i try to set-up replication, i've configurated master and slave, and on the slave-side i see this log: 030130 17:22:41 Slave: Failed reading log event, reconnecting to retry, log 'FIRST' position 35 030130 17:22:41 Slave: reconnected to

Re: updating tables

Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Fabrizio Tivano [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 23, 2003 5:22 PM Subject: updating tables hello dear all, i have a problem

updating tables

hello dear all, i have a problem updating tables: in my queries i try to use REPLACE but is same like INSERT command. ...i need only to refresh table_1 with new entries from table_2. any ideas? TIA fabrizio - Before

strange or impossible query?

Hello dear all, i have a table like this: field_machine, field_date, field_time, field_function. field_function can be =TT or +BT well i need to perform a select query, witch display on one line field_machine, (field_date, field_time where field_function =TT) AS start, (field_date,