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
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
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
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
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
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
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
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|
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
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
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
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
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 |
> +---+-+-
13 matches
Mail list logo