Innobase UPDATE ... LIMIT x;

2002-04-10 Thread nickg
--+--+ | Variable_name | Value| +---+--+ | version | 3.23.49a-max | +---+--+ 1 row in set (0.01 sec) database, mysql, query, update, select, filter nickg - Before posting, please check: htt

RE: "-" character in table name

2002-04-10 Thread nickg
; ERROR 1064: You have an error in your SQL syntax near ''A-14c'' at line 1 mysql> describe "A-14c"; ERROR 1064: You have an error in your SQL syntax near '"A-14c"' at line 1 mysql> describe `A-14c`; ERROR 1146: Table 'dns.A-14c' d

RE: "-" character in table name

2002-04-10 Thread nickg
Try enclosing it: describe `A-14c`; nickg -Original Message- From: David Chen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 10, 2002 2:05 PM To: [EMAIL PROTECTED] Subject: "-" character in table name Hello, I probably installed a PHP script that created a table with

RE: where exists sql problem

2002-03-28 Thread nickg
Ok, first, please send only e-mail, we saw it the first time. Second, MySQL does not support nested queries or sub selects or what you are using. Please see the JOIN syntax in the MySQL documenation: http://www.mysql.com/doc/J/O/JOIN.html nickg -Original Message- From: [EMAIL

RE: perl mysql DBI::db question

2002-02-27 Thread nickg
inish; $dbh->disconnect; if($debug_state) { print "S: $t_user,$t_password,$t_prefs\n"; } nickg -Original Message- From: Shon Stephens [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 10:08 AM To: [EMAIL PROTECTED] Subject: per

RE: "Too Many Connections" error

2002-01-16 Thread nickg
Won't this handle half of your issues? http://www.mysql.com/doc/S/e/Security.html If you want to restrict the number of connections for a single user, you can do this by setting the max_user_connections variable in mysqld. nickg -Original Message- From: Dave Dyer [mailto:[

RE: Linux vs. Sun and getting Linux to behave like Sun

2001-12-06 Thread nickg
ldn't suggest trying to mess with linux. nickg -Original Message- From: Peter M. Perchansky [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 06, 2001 5:31 PM To: [EMAIL PROTECTED] Subject: Linux vs. Sun and getting Linux to behave like Sun Greetings everyone: I've noticed