Re: MySQL: Select HELP!

Try this: SELECT DATE, COD FROM processo_arquivos ORDER BY DATE DESC LIMIT 10 Unfortunately, that puts them in reverse order. There's probably a better way, with a more sophisticated use of the LIMIT keyword, that puts them in the right order. -Alex On Tuesday, December 3, 2002, at 10:41

Re: mysql and php

Why not change your error message display so it's more informative? Instead of die(Error in input query); try this: or die (Error in input query: . mysql_error() . ($query)/p); That way, you can see exactly what MySQL says the error was, and exactly how the query came out. It's really

ENUM and select performance

I'm working on a project that involves storing a lot of attributes for individuals (think height, weight, eye color, hair color, skin tone, etc.) and will later require searching on those attributes (i.e. return all blue-eyed people with red hair). I'm trying to figure out how to store all of

queries on particular table produce errors

| | +---+-+--+-+-+---+ 2 rows in set (0.01 sec) I'm using mysql-3.23.32 on Mac OS X Server 10.1.1. Thoughts? -Alex -- Alex Pukinskis Internet Consultant aboutChange http://aboutchange.com http://aboutcreative.net 303-444-0012 f: 303-444-0015

Re: queries on particular table produce errors

On Wednesday, December 5, 2001, at 04:08 PM, Robert Alexander wrote: At 15:55 -0700 2001/12/05, Alex Pukinskis wrote: group is a reserved word, use groups as table name That being the case, how do I drop or rename a table called group? Try: ALTER TABLE 'group' RENAME new_table_name

Re: shadow tables?

solve the problem. I also tried creating a new database (with a different name) and new tables by hand. The new database has the same problems. -Alex -- Alex Pukinskis Web and Internet Consultant Satori Design and Development http://satoridesign.com [EMAIL PROTECTED

shadow tables?

command that completely removes databases? Thanks, -Alex -- Alex Pukinskis Web and Internet Consultant Satori Design and Development http://satoridesign.com [EMAIL PROTECTED] Release: mysql-3.23.39 (Source distribution) System: Darwin ermine 1.3.7 Darwin Kernel Version 1.3.7: Sat Jun 9

even weirder case issues

| FirstName | LastName | Email| WorkgroupID | SSN4 | age | Ethnicity | ++---++--+-+--+- -+---+ | 1 | Alex | Pukinskis | [EMAIL PROTECTED] | 1 | | NULL | NULL | | 2 | Joe

case sensitivity issue

I'm having trouble with what appears to be a case sensitivity issue. Essentially, when I use the right case for a table name, the query fails, but when I use the wrong case, the query succeeds. Here's my table list: mysql show tables\g ++ | Tables_in_ac | ++ |