Problem with WHERE .. IN

| +--+ |5 | |7 | | 11 | +--+ Please tell me, where is wrong Thanks & Regards -- Muhammad Subair +62 8176583311

Re: DELETE CASCADE

n cfg_tags with 'mycluster' are deleted. Should I then > remove the "delete cascade" condition and take care of this myself? > > > Thanks > Aveek > how data 'mycluster' can duplicate, while he is the primary key in cfg_tags? -- Muhammad Subair

Re: ssl questions

Hi, Maybe, first you can check MySQL documentation [0], [1] [0] http://dev.mysql.com/doc/refman/5.0/en/secure-using-ssl.html [1] http://dev.mysql.com/doc/refman/5.0/en/secure-basics.html -- Muhammad Subair On Thu, Oct 8, 2009 at 6:03 PM, Tompkins Neil wrote: > Hi > > I wondered ho

Re: REstricting MySQL access to port 3306

http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=john.dais...@butterflysystems.co.uk > > No virus found in this incoming message. > Checked by AVG - www.avg.com > Version: 8.5.409 / Virus Database: 270.13.112/2390 - Release Date: 09/23/09 > 05:52:00 > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql?unsub=msub...@gmail.com > > -- Muhammad Subair

Re: MySQL DB Server - 5.1

ad.php?t=1039946&highlight=mysql+5.1>But I do not like to do so, since this a 3rd party. * The repository mention in number three is; deb http://packages.dotdeb.org stable all deb-src http://packages.dotdeb.org stable all [0] http://ubuntuforums.org/showthread.php?t=1166560 -- Muhammad Subair

Re: 1 Machine with 4 GB RAM for Big Size MySQL Data Size

September 2009 05:16 > To: mysql@lists.mysql.com > Subject: Re: 1 Machine with 4 GB RAM for Big Size MySQL Data Size > > On Friday 04 September 2009 08:15:35 pm muhammad subair wrote: > > On Sat, Sep 5, 2009 at 5:10 AM, mos wrote: > > > At 11:48 AM 9/4/2009, you

Re: 1 Machine with 4 GB RAM for Big Size MySQL Data Size

t; spent on implementation and future maintenance is not too large for use >> MySQL with this condition? >> >> *btw sorry for my English* >> >> Thanks you very much, >> -- >> Muhammad Subair >> > > Muhammad, > It will depend on your querie

1 Machine with 4 GB RAM for Big Size MySQL Data Size

ions and the number of users concurent is under 10. I need information and suggestion about this condition, whether the effort spent on implementation and future maintenance is not too large for use MySQL with this condition? *btw sorry for my English* Thanks you very much, -- Muhammad Subair

Re: Mysql update query gives error of lock wait timeout

ock only the row which used in transaction. *cmiiw* -- Muhammad Subair

Re: Innodb + Large data set

re with 4 GB of RAM. Surely it shouldn't have a *huge* effect? > > Sincerely, > Suhail Doshi > Maybe this article will help give you some idea; http://www.mysqlperformanceblog.com/2006/06/09/why-mysql-could-be-slow-with-large-tables/ -- Muhammad Subair

Re: Natural Join Issue: column names are equal but doesn't work anyways

2495','2002-09-04','256'); > insert into ordini >values('12498','2002-09-05','522'); > insert into ordini >values('12500','2002-09-05','124'); > insert into ordini >values('12504','2002-09-05','522'); > - > > Now, this is what is giving me an issue: > --- > use premiere; > > > select * > from clienti as c join rappresentanti as r on c.codrappr = r.codrappr > where r.codrappr='03'; > > select * > from rappresentanti NATURAL JOIN clienti; > -- > > For some weird reason the natural join returns an empty set, but there > is a column, just the one I need whose name is the same > in both relations which is Codrappr. > Why doesn't it work as it's supposed to? > > As you can see they are the same: > create table if not exists Rappresentanti( > CodRappr char(2) primary key, > cognome char(10), > nome char(8), > via char (15), > citta char(15), > prov char(2), > cap char (5), > TotProvv decimal(8,2), > PerProvv decimal(8,2) > ) TYPE=INNODB; > > > create table if not exists clienti( >CodCliente char(3) primary key, >cognome char(10), >nome char(8), >via char (15), >citta char(15), >prov char(2), >cap char (5), > saldo decimal(8,2), >fido decimal(8,2), > CodRappr char(2) not null references > Rappresentanti(CodRappr) > ) TYPE=INNODB; > > > > Thank you very much in advance. > I hope someone will solve this thing. > > I think the result of NATURAL JOIN is correct. For refference about JOIN and especially NATURAL JOIN, you can see http://dev.mysql.com/doc/refman/5.1/en/join.html -- Muhammad Subair

Re: setting up root account

buffer. > > mysql> use mysql; > ERROR 1044 (42000): Access denied for user ''@'localhost' to database > 'mysql' > mysql> > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql?unsub=msub...@gmail.com > > -- Muhammad Subair

Re: Intro to indexing?

WHERE clientID=x AND employeeID=y AND workdate=z. - A column or set of columns that forms a subset of a multicolumn index, as long as there is a leftmost prefix of the index columns for example, with the assignment table as before, with an index on (clientID, employeeID, workdate), indexes would b