construct table for fast insert/select

hanks very much. ~Grace - Do you Yahoo!? Yahoo! Small Business - Try our new resources site!

about flush logs

In my box, mysql server version is 4.0.18. I tried "> flush logs". Nothing happened in the mysql data directory. All the log files were not replaced. Does "flush logs" rename the old log files and create new log files? Thanks. Grace Tang Software engineer Compute

Allowing remote login

list:-) Thanks in advance for reading a post like this with such a dumb question! Mary Grace -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: 4.0.12 libmysqlclient.a

7;t have any problems resolving it. rgds allen -- * Allen Grace ([EMAIL PROTECTED]) Analyst Programmer Peters Bookselling Services 120 Bromsgrove Street, Birmingham, B5 6RJ * This email and any files transmi

Re: 4.0.12 libmysqlclient.a

it. (Same result for _mysql_server_init.) I did a find and grep across the whole source tree and find no references to these functions, so I don't think they exist and whoever wrote test_libmysqld.c forgot to write them. Or they live in a library that's local to your site. HTH allen --

È«ÃæÖ§³ÖJSP/ASP/PHP/ASP.NETÆóÒµ½¨Õ¾¿Õ¼ä³ÏÑû´úÀí.

È«ÃæÖ§³ÖJSP/ASP/PHP/ASP.NETÆóÒµ½¨Õ¾¿Õ¼ä³ÏÑû´úÀí. ÎÒ˾ÍƳöÆóÒµ½¨Õ¾×¨Óÿռ䣬ȫÃæÖ§³ÖJSP¡¢ASP¡¢PHP¡¢ASP.NET£¬ÏÖÕýÃæÏòÈ«¹ú¸÷µØ³ÏÑû´úÀí£¬ÀûÈó¿É´ï40%£¡   * ÉêÇëʱ´´ÍøÂçµÄ´úÀí£¬³ýÁË¿ÉÒÔÏíÊÜÈ«·½Î»µÄ»¥ÁªÍø²úÆ··þÎñ£¬»¹¿ÉÒÔÃâ·Ñ»ñµÃÓòÃû¡¢¿Õ¼ä¡¢ÖÇÄܽ¨Õ¾¡¢¶¯Ì¬IPµÈµÄÔÚÏß×¢²á´úÂ룬·½±ãÄú¼°Ê±¿ªÕ¹ÒµÎñ¡£   * Ì

Problem with NULLs where they shouldn't be in mysql.user

ven the NULL values. I believe this is caused by the optimizer happily taking the "user IS NOT NULL" part out of the query, because it sees that the user column doesn't support NULL, and thus obviously everything will be NOT NULL. - Daniel Grace - [EMAIL PROTECTED] http://dewin.oldba

Re: Mysql syntax

table), and an index to system.sysname. -- Allen Grace Dark Blue Sea Pty Ltd ph +61 7 3007 fax +61 7 3007 0001 ***The opinions expressed in this email are my own and are not representative of DBS Pty Ltd.*** - Before posting,

Re: Please help - does changing the port the web server listens on affect mysql?

igured out the problem with the one > database. > I created another very simple database and form and can insert data from the > web > form with no problem. What exactly doesn't happen? You posted the code, but didn't say at what stage it fails. allen -- Allen Grace Dark Blue S

Re: stability of freebsd 4.3, gcc 2.95.3

- Original Message - From: "Ken Menzel" <[EMAIL PROTECTED]> To: "Allen Grace" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, July 19, 2001 11:40 PM Subject: Re: stability of freebsd 4.3, gcc 2.95.3 > > Has anyone had unfavoura

Re: MySQL: Multiple INSERTS syntax ...

here id>1219; I am getting an 1064 error Your bracketing is a bit wonky, and you can only have one FROM matching each SELECT. Something like: INSERT INTO customers3 (lastname, firstname) SELECT trim(trailing char(10) FROM firstname), trim(trailing char(10) FROM lastname) FROM customers WHERE id &

stability of freebsd 4.3, gcc 2.95.3

I set MYSQL_DEBUG, I'm able to crash it every time with a specific sequence of operations. (This sequence works if MYSQL_DEBUG is not set, but randomly segfaults in the same procedure later on.) If I can provide more information about the situation I'd be happy to. allen -- Allen Grace Dark B

segfaults in mysql_free_result

char logentry[LOGENTLEN]; sprintf( logentry, "MySQL error %d: %s", i, mysql_error( mcon ) );