| |
| |
| |
|
Page: 1 2 3 4
Comments:
<0> is sub select different from a sub query?
<1> no
<2> a select is a query
<0> can i use the phaze value in the subquery?
<2> possible
<1> select * from foo where val = (select max(val) from foo where blah blah)
<3> i have heard the other day that you can get an SQL database to do things sort of like a programming language, writing functions that then will do a multitude of tasks. is that true, and if so, could anyone tell me a/the term so i can look it up and read about it ?
<4> Is there a way to make a trigger maintain old data before someone tries to update? For example, the user calls an UPDATE, the trigger fires, says "no you cant do that", and leaves it as the old data?
<1> that sort of thing you mysql using dufus
<1> [twisti]: yes, it's true. you want to look up "stored procedures"
<3> thank you
<1> Fenrisulf: you want to use a constraint instead
<0> rmah
<3> i ***ume thats pretty standardized and not database related ? as in, can i google for it without having to specify which database i use ? because i dont use one, im just curious
<1> [twisti]: yes, "stored procedure" is a generic term
<0> im selecting from three tables... i cant subquery like that or it will always grab the same "max phase"
<1> thun: this is why we don't allow discussion of mysql here
<0> why
<3> thanks again :)
<1> because the fact that you're joining has nothing to do with your "problem"
<0> well it kinda of does... it's not as simple as it looks at first glance
<1> ok, you have three tables: customer_data, customers and phases
<1> how is customer_data related to customers?
<1> ahnd wtf is "phases"?
<0> each customer can have up too 5 phases
<0> phases is a seperate table
<1> I noted that iwas in a seperate table already. my question is: what is a phase?
<1> erm, s/iwas/it was/
<0> as a deal progress'
<0> oops progresses it moves thru the phases...
<4> is there a way for triggers to prevent or change the data going in before an update or insert?
<1> thun: ok
<0> so a deal starts in phase 1 then advances... each phase has alot of data ***ociated with it
<1> thun, so how does phase relate to cutomers?
Return to
#sql
or
Go to some related
logs:
sql2k database alias
PrivateGlamour
#beginner
#stocks
#windows
#fedora
annoypriv
mce/tpc
#cph
Shane Doan + cock
|
|