| |
| |
| |
|
Page: 1 2 3 4 5 6
Comments:
<0> in mysql 5
<1> WHAT?
<1> dude THIS is why we dont support mysql
<2> that's what i'd do in mssql, but i don't know mysql
<3> humm, just sleect NULL for the other fields?
<4> mysql seems pretty much the same in my experience
<4> a few different types, that's about it
<0> oh can i select invalidtype as NULL ?
<3> UNION SELECT a, b, NULL c, d, NULL e
<3> etc
<2> null as invalidtype
<3> yep
<2> in mssql
<0> oh cool
<0> thanks
<0> wait
<0> so like SELECT a, b, c UNION SELECT a, b, c as NULL ?
<2> try it and see!
<1> lol
<0> or: SELECT a, b, c UNION SELECT a, b, NULL as c
<3> hahahahahahhaa
<1> MuteThis: theres a reason the rules say no MySQL
<3> dont you need FROM ?
<3> or maybe its optional and mysql just guesses the table
<1> upb: nope... they are overrated
<0> sorry FROM
<0> but you get the point?
<5> why is there such hatred here towards mysql? i generally use mssql or pgsql, but mysql seems to have proved itself. Is it just the general newbishness of the people that mysql tends to attract?
<2> SicLuDe: i know, but since i'm not an op, i don't mind taking a stab at mysqql questions...
<0> SELECT a,b,c FROM fulltable UNION SELECT a,b,NULL as c FROM tablewithoutc
<0> will that work?
<2> try it and see
<6> sqlserver: i need to insert a record from that same table itself, with one field only changed. how ?
<6> INSERT INTO table1 SELECT TOP 1 * FROM table1
<2> Nineth: insert into me (col1, col2) SELECT col1, 'foo' FROM me WHERE pk = blah
<6> but there is one identity field. and I need to update the date field to getdate()
<2> Nineth: insert into me (col1, col2) SELECT col1, GETDATE() FROM me WHERE pk = blah
<6> but there are about 25 fields. I cant write all.
<2> yep, you can
<6> how ?
<2> SELECT col1, col2, colx
<6> :( .. i have to write 25 columns ou mean ?
<6> also there is a chance of changing database tables from time to time.
<2> yep, you do
<7> Welcome to the world of databases.
<6> o_O
<2> there are ways...
<1> Kaine[]: yes its the general newbishness
<7> We have ways of making you talk.
<5> ok i can buy that then :>
<2> you could use a cursor iterate over the tables columns, build up a string, exec it, but lets just say you use a hard coded approach for now
<6> ok
<5> mysql has cursors? :P
<1> MuteThis: stop giving bad ideas
<1> :)
<2> :D
<1> Kaine[]: he is using mssql
<5> ah
<2> its what i do best
<5> pretend cursors dont exist
<6> :|
<1> select @sql = @sql + name + ', ' from syscolumns where id = object_id('mytable')
<1> see .. no cursors
<1> :)
<8> hehe
<1> cursors are BAD
<1> avoid them at all costs
<2> booo
<8> the WHILE construct is very nice
<4> heh
<1> TheGamble: ill deny it if you quote me but ... i have seen instances where cursors outperformed while
<1> it was a sad day
<0> thanks mute
<0> worked great
<2> yep
<8> SicLuDe, I believe it, because sometimes the WHILE requires "hacks" at times
<4> i've played with msde, pgsql, mysql and mssql (we'll not mention access and flatfile), the first 3 are actually pretty decent especially if used where appropriate
<2> another satisfied customer ;)
<4> anywho, enough of that
<1> MadScribe: i have nothing against mysql.... i use it myself
<1> its pretty nice actualyl
<1> its really good for a free db
<1> the problem is that its a free db...
<1> so any newbie thinking "hey ill learn databases today" will be using mysql
<1> well thats a generalized statement
<4> heh
<1> but you do get a lot of newbie questions from mysql
<4> most general statements are
<1> and people who dont know how to help themselves
<9> its because every crap open source "program" uses mysql, so the problem gets prograted
<7> MySQL managed to generate a lot of hype around itself, which is a shame because they distracted users away from pgres.
<10> dunno what you hate MySQL that much
<1> never use pgres
<10> nope
<2> !bash mysql
<10> mysql is quite a good dbms, especially with its new features
<10> sps and all
<10> MsSQL is too monpolistic
<2> mssql costs too much
<7> MySQL is a lousy DBMS
<7> And there are plenty of DBs, Microsoft does not have a monopoly on that market.
<10> mute thats one of my points :)
<7> pgres is free, and isn't a huge flaming pile of goat turds like MySQ:
<7> MySQL
<2> you guys using mssql? have you seen this? http://www.promptsql.com/ its' pretty cool
<10> how's firebird then?
<7> I've not used Firebird
<10> never had the chance either
<1> i got no complains against mysql
<1> its good for what its made for
<7> binary files are even better
<1> its not mature enough to be a great rdbms yet though
<10> 3/4 of the sites I've done so far are with MySQL backend, and it never failed me
<1> Bronso: again.. it depends on what you are using it for
<7> MySQL took the approach of ripping out all of the integrity features of an RDBMS to claim performance, then they openly compared themselves to modern RDBMSes claiming superiority, and now are trying to hack back in the integrity features which they purposely ripped out to begin with.
<7> In other words, it's crap.
<1> if you are using it to just do real basic db activity its fine
<10> Sic correct. MsSQL is better, sure, but costs money and you don't always need all its features
<7> pgres is better and doesn't cost money
<10> Halo is it TSQL compatible?
<10> never seen a single line of code for it
<7> Of course not. T-SQL is specific to MSSQL and Sybase.
<10> how different is it then?
<7> As different as two DBs typically are.
<10> and what the hell is the thing with warez channels?
<1> all i gotta say is that i dont like oracle :)
<1> mssql has hte best client tools
<7> This channel is occupied by professional software developers, not scriptkiddies.
<7> We get paid for our software, therefore we have an aversion to people who warez software.
<0> i agree
<10> whatever
<0> buy software
<0> because Jesus said do not steal
<1> didnt he also say something about burning people and **** in his name?
<1> jesus was an alcoholic
<10> I published a CD a while ago - archive with a search software of mine, and didn't care too much if ppl stole it
<7> Good for you.
<10> yep
<10> the good life
<7> You got to make that choice because of how copyright law works. Other people get to make their own choice about how their software is to be distributed.
<7> If you don't like it, ****ing tough.
<10> ya well
<10> gtg, catcha later
<1> lol
<1> pick your battles Bronso
<10> screw you
<10> :)
<11> hehe
Return to
#sql
or
Go to some related
logs:
#beginner
#stocks
#cisco
#windows
#worldcup
#nhl
osakagirls serial
#networking
#freebsd
#delphi
|
|