Re: NOW()
curdate() - Original Message - From: Edilson Vasconcelos de Melo Junior [EMAIL PROTECTED] To: MYSQL [EMAIL PROTECTED] Sent: Sunday, May 12, 2002 12:34 AM Subject: NOW() Hi, I have a table with a timestamp field called dtins. When i insert a row to the table, the value of this field is setted to NOW() just for the inserted the record. My problem is when i update some record, its dtinst value is change again, without a ask to :( How can i avoid this? Is there another function that i can use to get the current datetime? Thank u very much, Edilson Vasconcelos de Melo Junior www.jrsoftwares.com.br [EMAIL PROTECTED] Fone: (19) 3256-3577 sql,query --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.361 / Virus Database: 199 - Release Date: 7/5/2002 - 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 - 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
Mysqldump Problem
Hello Members I am using mysql 3.23.37 on NT. I am getting problem when i am using mysqldump on NT, dumpfile contains all table name in lowercase(i was having all tables name in uppercase). Now i added [mysqldump] set-variable = lower_case_table_names= 0 in my.cnf file.(I searched the mail archive and got this solution) But now i am getting error No variable match for: -O 'lower_case_table_names= 0' Then i checked allowed variable for mysqldump i found only two 1.max_allowed_packet 2.net_buffer_length Can anyone help me how to get rid of this case change problem. Thanks in advance. Damnish - 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
problem with Grant
Hi I am using MySql on linux. I can start mysqld by safe_mysqld --user=mysql --skip-grant-tables But when i try to start it withour --skip-grant-tables, it said Access Denied @localhost. I have updated the mysql.user table and mysql.host table, still i can't connect it . Any help in this matter will be appriciated. Thanks in advance. Damnish - 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: problem with Grant
Yes i did that , after that i restart my server, But still it didn't load the new settings. Kindly help. Thanks Damnish - Original Message - From: oltra jean-michel [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, June 01, 2001 2:52 AM Subject: Re: problem with Grant Have you tried 'flush privileges' after having set root password? jean-michel On Thu, 31 May 2001, Damnish wrote: I am using MySql on linux. I can start mysqld by safe_mysqld --user=mysql --skip-grant-tables But when i try to start it withour --skip-grant-tables, it said Access Denied @localhost. I have updated the mysql.user table and mysql.host table, still i can't connect it . Any help in this matter will be appriciated. Thanks in advance. Damnish - 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 - 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
'invalid authorization specification' error
Hi, I am new to MySql. i have server runnng mysql-3.23.37-win under Windows NT i am using mm.mysql-2.0.4-bin JDBC driver to connect to mysql server. i am able to connect to mysql server from java program run on the same pc with host as 'localhost' or '127.0.0.1'. the ip address of the pc running mysql server is 192.168.9.50 if i use host as : 192.168.9.50 in the same java program from the same pc i get the following error: Exception in thread main java.sql.SQLException: Invalid authorization specification: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) at org.gjt.mm.mysql.MysqlIO.init(MysqlIO.java:330) at org.gjt.mm.mysql.Connection.connectionInit(Connection.java:261) at org.gjt.mm.mysql.jdbc2.Connection.connectionInit(Connection.java:89) at org.gjt.mm.mysql.Driver.connect(Driver.java:167) at java.sql.DriverManager.getConnection(DriverManager.java:517) at java.sql.DriverManager.getConnection(DriverManager.java:199) Kindly Advice. Thanks Damnish - 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
