| |
| |
| |
|
Page: 1 2 3 4 5
Comments:
<0> has a few practical examples and such
<1> I think I saw that at the bookstore today
<0> I think it's about 50 dollars
<1> and what programs will I need to get in order to get full use of the book?
<0> Apache, PHP, MySQL
<0> that's all
<0> that and a text editor
<1> Well, I have the webserver that supports php and sql.. so I won't need those would I
<1> ?
<0> again, your web server does not "support sql"
<1> sorry mysql
<2> http://www.apachefriends.org/en/xampp-windows.html < -- apache mysql php 5.11 and phpmyadmin for windows.
<2> you can edit locally if yyou want...
<2> anything else, goto #mysql for. not here
<1> yeah my problem was I didn't realize there was a difference between sql and mysql :/
<1> ty though guys
<1> for being patient
<0> what[cs]S, well, SQL is a language; Access, MySQL, FoxPro, Oracle, DB2, etc. are databases
<0> there are no "SQL databases"; there are databases, and there are programs which process SQL queries to manipulate the databases or data within them
<1> gotcha :P
<0> Hell, if you had enough free time, you could write your own query processor and language for MySQL's files :)
<3> round deux
<4> Hello I am using a postgresDB, and I have a little SQL question. I want to create a foreign key, but I dont know if I make the foreign key in the table I want stuff to cascade to or from? Sorry about the basicness of my question, but I would love some help.
<5> i set the foreign key on the table that has the foreign key column
<5> you set*
<4> Oh Okay thanks.
<4> that makes alot of sense.
<4> :)
<6> does mysql support paramaterised queries?
<2> goto #mysql
<6> mysql is still sql
<2> no mysql here
<7> ok, what the **** kinda whitespaces are they when Ltrim() and rtrim() do not work?
<7> mssql2k
<5> quant; whats the help say
<7> meh, i accidently had char datatype instead of varchar....lame
<8> yar
<9> hey guys
<9> what's wrong with this statement
<9> "SELECT * FROM firstnames ORDER BY rand() LIMIT 1"
<9> the error is: Incorrect syntax near 'LIMIT'.
<10> works for me
<10> select * from tblPrizes ORDER BY rand() limit 1
<11> Rossignol : 'limit' is mysql specific
<9> oh.
<9> hm, how would I return a random entry from that table then?
<9> NEWID()
<9> ..
<9> ;)
<9> got it
<12> I'm in many-to-many hell
<12> alchemy database for Oblivion because I'm a geek, ingredients each have 4 effects, you combine various ingredients with common effects to create a potion
<12> like if ingredient A has effects 1, 4, 6, and 8, then it can combine with ingredient B that has effect 1, 3, 7, and 9
<12> I have 4 listboxes, when you click an effect in the first one, it will list all the OTHER effects that can be obtained by mixing it with other ingredients
<12> so in the A/B example, the second list box would list 3, 4, 6, 7, and 9
<12> I've got a tblIngredients with fldID, fldName. tblEffects with fldID, fldEffect. and tblLnkIngredientEffect with fldIngredientID and fldEffectID
<12> anyone have any clue how to write the query to set the second listbox?
<12> nm, took a lucky guess... SELECT DISTINCT fldEffectID FROM tblLnkIngredientEffect WHERE fldIngredientID IN (SELECT fldID FROM tblIngredients i INNER JOIN tblLnkIngredientEffect l ON i.fldID = l.fldIngredientID WHERE l.fldEffectID = 3)
<10> good guess
<12> all luck
<12> I googled Many-to-many and the first hit was something unrelated, but mentioned the IN keyword
<12> ugh missed an inner join in there to get the name of the effect, what an ugly *** query
<11> AlmtyBob : **** sql for this, do it in real code...
<11> AlmtyBob : oh, and let me have a copy when you're finished - oblivion fan here too
<12> hehehe
<12> I'm doing alright with sql so far
<12> many to many's still ****
<12> I dumped 40 hours into that game on Wed/Thu
<12> my days off
<12> another 6 tonight
<12> if I get really obsessed I'll screenshot all the ingredient sources
<12> just for ****s and giggles
<12> I'm doing a make potions by effects form, I probably should have done make potions by ingredients first, woulda been a hell of a lot easier
<11> AlmtyBob : i'm happy to help out if i can share in the results
<11> AlmtyBob : what are you using for the code? php? c#?
<12> ...access 8/
<12> (vba)
<12> I can give you csvs of the data I have
<11> ms-access? oh dear...
<11> i can see why you want to do it in sql
<12> 8)
<12> I like vba actually
<12> just thought it'd be cleaner in sql
<12> I'm thinking the sql is going to look mighty ugly by the 4th ingredient
<12> might be easier to mix up the sql with some ADO in code
<12> hmm, and I might be able to do it with just one multiselect listbox each for ingredients and effects
<12> damn
<12> I'm starting to see the code in my head but I should have been asleep 2 hours ago 8/
<13> hello, is there i can ask something about DTS ?
<13> so... how can i make a task where i select lignes with (id,name,firstname,address) and update another databes with 3 tables like user,address,link_user_address ?
<14> http://sql-servers.com/nopaste/?show=497
<11> WHAT ERROR?
<14> 1 sec
<14> Error Type:
<14> Microsoft JET Database Engine (0x80040E14)
<14> Syntax error in UPDATE statement.
<14> Line 177, with has conn.execute sql
<14> I wrote the strings content, and tried to execute it in access, it worked fine
<14> YuppieScm ?
<14> is image a reserved word ?
<14> yes it is :D
<14> thanx for your cooperation
<11> back
<11> oh
<11> oh well
<3> heh
<15> mssql2005, whats the best way to check if a trigger is fired because of an insert,update,delete: if exists(select * from deleted) and exists(select * from inserted) --- updated ?
<3> maybe watch it in profiler?
<15> me? i meant im creating a trigger and i want to know if it fired because of an insert, update or delete
<3> oh
<3> haha
<3> on insert
<3> on delete
<3> etc
<3> so like : on insert(columnname) begin... end
<3> er
<3> maybe thats not it
<3> i'm not sure if theres a like "on update" clause
<15> doesnt work
<15> only way with sql200 atleast was to check inserted, deleted
<16> morning all folks
<3> well worst case is write trigger for each.. an on update trigger, an on insert trigger...
<16> i have been meaning to tell my super to break down and normalize some of the tables... but he insisted me on using triggers for some of the data constraints
<16> gosh...
<3> oh hah im so baked.. i know how you can tell imnae
<3> you have the virtual tables inserted and deleted
<3> if an update occured the primary key for the table will exist in both tables.. if an insert it will only exist in inserted etc...
<17> you on crack, phargle ? Hes already doing what you just researched and found out how to do
<17> he wants to know if there is a better way in sql2k5 =P
<16> gay...
<16> go to http://autodesk.recruitmax.com/ENG/candidates/ and type "*" for the keyword
<11> poor
<18> d2d_w0rk: that's a common error, they should handle that better (obviously), try for example searching on the, in, is, it.. i mean come on you can't search on IT....
<4> Does any one know if postgresql supposts the MINUS sql command?
<19> I bet the guy who wrote the help file or online help does
<4> Well I cant find it.
<19> Then I'd bet it doesn't support it
<7> what's a MINUS sql command
<19> yeah, that's a good question as well
<4> Oviously you people never took a cl*** in set thoery.
<19> obviously we're dealing with existing products
<19> obviously none of those implements the MINUS command
<20> http://www.google.com/search?hl=en&lr=&q=postgres+minus+sql+syntax&btnG=Search
<7> lawl
<7> off with him or what?
<21> quant seriously
<21> stop saying "lawl"
<21> it looks too much like "law"
<7> i am not saying it, i am typing
<21> and saying "law" is just gay for no reason
<21> i'll smack the black out of you :(
Return to
#sql
or
Go to some related
logs:
#linuxhelp
#gamedev
nsol.ob
#freebsd
corrupt driver database
nwes in france
#qmail
#visualbasic
#beginner
#beginner
|
|