Re: export db to oracle

2010-11-16 Thread Shawn Green (MySQL)
On 11/16/2010 15:14, Sydney Puente wrote: Hello, How can I export a mysql 5.0.45 db to Oracle? mysql is going to stau but I need to pass the data to oracle, just so the data can be transfered. I have carried out a mysql dump. This seems fine.create table etc. about 20 MB in total. Any ideas? It

export db to oracle

2010-11-16 Thread Sydney Puente
Hello, How can I export a mysql 5.0.45 db to Oracle? mysql is going to stau but I need to pass the data to oracle, just so the data can be transfered. I have carried out a mysql dump. This seems fine.create table etc. about 20 MB in total. Any ideas? It is on Redhat if that makes a difference.

Re: Error Unknown column in 'where clause'

2010-11-16 Thread Michael Dykman
I have run into similar issues in far less convoluted circumstances. I'm not going to try to decode your query but using an alias can help clarify things. ... team_name_to FROM players_bids AS PB INNER JOIN players ON players_bids.players_id = players.players_id ... and rename all your player_bid

Re: FW: [USN-1017-1] MySQL vulnerabilities

2010-11-16 Thread Jan Steinman
You seem to see threats as a "black and white" problem. Put enough "what ifs" in front of a statement, and nothing anywhere has any security at all. On 15 Nov 10, at 23:30, mysql-digest-h...@lists.mysql.com wrote: > From: "Daevid Vincent" > Date: 14 November 2010 13:22:02 PST > To: > Subject:

Error Unknown column in 'where clause'

2010-11-16 Thread Tompkins Neil
Hi I've the following query : SELECT players_bids.players_bids_id, players_bids.players_id, players_bids.bid_date, players_bids.bid_type, players_bids.bid_value, (SELECT SUM(IF(home_users_id = players_bids.users_id_from,home_manager_points,away_manager_points)) FROM fixtures_results WHERE (home_u