SQL Server vs MySQL

jennyliana SG

???? then can anyone tell me what is the platform independence of SQL Server and MySQL? Really appreciated. Thanks alot. Very Happy

thoreldan SG

MySQL can run in linux / windows / etc

MSSQL can only run on MS platform

i am surprised that you cant even do simple search and wants people to spoodfeed you

BrUtUs SG

mysql free(if not wrong)...

dumbdumb! SG

i did oracle Sad

thoreldan SG

it's almost impossible to list all the features + differences between the 2 products

TS: pls spend some effort doing research on the net...tons of info to compare these 2 DBMS product

thoreldan SG

why the Crying or Very sad ?

you know companies are willing to spend top dollars on hiring experienced Oracle DBA ?

jennyliana SG

Ok..Ok..I got it. Thanks guys…

ndmmxiaomayi SG

You aren't going to get answers this way.

First thing first.

Do you know what's a server?

Second thing - Do you know what's DBMS? If you don't know what this acronym means, Google it.

Third thing - What's SQL?

Shotgun SG

SQL is something I HATE A LOT.

Seriously, is there a better the way to create an SQL statement in JSP other than

',"+string+"blah = "'+string2+' "Where soNso= '"+string3+"';";

I have to write so many " ' , and ; until i see also blur. ARgh

***No, im not playing with SQLInjection on this forum ***

ndmmxiaomayi SG

I do that a lot for PHP too. But without the + signs. I don’t remember using + signs much except when doing additions.

LatecomerX SG

Use prepared statements. Save you some trouble and your code from SQL injections as well.

LatecomerX SG

Because can like this ma:

Shotgun SG

Some examples? Do i have to code a new class?

I need to address the SQL injection problem as well. Was playing with the idea of using javascript to screen out all the ; ' etc... but just the thought of it gave me a headache cos JS doesnt have a compiler to check errors.. =/ Best thing i got is firebug.

**currently working using netbeans 5.5**

ndmmxiaomayi SG

Ya, and I find it very sickening. Hand pain to type. Can I have a cleaner syntax like Python? Mr. Green

LatecomerX SG

I suppose JSP has a PreparedStatement class.

http://visualbuilder.com/java/jdbc/tutorial/pageorder/6/

But anyway, for PHP, the MySQLi class has a prepare() method that allows the programmer to create prepared statements.

http://sg.php.net/manual/en/function.mysqli-prepare.php

ndmmxiaomayi SG

Argh

Why I never see this function before. Can save me.

Shotgun SG

So this saves me from SQL injections??? WOO!! THANK YOU!!

dumbdumb! SG

haha cuz they are looking for experienced! hahaha

« Previous Page