Reshuffling unique integers

o 2, it causes a (temporary) duplication of the value 2 in this unique (primary key) column. How else am I supposed to do this? Thanks! Amittai Aviram [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manu

Char columns and speed in joins

VARCHAR columns? Thanks. Amittai Aviram [EMAIL PROTECTED] sql.query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this

create table ... select ... w/ index

When you copy a table using CREATE TABLE ... SELECT ..., the indexes do not get copied automatically. Is there a convenient way to transfer all indexes, other than looking them up with DESCRIBE or SHOW INDEX and then using either ALTER TABLE ADD INDEX, etc., or CREATE INDEX? Thanks! Amittai

Re: Subselect workaround

FROM faculty WHERE lastName = "Jones") WHERE ordr = 1; Thanks! Amittai Aviram [EMAIL PROTECTED] This is not spam! See? -- sql.query - Before posting, please check: http://www.mysql.com/manual.php

Subselect workaround

How can I do the equivalent of this in MySQL 3.23? What about MySQL 4.0? Thanks! Amittai Aviram [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Reading logs

In both the MySQL manual and Paul DuBois superb _MySQL_, I find information about turning logging on, rotating log files, and maintaining log files -- but I still do not understand how I am supposed to _read_ a log file. I am running MySQL 4.0.5-max-debug under Windows XP. If I issue the bare com

Exam takers near Columbia, SC

Anybody out there planning to take the new MySQL Core Certification Exam anytime soon and anywhere near Columbia, South Carolina, USA? It might be nice to chat on the phone and compare notes or whatever. Thanks! Amittai - Bef

Perl fetchrow_arrayref

the array itself to hold a row of results from a query? Thanks! Amittai Aviram [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

Re: Embarrassing: can't log in

- Original Message - From: <[EMAIL PROTECTED]> Newsgroups: local.mailgate.mysql.general To: <[EMAIL PROTECTED]> Sent: Sunday, December 01, 2002 6:13 PM Subject: Re: Embarrassing: can't log in > In article <[EMAIL PROTECTED]> you write: > >it only takes a few minutes to uninstall and inst

Embarrassing: can't log in

I can't remember my username and password. All the usernames and passwords that I could think of would fail. What to do now? Thanks! Amittai Aviram - Before posting, please check: http://www.mysql.com/manual.p

Re: access2mysql data types

resentation instead. create table boolean_table(boolean enum("false","true")); insert into boolean_table values("true")); If I am working in C or PHP or another language that treats 0 as false and 1 as true, I can do this sort of test with the results -- or th