| |
| |
| |
|
Page: 1 2 3
Comments:
<0> thank you for your help. it solve my problem
<1> INSERT INTO table1 (f1, f2, f3, f4, f5, f6) VALUES (1,x,x,x,x,x);
<2> oh ok
<1> mihai399: You're welcome.
<2> hm
<2> also if i dont want any field
<2> i can just do a SELECT FROM ?
<1> No. That's not valid. What purpose would that serve?
<2> to see if a row exist ?
<1> Fr3DBr: Ah. You must SELECT something.
<2> oh
<2> like one field
<2> that isnt much important
<2> right?
<1> Fr3DBr: SELECT 1 FROM table1 WHERE EXISTS (SELECT ...)
<2> ye
<2> SELECT tu_state FROM t_user WHERE tu_aid='10'
<1> Replace table1 with whatever you wish. In Oracle, that could be dual.
<2> would work fine
<1> Sure.
<2> hm
<2> also this insert tip you told me prevent from sql injection too ?
<1> Fr3DBr: No. It doesn't prevent injection.
<2> i see
<2> SELECT GID FROM charinfo WHERE GID='0' that works?
<2> considering alot of queries per second
<2> selecting specific fields can be faster than selecting *
<2> correct?
<2> because im just looking to optmize my queries as much as possible
<2> im using mssql
<1> Fr3DBr: That's not a simple question to answer. It can be faster. Certainly.
<2> cool
<2> well
<2> it will be better than using a * for sure
<2> hehe
<2> i already changed all * to only the needed fields
<2> :-)
<2> can insert timeout ?
<2> even if its a easy query?
<1> Timeout? Not via standard SQL.
<2> i see.
<3> hello to everybody!!!!!!
<2> hello.
<3> i have a question
<4> bye then
Return to
#sql
or
Go to some related
logs:
Symbol Undefined _SDL_strlcpy
gentoo lsdev
rebuild-rebuild gentoo
#oe
libnetfilter_queue man page
#fluxbox
#php
#perl
#css
CPU frequency scaling not supported ubuntu
|
|