is it generally recommended / a good idea to have more than one PRI index
in the same table? i've never seen that before until today while trying
to track down bugs in someone else's system and noticed a table with 2 PRI
indexes. will this cause any problems?
tia.
~shawn
try using SHOW FIELDS FROM TABLE LIKE EXPR, where 'TABLE' is the
name of the name of the table, and 'EXPR' is an expression indicating what
you wish to match.
for example, to get the information about a column called 'ckey' in table
'config', you would do: SHOW FIELDS FROM CONFIG LIKE 'CKEY'.
there are a number of ways you could accomplish this.
depending on how large the database is, you may want to try exporting it
to csv (comma separated value) format, and then importing it into mysql,
using either the load command, or a third-party utility like phpmyadmin
(which is what i
just out of curiousity, was there a particular advantage to you using
varchar as opposed to date for the column type? because if so it would be
a lot easier to manipulate that date.. you could calculate differences in
dates, get portions of the date, and all sorts of other nice things if it
were
mark,
you need to actually write the code somehow in frontpage. i've not dealt
w/ frontpage in a LONG time (mainly cos i can't stand it, but that's
personal opinion so i'll refrain from commenting) ... but i believe there
is a way you can write raw html or php code in there somewhere. that
from http://www.mysql.com/doc/M/i/Miscellaneous_functions.html:
DECODE(crypt_str,pass_str)
Descrypts the encrypted string crypt_str using pass_str as the password.
crypt_str should be a string returned from ENCODE().
hope this helps.
~shawn
On Wed, 1 Aug 2001, saraswathy saras wrote:
hai
does check table or myisamchk say?
shawn reed schrieb am Montag, 30. Juli 2001, 07:44:15:
hi all,
i apologize for the utterly newbie-ish question, but i've yet to find an
answer to it after having spent quite some time searching mysql's web site
(especially since half the links i
hi all,
i apologize for the utterly newbie-ish question, but i've yet to find an
answer to it after having spent quite some time searching mysql's web site
(especially since half the links i click on now seem to be giving me 404
errors...)
how does one reindex a table containing fulltext