In the replication FAQ regarding redundancy/high availability. Its example
looks as if it could be ... wrong.
: http://dev.mysql.com/doc/mysql/en/Replication_FAQ.html
The basic method is to use one of the slaves as the master in the case
where the master goes down. The potential problem that I
There's no way to know that without knowing the schema of the table you're inserting
into. How you index it is going to be the biggest factor there.
--jfarr
- Original Message -
From: "Gabor Penoff" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, November 15, 2001 2:23 PM
S
You might want to try:
WHERE mycolumn in (1, 3, 23, ...)
Or even better, put your thousand records into a temporary table and then just do a
join.
--jfarr
- Original Message -
From: "Mysql List" <[EMAIL PROTECTED]>
To: "mysql" <[EMAIL PROTECTED]>
Sent: Wednesday, September 26, 2001 1
LAST_INSERT_ID is the value of the auto increment field in the table that was last
inserted into. You probably want:
$sql4 = "SELECT MAX(hits.hit_id) as max_hit_id
as pixels
from hits;";
--jfarr
-
Before posting, please chec
I would try:
select distinct s.some_pk, IFNULL(s.some_pk, 999) as myid
from data_table s, other_data_table
where s.some_pk=232 order by myid;
Although I don't get the purpose of the IFNULL or the order by if you're
selecting only a single value of s.some_pk.
--jfarr
- Original
You could try using the IFNULL() function on that column before you do the join.
http://www.mysql.com/doc/C/o/Control_flow_functions.html
--jfarr
- Original Message -
From: "Bryan Coon" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 18, 2001 11:12 AM
Subject: left outer
> How does one tell if mysql is using BDB?
SHOW TABLE STATUS;
Type = BerkeleyDB
http://www.mysql.com/doc///S/H/SHOW_TABLE_STATUS.html
Do I have to somehow specify BDB
> when creating a new database?
CREATE TABLE [...] TYPE = BDB;
http://www.mysql.com/doc///C/R/CREATE_TABLE.html
I've ins
Here's an online SQL tutorial you may find helpful.
http://www.sqlcourse.com/
--jfarr
- Original Message -
From: "Khan, Moin" <[EMAIL PROTECTED]>
To: "'Cal Evans'" <[EMAIL PROTECTED]>; "Khan, Moin" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Thursday, March 22, 2001 3:02 PM
Subject:
Most people have more than one email address, if that's what you're getting at.
Some email addresses are also used by more than one person.
--jfarr
- Original Message -
From: "Bryan Wheelock" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 21, 2001 12:55 PM
Subject: un
> the table was
> created with the pwd as a VARCHAR(15) <--- will this long enough to held
> the encrypted password??
There's your problem. PASSWORD() returns a CHAR(16).
--jfarr
-
Before posting, please check:
http://w
http://www.google.com/search?q=search+engine+theory ;)
--jfarr
- Original Message -
From: "Jamie Krasnoo" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECTED]>
Sent: Tuesday, February 27, 2001 2:25 PM
Subject: Search Engine Theory
> Could anyone point me to any documents on creating a s
11 matches
Mail list logo
