Extracting data from MySQL into Access
Hi, I know this is a weird request, but I need a tool / tutorial on extracting data from InnoDB tables in MySQL 5.x and putting the data into Microsoft Access. COuld anybody advise me where to do this? Thanks, Dewald Troskie
RE: 1' and '1' or '1
What page architecture are you using: PHP, ASP, .Net 1.1 or .Net 2.0 or are you using one of the standard CMS packages (Mambo, Plone, etc) ?? If you are using ASP.net 2.0 with MySQL (I am using this), I have managed to implement the Membership / Role providers in my site using MySQL as the provider. Using the login credentials you supplied, The site rejects it as you have to have explicit username and password (which is encrypted on creation in the DB) details to login. HTH, Dewald Troskie GIS Developer / Database Architect GIS Global Image (Pty) Ltd. Helping the world make informed decisions P.O Box 15 The Innovation Hub 0087 Cell: +27 (0)72 685 4246 Tel: +27 (0)12 844 0660 Fax: +27 (0)86 619 3958 Email: [EMAIL PROTECTED] Web: www.globalimage.co.za Web: www.mapme.co.za Blog: http://electronucleus.blogspot.com/ Registered Linux User No: 371874 Office L15 Enterprise Building The Innovation Hub - Hotel Street Lynnwood, Pretoria, 0087 The are 10 kinds of people, those who understand binary and those who don't -Original Message- From: Critters [mailto:[EMAIL PROTECTED] Sent: 10 May 2006 10:53 AM To: mysql@lists.mysql.com Subject: 1' and '1' or '1 Hi A user was able to log into my site using: 1' and '1' or '1 in the username and password box. I ran the query SELECT * FROM members WHERE name = '1' and '1' or '1' AND password = '1' and '1' or '1' And it returned all rows. Can someone explain to me why this happens, and if the steps I took (replacing the ' with a blank space when the user submits the login form) is enough to prevent a similar hack Appreciate any feedback. -- Dave -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: comparing postgis with mysql
Hi, I'm a GIS developer, who specialises in the architecture of geospatial databases. PostGIS (a derivitive of PostGreSQL) has been developed with spatial data in mind, and as such is primarily for this use. I have tried MySQL with Spatial extensions, whose implementation is very good I must say, but on doing stress and load tests PostGIS definitely comes out a winner. If you have small spatial databases, I would recommend MySQL though as it is definitely easier to use and implement in my experience. I will try locate some comparison charts and find my comparison tests I have done myself on these two DB's and mail them to you. Thanks, Dewald Troskie GIS Developer / Database Architect GIS Global Image (Pty) Ltd. Helping the world make informed decisions P.O Box 15 The Innovation Hub 0087 Cell: +27 (0)72 685 4246 Tel: +27 (0)12 844 0660 Fax: +27 (0)86 619 3958 Email: [EMAIL PROTECTED] Web: www.globalimage.co.za Web: www.mapme.co.za Blog: http://electronucleus.blogspot.com/ Registered Linux User No: 371874 Office L15 Enterprise Building The Innovation Hub - Hotel Street Lynnwood, Pretoria, 0087 The are 10 kinds of people, those who understand binary and those who don't -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Parang Saraf Sent: 09 May 2006 10:06 PM To: mysql@lists.mysql.com Subject: comparing postgis with mysql hello, I am relatively new in this field. I am designing a database to store the events extracted from the oceans. This project later demands of publishing data on web. I am not able to decide which database to use. Mysql with spatial extension or the postgis one. I would prefer to use windows platform. Can someone suggest or can provide me with some links that compare the two databases. Do you think Mysql has a better spatial elements handling capacity in comparison to postgis.? please reply soon. Thanks and Regards Parang Saraf [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Table parameters not transferring while using Migration toolkit
Hi, When I use the MySQL Migration Toolkit to transfer a Database from one Mysql server to another, the table parameters configured do not seem to be transferred as well. Fields specified as Primary keys that autoincrement do not autoincrement in the transferred database and fields set as null fields with default values all of a sudden show as NOT NULL. I'm using MySQL Server 5.0.11 and Migration Toolkit 1.0.21rc. Any suggestions / ideas as to why this is happening (the transfer is done online, so all objects and data is moved online and not scripted). Thanks, Dewald Troskie GIS Developer / Database Architect GIS Global Image (Pty) Ltd. Helping the world make informed decisions P.O Box 15 The Innovation Hub 0087 Cell: +27 (0)72 685 4246 Tel: +27 (0)12 844 0660 Fax: +27 (0)12 844 0668 Email: [EMAIL PROTECTED] Web: www.globalimage.co.za Web: www.mapme.co.za Registered Linux User No: 371874 Office L15 Enterprise Building The Innovation Hub - Hotel Street Lynnwood, Pretoria, 0087 The are 10 kinds of people, those who understand binary and those who don't
Data type in MySQL / ASP.net
Hi, I'm relatively new to the MySQL / Web development - database environmeent, having moved from Microsoft SQL. Just two questions ? 1. I have an ASP.Net page that commits data to a MySQL database. I have several check boxes on the page. What data type do I define my fields in the database as (similar to a boolean value) to write a checked value. 2. I have a foreign key field in the database. On the web page I have a drop down list populated by the text value from table in the database that the foreign key refers to. How can I convert this to a integer reference in the page so that I can write the foreign key. Thanks in advance, #dewald.troskie #gis.developer #gis.global.image.(pty).ltd #helping.the.world.make.informed.decisions #p.o.box.15.the.innovation.hub.0087 #(c)+27.(0)72.685.4246 #(t)+27.(0)12.844.0660 #(f)+27.(0)12.844.0668 #(e)[EMAIL PROTECTED] #(msn.im)[EMAIL PROTECTED] #(w)www.globalimage.co.za #(w)www.mapme.co.za #registered.linux.user.no:.371874 #office.L15.enterprise.building #the.innovation.hub - hotel.street #lynnwood.pretoria.0087
