Dear all,
I want to convert some tables from Mysql database to Postgresql Database
in Linux Systems ( Ubuntu-10.4, CentOS ).
Can someone Please tell me tool for it that makes it easier.
I am able to done it through FW tools in Windows System but i want to
achieve it in Linux ( CentOS )
2011/3/1 Adarsh Sharma adarsh.sha...@orkash.com:
Dear all,
I want to convert some tables from Mysql database to Postgresql Database in
Linux Systems ( Ubuntu-10.4, CentOS ).
[...]
invalid byte sequence for encoding UTF8: 0xe3ba27
HINT: This error can also happen if the byte sequence does
By default Postgresql database encoding in UTF8.
It seems to me by seeing error that database encoding in mysql is
different from it.
--
Cheers,
Dhaval Jaiswal
On 01/03/2011 3:57 PM, Adarsh Sharma wrote:
Dear all,
I want to convert some tables from Mysql database to Postgresql
Hey guys,
Am a newbie here and need a little help.
Part of the database consists of two tables events and categories which
look like this
+---+-+
| eventID | eventName |
+---+-+
| 1
Just curious as it is not mentioned. Can Category ID also have multiple
event id ?
--
Cheers
Dhaval Jaiswal
On 01/03/2011 5:53 PM, Wagyu Beef wrote:
Hey guys,
Am a newbie here and need a little help.
Part of the database consists of two tables events and categories which
look like this
Oh yeah, forgot to mention that. Yes, one event will have multiple
categories. And one category can be applicable to multiple events.
On Tue, Mar 1, 2011 at 8:33 PM, Dhaval Jaiswal
jaiswal.dha...@enzenglobal.com wrote:
Just curious as it is not mentioned. Can Category ID also have multiple
I'd asked before how to convert a unix timestamp to the hour that it is
in (and got the perfect answer) :
1298999201 = 3/1/2011 11:06:41 AM
(1298999201 - (1298999201 % 3600)) = 3/1/2011 11:00:00 AM
Now getting the timestamp converted to midnight of that same day isn't
as simple as:
1298999201
You can start by using 60*60*24=86400
;)
On Mar 1, 2011 6:17 PM, Bryan Cantwell bcantw...@firescope.com wrote:
I'd asked before how to convert a unix timestamp to the hour that it is
in (and got the perfect answer) :
1298999201 = 3/1/2011 11:06:41 AM
(1298999201 - (1298999201 % 3600)) =
It was of course a typo, and even with the correct number isn't the answer
On 03/01/2011 11:47 AM, Claudio Nanni wrote:
You can start by using 60*60*24=86400
;)
On Mar 1, 2011 6:17 PM, Bryan Cantwell bcantw...@firescope.com
mailto:bcantw...@firescope.com wrote:
I'd asked before how to
You could use:
CONCAT(DATE_FORMAT(FROM_UNIXTIME(1298999201),'%Y-%m-%d'),' 12:00:00')
JW
On Tue, Mar 1, 2011 at 11:58 AM, Bryan Cantwell bcantw...@firescope.comwrote:
It was of course a typo, and even with the correct number isn't the answer
On 03/01/2011 11:47 AM, Claudio Nanni wrote:
From the command line there was no way to run mysql.exe
I may be dwelling on the obvious, but have you checked the place MySQL
system libraries in the system path (or something similar) checkbox on
install? v5.5.9 runs fine with me on Win7.
--
MySQL General Mailing List
For list archives:
Or you can interrupt the query instead, although I've seen it not to
work on occasions: KILL QUERY id;
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
SELECT
unix_timestamp() + 86400 + (unix_timestamp() % 86400);
currently gives me 6:39 AM tomorrow
SELECT
UNIX_TIMESTAMP(DATE(FROM_UNIXTIME(1299003702)));
actually gives me what I want, but seems really stupid way of getting
something that is probably very simple
On 03/01/2011 12:03
That's closer:
SELECT
UNIX_TIMESTAMP() + 86400 - (UNIX_TIMESTAMP() % 86400);
Gives me 6:00 PM today...
On 03/01/2011 12:32 PM, Singer X.J. Wang wrote:
SELECT
unix_timestamp() + 86400 - (unix_timestamp() % 86400);
--
--
MySQL General Mailing List
For list archives:
Hi Bryan, all!
Bryan Cantwell wrote:
That's closer:
SELECT
UNIX_TIMESTAMP() + 86400 - (UNIX_TIMESTAMP() % 86400);
Gives me 6:00 PM today...
The Unix timestamp is UTC-based (old name: GMT).
You don't write which timezone you are using, but your notation 6:00
PM makes me assume you are
2011/03/01 20:23 +0800, Wagyu Beef
Part of the database consists of two tables events and categories which
look like this
+---+-+
| eventID | eventName |
+---+-+
| 1 | Event A
16 matches
Mail list logo