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
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
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 12:06 PM
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
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 join
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
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: RE: SQL
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:
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://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
11 matches
Mail list logo