RE: Bug in BETWEEN same DATETIME

2013-05-29 Thread Rick James
(To ramble in a slightly different direction...) I claim that the world gained half a second when we went from "round time" to "square time" a few decades ago. Before then, announcers on radio/tv would look at their round-shape analog clock to see what time it was; they would perform a ROUND()

Re: Temporary Tables with Triggers Problem

2013-05-29 Thread hsv
2013/05/29 14:51 +0100, Neil Tompkins This is my Trigger which doesn't seem to work; but doesn't cause a error DROP TEMPORARY TABLE IF EXISTS tempHotelRateAvailability; CREATE TEMPORARY TABLE tempHotelRateAvailability(AuditTrailId varchar(36),UserId bigint(20),ActionType enum('INSER

Re: Temporary Tables with Triggers Problem

2013-05-29 Thread Neil Tompkins
OK, the data is going into the temp table. But when I run the command INSERT INTO AuditTrail SELECT tempHotelRateAvailability.* FROM tempHotelRateAvailability; from the TRIGGER it does not copy the data. However if I run this query INSERT INTO AuditTrail SELECT tempHotelRateAvailability.* FROM

Re: Temporary Tables with Triggers Problem

2013-05-29 Thread Ananda Kumar
But, does it work inside the trigger. If not, then based on the logic, there will not be any data, and data goes not get inserted from temp table to innodb table On Wed, May 29, 2013 at 7:29 PM, Neil Tompkins wrote: > I took the following lines of code slightly modified and it returned some > d

Re: Temporary Tables with Triggers Problem

2013-05-29 Thread Neil Tompkins
I took the following lines of code slightly modified and it returned some data using a normal Query Editor CREATE TEMPORARY TABLE tempHotelRateAvailability(AuditTrailId varchar(36),UserId bigint(20),ActionType varchar(36),TableName varchar(36),RowKey varchar(255),FieldName varchar(36),OldValue var

Re: Temporary Tables with Triggers Problem

2013-05-29 Thread Ananda Kumar
did u check if data is getting inserted into tempHotelRateAvailability On Wed, May 29, 2013 at 7:21 PM, Neil Tompkins wrote: > This is my Trigger which doesn't seem to work; but doesn't cause a error > > DROP TEMPORARY TABLE IF EXISTS tempHotelRateAvailability; > > CREATE TEMPORARY TABLE te

Re: Editing existing Trigger MySQL 5.6

2013-05-29 Thread hsv
2013/05/29 10:39 +0100, Neil Tompkins Using Workbench with MySQL 5.6 how do I edit a existing Trigger. Do I need to DROP the Trigger and create a new one ? If that is the case how can you run start command in a live environment ? Whatever appearance Workbench adds (I do not kn

Re: Temporary Tables with Triggers Problem

2013-05-29 Thread Neil Tompkins
This is my Trigger which doesn't seem to work; but doesn't cause a error DROP TEMPORARY TABLE IF EXISTS tempHotelRateAvailability; CREATE TEMPORARY TABLE tempHotelRateAvailability(AuditTrailId varchar(36),UserId bigint(20),ActionType enum('INSERT','UPDATE','DELETE'),TableName varchar(36),RowK

Re: Temporary Tables with Triggers Problem

2013-05-29 Thread Ananda Kumar
can you please share the code of the trigger. Any kind of error your getting On Wed, May 29, 2013 at 6:49 PM, Neil Tompkins wrote: > Hi, > > I've a trigger that writes some data to a temporary table; and at the end > of the trigger writes all the temporary table data in one insert to our > norm

Temporary Tables with Triggers Problem

2013-05-29 Thread Neil Tompkins
Hi, I've a trigger that writes some data to a temporary table; and at the end of the trigger writes all the temporary table data in one insert to our normal Innodb table. However, for some reason the trigger isn't copying the table from the temporary table to the Innodb table. If I write in the

Editing existing Trigger MySQL 5.6

2013-05-29 Thread Neil Tompkins
Hi, Using Workbench with MySQL 5.6 how do I edit a existing Trigger. Do I need to DROP the Trigger and create a new one ? If that is the case how can you run start command in a live environment ? Thanks Neil

Re: SSH tunnels and non root accounts get "the server service or the configuration file could not be found"

2013-05-29 Thread Claudio Nanni
Hi Miguel, I'm confused. Where should I issue those commands? Yes from the MySQL Administrator. From what you say it seems that you end up being authenticated as the ''@'localhost' user. Connect again with the MySQL Administrator and the non-root account and issue: mysql> SHOW GRANTS;

Re: SSH tunnels and non root accounts get "the server service or the configuration file could not be found"

2013-05-29 Thread Miguel Gonzalez
I'm confused. Where should I issue those commands? I have connected in the linux box with that user and when I start the mysql client I issue those commands and I get the same result. Do I have to issue those commands (where?) in the mysql administrator? When I log in through the mysql administ

Re: SSH tunnels and non root accounts get "the server service or the configuration file could not be found"

2013-05-29 Thread Claudio Nanni
Miguel, Probably your non-root user is connecting as the anonymous account. Try this: Connect as your (problematic) non-root account and do this: mysql> SELECT USER(); mysql> SELECT CURRENT_USER(); What do you see? If it's as I imagine you should see different values and so just delete the an

Re: SSH tunnels and non root accounts get "the server service or the configuration file could not be found"

2013-05-29 Thread Miguel Gonzalez
In my email I state quite clearly that tunnel is working with the root account so it's not a matter of ports. The error message shows that is trying to get some configuration from the user account that is not working. Under root account I have found a file called .my.cnf with a [client] entry a