Re: mysql client update
Hi All, Thanks for the feedback! On 5/17/05, David Logan [EMAIL PROTECTED] wrote: Philip Denno wrote: I'm no database expert, so I may be wrong but I do not think this functionality exists. Usually this type of notification is handled at the application level. That is build an application layer on top of the database which handles all reads and writes to the database. This layer would also keep track of all connected clients and would notify when a record is modified/inserted/created. Cheers, Philip. -Original Message- From: Eric White [mailto:[EMAIL PROTECTED] Sent: May 17, 2005 10:44 AM To: mysql@lists.mysql.com Subject: mysql client update Hi, Where should I look to find information about having clients notified when a table/record is updated? I have a situation where multiple clients will each have an open database connection, and I would like for them to be notified when the database is modified by a member of the group. Something like a trigger that informs all clients that a new record has been added for example. Thanks in advance. Regards Hi, Triggers were added at 5.0.2 They have some limitations but are documented in the manual at http://dev.mysql.com/doc/mysql/en/create-trigger.html Regards -- David Logan South Australia when in trouble, or in doubt run in circles, scream and shout -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql client update
Hi, Where should I look to find information about having clients notified when a table/record is updated? I have a situation where multiple clients will each have an open database connection, and I would like for them to be notified when the database is modified by a member of the group. Something like a trigger that informs all clients that a new record has been added for example. Thanks in advance. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
select into outfile fields fixed (???)
Hello, I've read documentation and looked in the list archives but haven't found anything that specifically addresses the idea of writing out fields in a fixed-field format. I'd like to do something like SELECT id,date INTO OUTFILE 'data.txt' id = column 1, date = column 10; to get a file that looks like: 1001 2003-01-16 1002 2003-01-15 2003 2003-01-16 I can certianly just dump it out comma delimited and then parse that file, or maybe make perl do it all for me, but before I did that I wanted to ask if MySQL can just do it itself. Thanks a lot, Eric -- --- Eric White[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQLGUI 1.7.5
On Fri, 10 May 2002, Jon Lochner wrote: Greetings, Using the semi-static linux binaries to connect to localhost mysqld/mysql 3.23.47. Can connect to the database with mysql -u -p. ODBC also OK But I keep getting the following with the GUI: Can't connect to local MySQL server through socket (111) or if I specifiy IP rather than localhost Access denied for user: 'root@x' (Using password: YES) Thanks I'm far from a MySQL wiz, but I believe you need to specify the socket in the GUI client (under the Manage, Options menu). /tmp/mysql.sock is a likely candidate for this value. The default port is 3306. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php