R: delete a data from 3 tables

Hi Chandra, you have two possible situations: Case (A) you can delete 'astro_tbl' rows with NO particular actions Case (B1) you must alter 'astro_tbl' table adding a cascade costraint to have the system delete rows in the 'astro_tbl' table when one row in 'authen_tbl' table is being deleted if

R: delete a data from 3 tables

I think the best way is to modify the FOREIGN KEY definition in the tables 1 and 2 adding the 'ON DELETE CASCADE' condition. ALTER TABLE 1 ADD FOREIGN KEY (fkCol) references 2(pkCol) on DELETE CASCADE; ALTER TABLE 2 ADD FOREIGN KEY (fkCol) references 3(pkCol) on DELETE CASCADE; Aloha! Claudi

R: Starting a 2nd MySQL instance on UNIX

Hello, I faced this issues a few years ago and I'd like to give my contributions. The easy and clean way I've found: -- <--> One installation for each mysql instance <--> On each instance you can have as many databases as you wa

R: R: Re: FW: Re: what is a schema? what is a database?

999 standard is the term database defined." And from the rapid look I gave at the SQL:1999 standard he is right. Claudio Nanni Da: Moon's Father [mailto:[EMAIL PROTECTED] Inviato: lunedì 7 aprile 2008 10.24 A: Nanni Claudio Cc: Thufir; mys

R: calculating breaks for an employee

Hi Thufir, I know I am late! And you'll have already resolved. But I haven't been receiving mysql mailing list posts since november for our company server misteries! Every date can be converted to an absolute number-of-seconds number (for instance with time_to_sec() function), so you can subtract

R: R: R: Multiple instances howto

start only > ONE mysql instance from the same installation, why am I able to log in 2 > different instances? Where did I do wrong? > > Thanks, > Jing Zhang > > > > > Nanni Claudio wrote: >> >> Jing, >> >> First: you can have only ONE

R: Connections on Database

Hi Velen, you have to put this parameter in the [mysqld] section of .my.cnf file: max_connections = n # n is the number of connections desired don't forget to restart mysql! Aloha! Claudio Nanni -Messaggio originale- Da: Velen [mailto:[EMAIL PROTECTED] Inviato: domenica 30 mar

R: R: Multiple instances howto

oes it means I have two instances running? If I want to configure them seperately using mysql command, what shall I do to distinguish each instances? Thanks, Jing Zhang Nanni Claudio wrote: > > Hi Jing, > > Logically speaking, > you can run as many instances of mysql as you want, >

R: Re: FW: Re: what is a schema? what is a database?

I know I am a little late. From my experience with Oracle Database: ORACLE MYSQL(equivalent) --- DATABASEMYSQL INSTALLATION SCHEMA DATABASE So in Oracle a Database is an instance running on an Oracle

R: Multiple instances howto

Hi Jing, Logically speaking, you can run as many instances of mysql as you want, but you have to make an installation for each mysql instance. On each instance you can have as many databases as you want. From my experience here is the key: 1) One different mysql user (mysql41,mysql50) for each my

R: version mimatch

First, I don't know if there is a way to make binlogs compatible, it seems SQL syntax incompatibility. You should look for single errors and correct it by hand or, if your target is to import data from a MySQL 4.x server to a MySQL 3.x server you could import the binlogs into a MySQL 4.x server, d

R: SqlState error code 42S22 driving me insane

Hi Mike, could you please be more precise? What platform, language, versions are you using for the client application? What o.s. and version are you using for mysql server? Which is the code giving you problems? The more information you give, the easier is to answer. Aloha! Claudio Nanni ---

R: Migrate HUGE Database

Hi Terry, you should try using mysql command line tools. Aloha! Claudio Nanni -Messaggio originale- Da: Terry Babbey [mailto:[EMAIL PROTECTED] Inviato: lunedì 10 marzo 2008 19.30 A: mysql@lists.mysql.com Oggetto: Migrate HUGE Database Hello, I have a huge database that I would like t

R: Comma's in data?

Hi Jason, Commas are not special characters inside a varchar type of a mysql table. What you have to watch is not to break strings. That usually happens when you use the same type of quotes ,as a value of the string, of the ones used to enclose the string itself. For instance: insert into Emplo

R: Im being dumb!

Hi Roger, That is ok, just try to substitute 'INNER' with 'LEFT' Aloha! Claudio Nanni -Messaggio originale- Da: roger.maynard [mailto:[EMAIL PROTECTED] Inviato: giovedì 6 marzo 2008 14.33 A: mysql@lists.mysql.com Oggetto: Im being dumb! I got 4 tables: Table A | ID | Description

R: Column level replication q?

Of course I am talking about a materialized view, did you try? Here some useful links: http://forums.mysql.com/read.php?100,21746,21746#msg-21746 and from the reply in the same forum topic by Waheed Noor 09/10/2007 01:39PM you get this link: http://www.shinguz.ch/MySQL/mysql_mv.html

R: Column level replication q?

Hi Gary, Did you try with a view with only the public fields of your table? Aloha! Claudio -Messaggio originale- Da: Gary W. Smith [mailto:[EMAIL PROTECTED] Inviato: mercoledì 20 febbraio 2008 1.18 A: mysql@lists.mysql.com Oggetto: Column level replication q? We need to replicate a tab

R: rename database in 4.1

You can try to dump-to-sql the whole DB, Create a new DB and import the sql-dump in the new DB. Aloha! Claudio -Messaggio originale- Da: Thomas Raso [mailto:[EMAIL PROTECTED] Inviato: martedì 12 febbraio 2008 17.20 A: mysql@lists.mysql.com Oggetto: rename database in 4.1 hi list, how

R: full text search on multiple tables

As Sebastian Mendel wrote: you can use a union, you can mask the fact you are dealing with fields coming from three different tables renaming the fields of interest (the fields on which you make the search) with the same name. Something like this should works, it does with me: SELECT "I'M A BOOK