Ujjwal's Blog: mysql

provide-free-support Ujjwal's Blog: mysql

Showing posts with label mysql. Show all posts

Showing posts with label mysql. Show all posts

Wednesday, June 26, 2013

Best Way to Export billions of rows from Oracle, DB2, MSSQL, MySQL, Teradata, Netezza, Sybase, PostgreSQL

Hi All.

The best way to export large volume of data from Oracle (or any other databases) to CSV is by DBCrane (http://www.bronzeage.us/downloads.html). Toad is not designed for large data volume. DBCrane is also many times faster than sqlplus/spool or utl_file and it doesn't require any coding. We use DBCrane to export billions of rows from Oracle, SQL server and Netezza into delimited files and the process is done in less than one hour.

I tried Util_File package but it failed, then i tried CSV Exporter library for Java, but it failed as well. But DBCrane did this job well.

Cheers,

Ujjwal Soni

Tuesday, September 6, 2011

How to Protect Against MySQL Injection on User Login Form

The below mysql database query is to to protect your database against MySQL injection through user login forms. This preventive action make spammers stay away from running the database query on your database with out your knowledge

Query to Protect Against MySQL Injection via Login Form

$username = stripslashes($username);
$password = stripslashes($password);
$username = mysql_real_escape_string($username);
$password = mysql_real_escape_string($password);

Cheers,

Ujjwal Soni

-- In Dreams And In Love There Are No Impossibilities --

Subscribe to: Posts (Atom)

best-it-exam- | for-our-work- | hottst-on-sale- | it-sale- | tast-dumps-us- | test-king-number- | pass-do-it- | just-do-it- | pass-with-us- | passresults-everything- | passtutor-our-dumps- | realtests-us-exam- | latest-update-source-for- | cbtnuggets-sale-exam | experts-revised-exam | certguide-sale-exam | test4-sale-exam | get-well-prepared- | certkiller-sale-exam | buy-discount-dumps | how-to-get-prepared-for-the | in-an-easy-way | brain-dumps-sale | with-pass-exam-guarantee | accurate-study-material | at-first-try | 100%-successful-rate | get-certification-easily | material-provider-exam | real-exam-practice | with-pass-score-guarantee | certification-material-provider | for-certification-professionals | get-your-certification-successfully | 100%-Pass-Rate | in-pdf-file | practice-exam-for | it-study-guides | study-material-sku | study-guide-pdf | prep-guide-demo | certification-material-id | actual-tests-demo | brain-demos-test | best-pdf-download | our-certification-material | best-practice-test | leading-provider-on | this-course-is-about | the-most-reliable | high-pass-rate-of | high-pass-rate-demo | recenty-updated-key | only-for-students-free-download | courseware-plus-kit-for | accurate-answers-of | the-most-reliable-id | provide-training-for | welcome-to-buy | material-for-success-pass | provide-free-support | best-book-for-pass | accuracy-of-the-answers | pass-guarantee-id | pass-exam-key | pass-sku-id | study-for-exid | pdf-sku-exid | sku-pdf-id | pdf-demo-key | exam-demo-ske | pass-it-dump |

http://www.menuiserie-dauvergne.com/ | http://www.menuiserie-dauvergne.com/ |