range of values that
| can be stored in the column, or the number of digits that
| will be displayed for values having a width exceeding that
| specified for the column.
I haven't found much use for display widths myself, but then
different people use MySQL differently.
--
Keith C. I
"IN" operator:
http://dev.mysql.com/doc/mysql/en/Comparison_Operators.html#IDX1209
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
to use the ALL
keyword after UNION (since the UNION keyword isn't even there). That
means it will always eliminate duplicate rows (like DISTINCT). That
hasn't come up when I've used it, since I've never been selecting
result sets that could contain duplicate rows, b
top 10 records from a table
ordered by one column and then sort them alphabetically by
another column.
Now, the fact that the syntax isn't documented may mean that it will
disappear, but it's reasonable and useful.
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Onlin
string types other than ENUM, the default value is the
empty string.
http://dev.mysql.com/doc/mysql/en/CREATE_TABLE.html
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
--
MySQL General Mailing List
For list archives: http://lists.
creating your tables (or alter it later after they get big, though
that could take a while), they'll be able to grow past 4 GB even if
they're dynamic.
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
--
MySQL General Mailing List
For l
the table are indexed, and new rows are indexed as they are
added. What makes you think they're not?
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
ROM Table1 a INNER JOIN Table2 b
ON a.Field1 = b.Field1 AND a.Field2 = b.Field2
WHERE )
ORDER BY ;
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
67 or 65,535 or ... by using an AUTO_INCREMENT primary key
that's a TINYINT or UNSIGNED TINYINT or SMALLINT or UNSIGNED SMALLINT
..., but I don't think that's going to help you either.
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.or
If the data file becomes larger than can be handled by that
size of pointer, then you can't add any more records to the table
(unless you increase MAX_ROWS or AVG_ROW_LENGTH so that the pointer
size is increased).
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Docu
On 24 Feb 2004 at 12:00, Bill Marrs wrote:
> Actually, I just noticed that even after I restart mysql, the speed
> stays. That doesn't make any sense, maybe there is some other unknown
> factor influencing this.
Sounds like it's your operating system's caching of the
espace
(which generally includes tabs, carriage returns, and line feeds --
and sometimes vertical tabs, form feeds, or nulls -- along with
spaces).
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
--
MySQL General Mailing List
For list ar
om/doc/en/MySQL_indexes.html
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ll exist temporarily, but it won't be a TEMPORARY table in
the MySQL sense.
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
able_options", and
(looking at the "CREATE TABLE" syntax) "table_options" can be a
single "table_option", and "table_option" can be "PACK_KEYS = 1".
So the syntax is just
ALTER TABLE table_name PACK_KEYS = 1;
--
Keith C. Ivey <[EMAIL PROTEC
ding 1 (rather than INTERVAL 1 SECOND), gives
20040213114860, which gets converted to 20040213114800 on insert. If
you've already used all the timestamps for that minute, then you're
never going to get to the next minute (and thus never going to get a
usable ID) by repeatedly addi
2131422. That's also ugly, but not as
ugly as the solution with waiting.
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
e delays if traffic gets high. I think you've
got to bite the bullet and change the unique ID to something that's
actually unique -- even an AUTO_INCREMENT would work.
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
--
MySQL General Maili
#x27;t an
exact number but a measurement of some sort, so it could just as well
be 0.0123449 or 0.0123451, and 0.01234 is perfectly fine as a rounded
value.
If you do have exact numbers with six decimal places, you're probably
better off storing them as some sort of integer and adding th
put "DESC" after each of them, not just
the last one.
ORDER BY
MID(datecol,8) DESC,
FIELD(LEFT(datecol,3),
'Jan','Feb','Mar','Apr','May','Jun',
'Jul','Aug','Sep','Oct',&#
ction
of my my.cnf for ages, and it works fine:
set-variable = max_allowed_packet=16M
I see now that that syntax is deprecated in MySQL 4.0, so I should at
some point change it to
max_allowed_packet = 16M
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodo
ed_packet from the default value of 1M. I believe that
earlier versions of MySQL seomtimes gave "server went away" error in
that circumstance rather than "packet too large".
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
ger
(or other numeric type) for the column. Failing that, you have to
cast the value into a numeric type before comparing them.
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
--
MySQL General Mailing List
For list archives: http://lists.mysql
perfect
sense. It's not a bug.
Avoiding time zone and daylight time issues is the main reason to use
Unix time. I don't see the advantage of keeping your time in two
different formats. It seems like sticking to one would be simpler.
But then I don't know your system.
--
K
ttom ):
It seems to be converting the date right. FROM_UNIXTIME() does the
opposite of UNIX_TIMESTAMP(). It takes an integer representing a
Unix time and converts it to a DATETIME in local time (not GMT). It
would be nice if there were a FROM_UNIXTIME_TO_GMT() function, but
there isn't.
--
n in
> the where clause.
How about something like this?
SELECT * FROM DateInfo WHERE updateDate BETWEEN '2003-03-01' AND
'2003-03-31';
Or if updateDate is a DATETIME column,
SELECT * FROM DateInfo WHERE updateDate BETWEEN '2003-03-01
00:00:00' AND &
ompound index using it.
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
to use bind_param() to identify the parameter as an integer.
Rudy Lippan, the author of DBD::mysql, had a message about it on the
dbi-users list:
http://groups.google.com/groups?selm=Pine.LNX.4.44.0307291622390.14615
-10%40elfride.ineffable.net
--
Keith C. Ivey <[EMAIL PROTECTED]>
On 28 Oct 2003 at 13:59, Dan Greene wrote:
> Is there a way to do this on a live running (i.e. production) server?
http://www.mysql.com/doc/en/OPTIMIZE_TABLE.html
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
--
MySQL General Mailing List
column to update automatically,
you shouldn't be using TIMESTAMP in the first place. You probably
want DATETIME instead.
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
--
MySQL General Mailing List
For list archives: http://lists.m
ome but not all of these features, and some of
| them are implemented differently.)
?
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
and if it's changed issue a warning
message and re-create the file with the new output. Seems a lot
better than hand-coding.
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
t?
So can you use "SELECT DAYOFYEAR( datefield - INTERVAL 4 HOUR ) AS
day ... GROUP BY day"?
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscrib
them.
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ttp://www.mysql.com/doc/en/Fulltext_Fine-tuning.html
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
S NULL ORDER BY 'tr.Amount' DESC;
You are ordering by a constant: the string "tr.Amount". Since the
string is the same for every row, you're not actually getting any
ordering. What are you trying to accomplish with those quotes?
Get rid of them, and you may get the r
On 15 Sep 2003 at 11:47, Brent Baisley wrote:
> It's almost useless to specify a property as NOT NULL and also set a
> default value. The only way it would ever be NULL is if you
> specifically set it to NULL.
I think you meant "NULL" rather than "NOT NULL"
nto FULLTEXT indexes:
http://www.mysql.com/doc/en/Fulltext_Search.html
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
er to your initial question is that, yes, the optimizer is
affected by the data in the table. It's not a bug. Otherwise it
wouldn't be mouch of an optimizer. It still does make mistakes,
though, and USE INDEX should solve the problem in those cases.
--
Keith C. Ivey <[EMAI
riting 8
> characters. extreme waste of space.
Not an extreme waste of space. If you use TINYBLOB, it's only 1
extra byte to store the length, so you'll be using 9 bytes instead of
8. Still, it doesn't seem like the best idea.
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco
where the problem is
> print $numrows;
> }
This is a DBI question, not a MySQL question. Have a look at the
documentation for the do() method in DBI. It returns the number of
rows, not a statement handle.
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobacc
OW_LENGTH=2" to the
end) and then copy all the records into it:
INSERT INTO email_body_NEW SELECT * FROM email_body;
Actually, the exact figures for MAX_ROWS and AVG_ROW_LENGTH shouldn't
matter, as long as their product is between 2**32 and 2**40 - 1.
End quoted tex
ly to help with solving the problem for your other table)?
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On 4 Sep 2003 at 15:31, Keith Bussey wrote:
> I do have another Database on the same machine which has a table that
> is a lot bigger (about 9 GIGs) and it wasn't created with any of the
> special table options suggested by Keith C. Ivey below.
Does the other table have fixed-leng
NTO email_body_NEW SELECT * FROM email_body;
Actually, the exact figures for MAX_ROWS and AVG_ROW_LENGTH shouldn't
matter, as long as their product is between 2**32 and 2**40 - 1.
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
--
MySQL
ALTER TABLE email_body MAX_ROWS=;
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
and Field_1 through Field_22 in the query as well.
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
selecting it (although selecting such insufficiently
unspecified may confuse yourself and those who come after you).
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
es (since the hash values for consecutive keys
won't be consecutive). But if you're using IN in you're query (with
more than one value in the list) then you need to get a range from
the index. Since that's not possible with a heap table, the whole
table must be s
ere some way to get subscribed by e-mail without
replying to a confirmation message?
At any rate, I think they're a result of mistakes, not a plot, and
the addresses should simply be removed from the list.
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://t
ix-based index
should be fine.
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
put EXPLAIN in front of your SELECT statement to see how
MySQL plans to execute it. Those seem to be treated identically in
version 4.0.14, but it's possible that the second one wasn't as
optimized in some earlier version.
Documentation on EXPLAIN is here:
http://www.mysql.com
so, you're joining on
contact_id in one table and account_id in the other; presumably you
want contact_id in both.
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On 15 Aug 2003 at 16:34, Jackson Miller wrote:
> However I want to know how I can
> optimize my insert statements to try to speed things up.
Have you read this?
http://www.mysql.com/doc/en/Insert_speed.html
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents
ing quotes around the values in your HTML
form, so you're ending up with something like this in your HTML:
rather than this:
(The first two sets of quotes aren't necessary, but it's easier just
to get into the habit of always using them.)
--
Keith C. Ivey <[EMA
time1) ) /
60;
(assuming the dates are within the 1970-2037 range).
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
01-00 00:00:00".
Odd, on mine it gives "1901-12-13 15:45:52", which is the same as
FROM_UNIXTIME(-2147483648), which is what I would expect if the
argument to FROM_UNIXTIME() is a signed integer.
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccod
er
method to include variables in your SQL (such as printf or DBI
placeholders).
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
27;t
explain why the result changed.
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
WHERE Name = 'Author\\\'s';
Things are a bit more complicated with LIKE, because you want two
backslashes in the string you give to LIKE, which means you need to
start with four backslashes (there's an extra level of escaping):
SELECT * FROM table WHERE Name LIK
es is a remarkably bad idea (unless of course it's your boss).
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Unix timestamps for
future times as well as past ones.
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
you're not going to do calculations on them. Besides,
don't some ISBNs end in 'X'?
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
u, which should help in figuring out what's going wrong.
If I had to guess, I'd say the problem was with the location of the
file (are you giving MySQL the full path?) or with permissions.
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
-
d DELETE query". In this
case, you're trying to delete from a database called '$sql_id' --
that is, a dollar sign followed by 'sql_id'. Presumably that's not
your actual database name. Remove the single quotes (so that you're
using the *value* of $sql_i
even if the database doesn't exist yet). To actually create the
database you need to use CREATE DATABASE:
http://www.mysql.com/doc/en/CREATE_DATABASE.html
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
--
MySQL General Mailing List
F
ere will be a restriction on places
> >for up to 3 days so this will have to be taken into account.
> >
> >Has anyone done something like this?
> >
> >Cheers
> >Andrew
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
poster is doing.
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
hat MySQL handle the particular character
encoding and character set so as to know which characters (or byte
sequences) are parts of words and which aren't.
Perhaps you're think of the LIKE operator?
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodoc
;re going to do some calculations on them as well at some point,
and it's likely that not all those calculations are going to occur in
MySQL (even assuming MySQL handles DECIMAL calculations exactly).
You may have an easier time in your applications doing the
calculations on integers.
f" (or whatever) header, and possibly others,
depending on what you're trying to do.
Except for the process of retrieving the data from the database, this
has nothing to do with MySQL, so questions related to HTML, PHP, and
HTTP headers should be directed to another list.
ALTER TABLE pics2003 AUTO_INCREMENT = [one more than the MAX];
If you need to sort by something other than the ID, you should
introduce a new column to sort by rather than changing the ID values.
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments
you can use whatever
number is necessary to distinguish most of your strings (it doesn't
matter much).
Also, the last index (UNIQUE(UserId, UserName)) is pointless, because
UserId is already unique on its own.
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://to
't give us
any clue about your table structure or indexes (by posting your
CREATE TABLE statement, for example) what do you expect us to be able
to say?
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
--
MySQL General Maili
(
> certificate.uid = master_info.uid ) LEFT JOIN endorsements ON (
> certificate' at line 1
Plain "JOIN" doesn't take a join condition (ON). You presumably mean
"INNER JOIN". See the documentation:
http://www.mysql.com/doc/en/JOIN.html
--
Keith C. Ivey <[EMA
.
SHOW CREATE TABLE table_name;
SHOW INDEX FROM table_name;
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RFC:
http://www.faqs.org/rfcs/rfc1437.html
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
E-mail addresses would normally be searched for as phrases, so
"[EMAIL PROTECTED]" would be equivalent to "peten714 student
liu se". To search for a phrase you need to use Boolean mode. See
the documentation:
http://www.mysql.com/doc/en/Fulltext_Search.html
--
Keith C. Ivey <[EM
itdate happens to be a DATETIME field.
> Your suggested query doesn't pull any results.
If it's a DATETIME field, you'll want something like
... WHERE a.submitdate BETWEEN '2003-07-01 00:00:00'
AND '2003-07-14 23:59:59';
or
... WHERE a.subm
7; AND '2003-07-14';
Is that what you're looking for?
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
d other date and time functions
is here:
http://www.mysql.com/doc/en/Date_and_time_functions.html
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:ht
pported placeholders, but you
still simplify the escaping of values.
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ger that the .MYD file -- perhaps
much larger if you have lots of non-text columns. The difference may
be greater or smaller than the size of the .MYI file. It depends on
your data and your indexes. In most cases I'd say that whatever
difference there is isn't enough the affect the choice
requires MySQL 4). Try this instead:
SELECT ID FROM emails WHERE MATCH(h_subject, body) AGAINST
('V000*' IN BOOLEAN MODE);
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
--
MySQL General Mailing List
For list archives: http:/
('V000*');
Read the documentation here:
http://www.mysql.com/doc/en/Fulltext_Search.html
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I
stand by my statement about the size difference (whichever way it
happens to go) not being a deciding factor between using mysqldump
and copying the files (with mysqlhotcopy or otherwise).
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
--
MySQL
to do with binary 0 bytes (which would be represented as '\0' in
MySQL SQL statements).
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ke the same amount of time.
Do an EXPLAIN on each of your SELECT queries and compare the use of
indexes to see why there's such a difference.
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
--
MySQL General Mailing List
For list archives:
large indexes, the index file will be large enough that it and the
data file combined will be larger than the dump file, but in some
cases it won't be. I wouldn't consider the difference in size,
whichever way it goes, to be significant in deciding between backup
methods.
here are 8 rows in 'carello'
corresponding to each row in 'ordini', so the sums are multiplied by
8.
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ates will all be blocked until after the
copying is done. If your database is big enough and active enough
that locking it during the copying time is unacceptable, consider
setting up a replication server and backing that up instead.
--
Keith C. Ivey <[EMAIL PROTECTED]>
quot;1" AND lsl.void = "0" ORDER BY company, uid
How do you think the key should be used? You have a key on status,
but you're asking for a wide range of status values. Presumably
MySQL thinks (probably correctly) that using the index to find a
range of status values fr
atic updating by
design:
http://www.mysql.com/doc/en/DATETIME.html
If you don't want automatic updating, perhaps you should use a
DATETIME column instead.
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
--
MySQL General Mailing L
If you need to get your emails through this system please email
[EMAIL PROTECTED] with the subject line UNBLOCK ADDRESS. In the
body of the email. You MUST also INCLUDE the email address you are
communicating with. We will the review and make a decision from
there.
--- End of forwarded message -
as a bit of space. But it's no substitute for validating the
data before inserting it into your table.
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
www.mysql.com/doc/en/SET.html
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
f, then I
> guess I'll have to consider writing a perl script or
> something to add the column specifiers.
Another way would be to make a table with the old structure (without
the new columns) and import into it, then do a SELECT ... INSERT from
it into the real table, specifyin
into a new database
> that has some extra columns and I just want to fill the
> old columns with the legacy data.
It's hard to know since you don't show us any of your code, but it
looks like you should add the list of column names to your INSERT or
LOAD statement rather than letting
es.
0 <= x <= 30
is equivalent to
( 0 <= x ) <= 30
and ( 0 <= x ) evaluates to either 1 or 0, depending on whether it's
true, so it's always less than 30, so the whole expression is always
true.
What you mean is
WHERE TO_DAYS(NOW()) - TO_DAYS(StartDate) BETW
ou said
nothing about stopping with today, or wherever you're intending to
stop. Perhaps you want to change "<= 30" to "BETWEEN 0 AND 30".
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
1 - 100 of 289 matches
Mail list logo
