Re: MySQL select matching

2010-07-21 Thread Roberto Zárate Mendoza
hello ash...@pcraft.com; where is the solution: You have table A, so copy the entire table in another table. Table B. so Table A=Table B (only in data no constrains) then [id]=id you want to search Untitled select B.cod,count(*) entrysA from A,B where A.atrib1=B.atrib1 and A.atrib2=B.atrib2 and A

Re: Table which can reference a number of other tables

2010-07-21 Thread Nguyen Manh Cuong
Hi Marc, - If you use this database for some website, the solution is: clients (id,name) contacts (id, name, phone, client_id (FK), username, password) companies (id, name) employees (id, name, phone, company_id (FK), username, password) logins table will be removed Then you must build web int

Table which can reference a number of other tables

2010-07-21 Thread Marc Guay
Hi everyone, I have a question regarding database design, I hope that this is appropriate for the list. Let's say that I have the following tables: clients (id,name) contacts (id, name, phone, client_id (FK)) companies (id, name) employees (id, name, phone, company_id (FK)) logins (id, usernam

Re: Setting Up MySSQL replication with SSL on Ubuntu and Windows

2010-07-21 Thread a . smith
According to this you must install OpenSSL then compile MySQL from source http://dev.mysql.com/doc/refman/5.0/en/secure-basics.html Would be nice if someone on the list with prior experience would comment Quoting Tompkins Neil : Hi I found this documentation. However, I need more in

Re: combined or single indexes?

2010-07-21 Thread Tompkins Neil
Hi So Just running a basic query I get returned the following : table,type,possible_keys,key,key_len,ref,rows,Extra, Products,ALL,9884,where used, Therefore, I assume "*ALL*" is the worst possible type and should look at adding a an index to this particular field ? Cheers Neil On Fri, Jul

MySQL 5.0.44 with Innodb Max memory problem :-(

2010-07-21 Thread Nunzio Daveri
Hello Gurus, I just inhereted a Sun 2 U Server with 2 Intel Quad Core CPU's and 16 GB of ram. Here is the problem. The machine is constantly at 99% Memory utilization and we get random row locking, we are only using InnoDB. The database is around 150GB with over 5,000 tables. To make things wors

Re: Help me

2010-07-21 Thread Mark Goodge
On 21/07/2010 16:33, Karthik Pr wrote: I have created a table as follows but i was not able to use full text search on a specific data. create table racebike (id int auto_increment not null primary key, name varchar(10), user text,fulltext(name,user)); [snip] The query is mysql> select * fro

Help me

2010-07-21 Thread Karthik Pr
I have created a table as follows but i was not able to use full text search on a specific data. create table racebike (id int auto_increment not null primary key, name varchar(10), user text,fulltext(name,user)); The table is as follows, ++-+-+ | id | name|

Re: newb problem

2010-07-21 Thread jayabharath
On Tue, Jul 20, 2010 at 9:58 PM, dennis skinner wrote: > > > Hello I am a new mysql user. Can anyone tell me why this does not create > a table? > > < ?php(the spaces before the question mark are not in the > code) > $dbuser="smeduser"; > $dbpassword="x"; > $dbname="smed"; > my

Re: Setting Up MySSQL replication with SSL on Ubuntu and Windows

2010-07-21 Thread Tompkins Neil
Hi I found this documentation. However, I need more information on setting up SSL on Windows ? Neil On Wed, Jul 21, 2010 at 3:39 PM, wrote: > Google? > http://dev.mysql.com/doc/refman/5.0/en/replication-solutions-ssl.html > > This is for MySQL 5.1, I imagine its probably the same in 5.1 but a

Re: Setting Up MySSQL replication with SSL on Ubuntu and Windows

2010-07-21 Thread a . smith
Google? http://dev.mysql.com/doc/refman/5.0/en/replication-solutions-ssl.html This is for MySQL 5.1, I imagine its probably the same in 5.1 but another little google should be able to confirm that for you Quoting Tompkins Neil : Hi, We are running Ubuntu 10.04 LTS with MySQL 5.1.46 and

Setting Up MySSQL replication with SSL on Ubuntu and Windows

2010-07-21 Thread Tompkins Neil
Hi, We are running Ubuntu 10.04 LTS with MySQL 5.1.46 and Windows 2003 with MySQL 5.1.46. Normal master to master replication between the two server is running fine. However, we now want to set-up the replication with SSL to ensure that all data which is replicated both ways between the two serv

Re: [PHP] MySQL select matching

2010-07-21 Thread Simcha Younger
On Mon, 19 Jul 2010 10:36:40 -0600 "Ashley M. Kirchner" wrote: > mysql> select * from table where id='1'; > +---+-+-+---+ > | 1 | 123 | 0.0 | C | > | 1 | 234 | 0.1 | D | > | 1 | 345 | 0.0 | D | > | 1 | 456 | 0.1 | C | > | 1 | 567 | 0.1 | G | > +---+-+-