Seconds_Behind_Master
--
Mike Johnson
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
From: Dan Rogart [mailto:[EMAIL PROTECTED]
On 11/14/07 4:01 PM, Mike Johnson
[EMAIL PROTECTED] wrote:
Correction to a couple of replies I've seen -- a slave
server can have more than one master, but not to the same
database. That is, Slave reads Database1 and Database3
from
to
check on that. Not likely, though.
As for how to set it all up, don't ask me. I just enjoy the results.
:)
(apologies if you get a dupe, Baron -- I accidentally hit reply, not
reply-to-all)
--
Mike Johnson
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
the solution is either remarkably simple or
frustratingly difficult. Thanks in advance if you can help!
--
Mike Johnson Smarter Travel Media LLC
Applications Developer http://www.smartertravel.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
!
--
Mike Johnson Smarter Living, Inc.
Web Developerwww.smartertravel.com
[EMAIL PROTECTED] (617) 886-5539
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
, interesting. My next question was going to be if the second syntax
is correct (all subqueries enclosed in parens), but looks like it's
good.
Thanks, Scott.
--
Mike Johnson Smarter Living, Inc.
Web Developerwww.smartertravel.com
[EMAIL PROTECTED] (617) 886-5539
--
MySQL
design, but you need to not `select *' but the specific
fields you'd like.
An example of might be:
SELECT s.name, s.age, a.street_name, n.num, n.extension
FROM students s
JOIN address a ON a.student_id = s.student_id
JOIN phone_num n ON n.student_id = s.student_id
HTH!
--
Mike Johnson
From: Mike Johnson [mailto:[EMAIL PROTECTED]
From: Koon Yue Lam [mailto:[EMAIL PROTECTED]
the problems is, when I want to query both student, address
and phone num, the sql will be
select * from student s, address a, phone_num n
where s.student_id = a.sudent_id
and s.student_id
a 'foo'
action but not a 'baz' action (those being b and c). I know I know the
answer to this, but I'm drawing a blank at the moment.
Thanks in advance if someone could give me a hand.
--
Mike Johnson Smarter Living, Inc.
Web Developerwww.smartertravel.com
[EMAIL PROTECTED
to (most likely
PHP or Perl), it may be quicker to do those calculations in the wrapping
script (if there is one, that is).
HTH!
--
Mike Johnson Smarter Living, Inc.
Web Developerwww.smartertravel.com
[EMAIL PROTECTED] (617) 886-5539
--
MySQL General Mailing List
For list
`result` separately may not help at
all. Might be worth a shot, though, if you have the disk space and time
to play around with it.
--
Mike Johnson Smarter Living, Inc.
Web Developerwww.smartertravel.com
[EMAIL PROTECTED] (617) 886-5539
--
MySQL General Mailing List
For list
INPUT NAME = \kcompany[]\ TYPE = \hidden\
VALUE=\Apple\;
echo INPUT NAME = \kcompany[]\ TYPE = \hidden\
VALUE=\Banana\;
echo INPUT NAME = \kcompany[]\ TYPE = \hidden\
VALUE=\Peach\;
At that point, if you call:
echo $kcompany[1];
after the form submit, you'll get Banana.
HTH!
--
Mike Johnson
to donwload?
Thanks for your help
SELECT ... INTO OUTFILE is what you want. It's sort of covered in the
SELECT syntax documentation:
http://dev.mysql.com/doc/mysql/en/select.html
Pretty handy at times. HTH!
--
Mike Johnson Smarter Living, Inc.
Web Developer
for. HTH!
--
Mike Johnson Smarter Living, Inc.
Web Developerwww.smartertravel.com
[EMAIL PROTECTED] (617) 886-5539
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
, you can use DATE(date_time_var) to return the date
portion.
HTH!
--
Mike Johnson Smarter Living, Inc.
Web Developerwww.smarterliving.com
[EMAIL PROTECTED] (617) 886-5539
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
the result from the select
is 0 it should be NULL).
How can this be done within the select-statement?
SELECT IF(id = 1, NULL, id) AS id ...
The usage of IF() is IF(expression, true value, false value).
--
Mike Johnson Smarter Living, Inc.
Web Developerwww.smarterliving.com
From: Mike Johnson [mailto:[EMAIL PROTECTED]
From: Martin Rytz [mailto:[EMAIL PROTECTED]
Hi MySQL-Users
I have a simple select statement like 'select id from table'.
The result is 0, becaues the id field is 0 (int-field).
My problem is now how to suppress the 0 and give NULL
(B.Booking_Start_Date)) / (60 * 60);
Given values of '2004-11-01 10:00:00' and '2004-10-31 09:00:00', you end
up with 25 (which I think is what you were looking for, not 24).
As I said, there may be a more elegant way to do that, but this is the
brute-force method that should work.
HTH!
--
Mike Johnson
error-checking, anyway.
--
Mike Johnson Smarter Living, Inc.
Web Developerwww.smarterliving.com
[EMAIL PROTECTED] (617) 886-5539
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
in your code. It sounds
like it's essentially generating this query:
Select * from Education_table where TypeID = HS;
instead of...
Select * from Education_table where TypeID = 'HS';
HTH!
--
Mike Johnson
Smarter Living, Inc.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
1
B 50 2
How do I do this with one sql query? Thanks.
SELECT name, SUM(price), type FROM tablename GROUP BY name, type;
--
Mike Johnson
Web Developer
Smarter Living, Inc.
phone (617) 886-5539
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
date_created, COUNT(*) AS num
FROM tablename
GROUP BY date_created
HAVING num 1;
HTH!
--
Mike Johnson
Web Developer
Smarter Living, Inc.
phone (617) 886-5539
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
From: Mike Johnson
From: Robert Reed [mailto:[EMAIL PROTECTED]
This seems like it should be easy, and I'd be happy
for a simple reference to where in the manual or in
Paul's book I can find the answer. I am wanting to
find basically the inverse of a SELECT DISTINCT
operation. I
is a reserved word (an abbreviation of
DESCRIBE, used to show a table structure).
Either change the name of that column or wrap it in backticks (`DESC`) whenever it's
referenced.
HTH!
--
Mike Johnson
Web Developer
Smarter Living, Inc.
phone (617) 886-5539
--
MySQL General Mailing List
For list archives
BUSINESS_CATEGORY.BUS_CAT_ID = '733788'
--
Mike Johnson
Web Developer
Smarter Living, Inc.
phone (617) 886-5539
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
). That's why that's what's getting inserted.
Manual page is here:
http://dev.mysql.com/doc/mysql/en/Numeric_type_overview.html
Try converting the column to a BIGINT, the signed max alone is 9223372036854775807.
--
Mike Johnson
Web Developer
Smarter Living, Inc.
phone (617) 886-5539
--
MySQL General
if I'm wrong, but isn't it considered best practice to validate
data before it gets to the database?
I can't seem to find a source for this after a quick search on Google, though...
--
Mike Johnson
Web Developer
Smarter Living, Inc.
phone (617) 886-5539
--
MySQL General Mailing List
For list
is actually updated on any
INSERT or UPDATE, not just given a value on the initial INSERT. :)
--
Mike Johnson
Web Developer
Smarter Living, Inc.
phone (617) 886-5539
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Sounds as though PHP was installed without the MySQL library. I haven't done it myself
in a while, but I believe it requires the --with-mysql flag.
HTH
--
Mike Johnson
Web Developer
Smarter Living, Inc.
phone (617) 886-5539
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
this helps. :)
--
Mike Johnson
Web Developer
Smarter Living, Inc.
phone (617) 886-5539
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
while it may look like it makes sense in pseudo-code, on paper it's not
how MySQL evaluates things. It builds the right side of the equality and then compares.
Stick with your second query and you'll be fine, even if it is more typing. ;)
HTH!
--
Mike Johnson
Web Developer
Smarter Living
.
If this is documented online, I've yet to see it (though I haven't exactly gone
looking for it). Someone else may have a more accurate description of the way it's
done, though.
--
Mike Johnson
Web Developer
Smarter Living, Inc.
phone (617) 886-5539
--
MySQL General Mailing List
For list archives: http
= s.ID
HTH!
--
Mike Johnson
Web Developer
Smarter Living, Inc.
phone (617) 886-5539
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
their message again
and again until someone boils over.
Sorry about my hasty reply. :)
--
Mike Johnson
Web Developer
Smarter Living, Inc.
phone (617) 886-5539
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
From: Don Dachner [mailto:[EMAIL PROTECTED]
Is it possible to do something like this?
If(select * from xxx, if record found..update it, if
record not found ..insert it)
Try the REPLACE INTO syntax:
http://dev.mysql.com/doc/mysql/en/REPLACE.html
--
Mike Johnson
Web Developer
Smarter
provide more details for your situation? Your code
is a bit jumbled. We have no idea what pv() does, for instance. Nor db_query(). These
are not standard PHP functions, so you'll have to forgive us if we're all a bit
clueless and unwilling to help.
--
Mike Johnson
Web Developer
Smarter Living, Inc
have the
ability to view or modify Customer B's records.
Does that make any more sense?
--
Mike Johnson
Web Developer
Smarter Living, Inc.
phone (617) 886-5539
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
. It's worh a shot at least.
HTH!
--
Mike Johnson
Web Developer
Smarter Living, Inc.
phone (617) 886-5539
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
From: Mike Johnson
SELECT main.id,
IF(main.type,categories.name,items.name),
IF(main.type,cat,item) AS type
FROM main, IF(main.type,items,categories) WHERE
IF(main.type,categories.id,items.id)=main.id;
Oh, my mistake. I just realized I reversed items and categories in the IF clause
client for limiting
access to data in commonly-used tables.
It begs the question why you're giving your clients access to the native mysql client
itself rather than developing an application to do this, in which you could quite
easily limit such access.
--
Mike Johnson
Web Developer
Smarter Living
/en/Query_Cache_Status_and_Maintenance.html
And here:
http://www.mysql.com/doc/en/SELECT.html
HTH!
--
Mike Johnson
Web Developer
Smarter Living, Inc.
phone (617) 886-5539
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
From: Tim V [mailto:[EMAIL PROTECTED]
How do I unsubscribe?
This message should have a To unsubscribe link at the bottom (if you haven't already
noticed it on every other message you receive).
--
Mike Johnson
Web Developer
Smarter Living, Inc.
phone (617) 886-5539
--
MySQL General Mailing
the records going in the column are 10 characters, use a CHAR(10):
http://www.mysql.com/doc/en/CHAR.html
HTH!
--
Mike Johnson
Web Developer
Smarter Living, Inc.
phone (617) 886-5539
. However, if you're turned off by having to either work on the
command-line console or run a local webserver to use a GUI, I can't say that MySQL is
necessarily what you're looking for.
Good luck in your decision, though.
--
Mike Johnson
Web Developer
Smarter Living, Inc.
phone (617) 886-5539
,
pages.mls_4, pages.mls_5, pages.mls_6,
pages.mls_7, pages.mls_8, pages.mls_9,
pages.mls_10, pages.mls_11, pages.mls_12
);
--
Mike Johnson
Web Developer
Smarter Living, Inc.
phone (617) 886-5539
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
supported for a while, but subselects have not.
SELECT * FROM table1
WHERE item_id IN (1, 2, 3, 4, 5)
should work, but not a subselect. I'm not sure of subselect syntax, actually, or what
(recent) version in which it was introduced.
--
Mike Johnson
Web Developer
Smarter Living, Inc.
phone (617
')
^^
AND approved='1'
ORDER BY year,month,day ASC
Previously, it was going through all the ANDs and then saying oh, /or/ I can grab
rows with a catid of 5 (hence the inclusion of that first row).
HTH!
--
Mike Johnson
Web Developer
Smarter Living, Inc.
phone (617) 886-5539
--
MySQL
today's and tomorrow's dates, respectively).
Can you elaborate on the problem? Where do you get this error?
--
Mike Johnson
Web Developer
Smarter Living, Inc.
phone (617) 886-5539
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
!
--
Mike Johnson
Web Developer
Smarter Living, Inc.
phone (617) 886-5539
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
a temporary discrepancy, but it's the first thing that comes
to mind.
--
Mike Johnson
Web Developer
Smarter Living, Inc.
phone (617) 886-5539
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
sort of frontend with this database?
PHP, Perl, Java, etc?
--
Mike Johnson
Web Developer
Smarter Living, Inc.
phone (617) 886-5539
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
From: Mike Johnson
From: Adel Ardalan [mailto:[EMAIL PROTECTED]
When I select a rather large table to be shown, the rows are
going very fast and I can't see the rows at the beginning.
Also, I can't scroll up. How can I view the results page by
page?
I can only assume you're
From: Dan Greene [mailto:[EMAIL PROTECTED]
another option is to set your pager option:
mysql pager more
then re-run your query
Wow. You learn something new every day.
Thanks!
--
Mike Johnson
Web Developer
Smarter Living, Inc.
phone (617) 886-5539
--
MySQL General Mailing List
From: Mike Mapsnac [mailto:[EMAIL PROTECTED]
Thanks for explanation.
But I don't insert anything at all to the SLAVE. It is 100%.
Can the problem be problem be relative to Mysql 4.0.13 ?
Thanks
Out of curiosity, what's the data type of this column?
--
Mike Johnson
Web Developer
with a column with a # in the name. However, have
you tried enclosing the column name in backticks?
SELECT * FROM table WHERE `FILE#`=1332;
--
Mike Johnson
Web Developer
Smarter Living, Inc.
phone (617) 886-5539
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
-mm-dd hh:ii:ss stamp
(whereas CURDATE() returns just -mm-dd). MySQL handles it silently just fine, but
it's a good habit to get into.
--
Mike Johnson
Web Developer
Smarter Living, Inc.
phone (617) 886-5539
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
SUPER that grants permissions for START/STOP SLAVE? Is
this actually documented anywhere?
Thanks in advance!
--
Mike Johnson
Web Developer
Smarter Living, Inc.
phone (617) 886-5539
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
From: Paul DuBois [mailto:[EMAIL PROTECTED]
At 11:31 -0500 1/15/04, Mike Johnson wrote:
This is in reference to 4.0.16, FWIW...
I can't find any direct references to the actual grant permission
for controlling a slave thread in the online docs. The closest I saw
was the 5th paragraph
for any help!
SELECT project_id,
IF (SUM( time_worked ) '0.00', SUM( time_worked ),'NULL') AS total
FROM time_daily
WHERE user_id = 'clh' AND period_id = '27' AND total IS NOT NULL
GROUP BY project_id;
That should work, though I haven't tested it.
--
Mike Johnson
Web Developer
Smarter Living
, and import it. If you had indices on the original table, you'll have to
manually create them on the new table -- CREATE TABLE ... SELECT FROM doesn't carry
those over.
HTH!
--
Mike Johnson
Web Developer
Smarter Living, Inc.
phone (617) 886-5539
--
MySQL General Mailing List
For list archives
']} BETWEEN start AND end
;
--
Mike Johnson
Web Developer
Smarter Living, Inc.
phone (617) 886-5539
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Properties P1
INNER JOIN Items I ON I.id=P1.Item
INNER JOIN Properties P2 ON P2.Item=I.id
WHERE P1.Name='Color'
AND P1.Value='Gray';
--
Mike Johnson
Web Developer
Smarter Living, Inc.
phone (617) 886-5539
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
about PHP's planned
interactions with MySQL.
HTH!
--
Mike Johnson
Web Developer
Smarter Living, Inc.
phone (617) 886-5539
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
:
SELECT tablename.*, MemberLevels.description FROM tablename, MemberLevels
WHERE tablename.MemberLevelRank=MemberLevels.rank
ORDER BY MemberLevels.rank ASC;
As said, I imagine the previous solution would be better, but it never hurts to
suggest another way. :)
--
Mike Johnson
Web Developer
-Paying' DESC;
Thanks again Mike!
Thanks for posting it, actually, as I wasn't aware of that solution until your
question prompted me to go looking.
--
Mike Johnson
Web Developer
Smarter Living, Inc.
phone (617) 886-5539
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
not sure of any standards for nested functions and control structures such as
that. Anyone have any input on that?
--
Mike Johnson
Web Developer/Systems Asst.
Smarter Living, Inc.
phone (617) 886-5539
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
structure.
On the plus side, if you add a column to the db, all you need to do is add a field of
the same name to the HTML form.
In a nutshell, while it's useful to do things like abstract the construction of the
query, it's often not worth the trouble.
--
Mike Johnson
Web Developer/Systems Asst
, but it might be worth a shot.
--
Mike Johnson
Web Developer/Systems Asst.
Smarter Living, Inc.
phone (617) 497-2500 x226
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
; either side of [EMAIL PROTECTED] are
two separate args to be stored in two separate columns.
This should work...
GRANT ALL ON *.* TO 'me'@'mysite-dev.foo.com' IDENTIFIED BY 'foo';
--
Mike Johnson
Web Developer/Systems Asst.
Smarter Living, Inc.
phone (617) 497-2500 x226
--
MySQL General Mailing
From: Paul DuBois [mailto:[EMAIL PROTECTED]
At 13:29 -0500 12/16/03, Mike Johnson wrote:
From: Ari Davidow [mailto:[EMAIL PROTECTED]
I seem to have run into a problem with a host name that
incorporates a hyphen:
mysql GRANT ALL ON *.* TO [EMAIL PROTECTED]
IDENTIFIED BY foo
], not just the last one.
--
Mike Johnson
Web Developer/Systems Asst.
Smarter Living, Inc.
phone (617) 497-2500 x226
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
parser from thinking that the opening for Password is a close of the string? I
use single quotes in that kind of situation, FWIW.
--
Mike Johnson
Web Developer/Systems Asst.
Smarter Living, Inc.
phone (617) 497-2500 x226
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
off would result in the actual join query returning
nothing.
Let me know how those turn out...
--
Mike Johnson
Web Developer/Systems Asst.
Smarter Living, Inc.
phone (617) 497-2500 x226
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
...
LOAD DATA LOCAL INFILE '/path/to/file'
INTO TABLE tablename
FIELDS TERMINATED BY ','
OPTONALLY ENCLOSED BY '';
--
Mike Johnson
Web Developer/Systems Asst.
Smarter Living, Inc.
phone (617) 497-2500 x226
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
. In that case you'd be right
back at the drawing board. If you build it that flexible from day one, though, he can
change his mind to his heart's content.
Anyway, good luck!
--
Mike Johnson
Web Developer/Systems Asst.
Smarter Living, Inc.
phone (617) 497-2500 x226
--
MySQL General Mailing List
For list
properties.area, images.image_filename FROM properties,
images WHERE properties.reference_number=images.reference_number AND
properties.area='$id';
HTH!
--
Mike Johnson
Web Developer/Systems Asst.
Smarter Living, Inc.
phone (617) 497-2500 x226
--
MySQL General Mailing List
For list archives: http
, actually. The middle two? Or should it pick one?
Good luck either way.
--
Mike Johnson
Web Developer/Systems Asst.
Smarter Living, Inc.
phone (617) 497-2500 x226
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
since). The status for the process usually says
'killed' if that helps.
--
Mike Johnson
Web Developer/Systems Asst.
Smarter Living, Inc.
phone (617) 497-2500 x226
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
/INSERT_SELECT.html
JOIN syntax
http://www.mysql.com/doc/en/JOIN.html
--
Mike Johnson
Web Developer/Systems Asst.
Smarter Living, Inc.
phone (617) 497-2500 x226
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
select a timestamp as...
SELECT DATE_FORMAT(column, '%Y-%m-%d') AS date
...and get a date just fine.
--
Mike Johnson
Web Developer/Systems Asst.
Smarter Living, Inc.
phone (617) 497-2500 x226
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
or check
out:
http://www.mysql.com/doc/en/GRANT.html
--
Mike Johnson
Web Developer/Systems Asst.
Smarter Living, Inc.
phone (617) 497-2500 x226
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Linux 9 running MySQL 4.0.15-standard-log, and the slaves are
Redhat Linux 7.1 running MySQL 4.0.15-standard-log as well.
Has anyone run into this before?
--
Mike Johnson
Web Developer/Systems Asst.
Smarter Living, Inc.
phone (617) 497-2500 x226
--
MySQL General Mailing List
For list archives
'
AND AcctStopTime
= '2003-11-11 15:30:00')
His WHERE clause is on two different fields (AcctStartTime and AcctStopTime). I don't
think a BETWEEN clause is what's needed...
--
Mike Johnson
Web Developer/Systems Asst.
Smarter Living, Inc.
phone (617) 497-2500 x226
--
MySQL General Mailing List
For list
Do you mean like 'mysqldump'? You can use mysqldump to dump tables +/-
data and then upload it to a database later--or 'import' it, e.g.,
mysqldump -u user_name database
all the tables from that database.
mysqldump takes a variety of arguments. see 'man mysqldump' for more
info.
-mj
84 matches
Mail list logo