mysql - How to workaround selecting multiple columns inside a single case expression -

-

I am thinking that if there is a way to select two columns based on the outcome of a statement.

Even so I have so far (I have reduced half the amount of unnecessary stuff): 

  (Select IF (Select user. I.I. (G.ID = u.group_id) WHERE u.id = 2)> = 4, (SELECT p.action, p.id permissions as p, WHERE p.required_points & lt; = ( Choosing reputation from users WHERE id = 2)), (SELECT 0, 0)))   
 In fact, is there any number of columns operands that behave like statements? And if so, how do I apply them?  
 1241 - Operand must have 1 column (s)  
 Entire SQL query:  
  (SELECT p1.action, user_primation from p1.id Add permissions as AS u1 INNER P1 ON (P1id = u1.action_id) WHERE u1.user_id = 2) Union (SELECT p2 .action, p2.id users by U2Inner User User Group AG on (live) .ID = U2Grap_ID) Join Inner GOP On (GPIGP.Group_ID = G.Id) Inner P2On (P.ID) = GP.action_id) where U.ID = 2) Unions (selection) Do it U (In the United States user group ASG2 ON (G.ID = U3 NCHGID) where U 3. id = 2)> = 4, (SELECT p3.action , P3.id permissions from p3 WHERE p3.required_points & lt; = (select reputation users from WHERE id = 2)), (SELECT 0, 0)))    
 
 Oh, this is basically the entire query. It will not work:  
  Select (SELECT g2. Id users from U3 Inner UserGroup ASG2 ON G 2.ID = u3.group_id WHERE U.ID = 2) & gt; = 4, (SELECT p3.action, p3.id permissions from p3 WHERE p3.required_points & lt; = (select reputation users WHERE id = 2)), (SELECT 0, 0)))   
 Therefore, just move from one  to  for the clause:  
  SELECT (in case when g2.id> = 4, p3.action, 0), (Case when g2.id> = 4, p3.id, 0) (Select from users g2.id as 3 of these user groups on G2 g2.id = u3.group_id WHERE u3 .id = 2) G2 Cross Join (P3.action, p3.id from permissions from p3 WHERE p3.required_points & lt; = (selection of prestige users WHERE id = 2))) P 3   
 If you really do not want to have row with  (0, 0) , but this is just what some other value is, then  Join  or  where  filter it:  
  SELECT p3.action, p3.id FROM (SELECT p3.action, p3.id permissions, p3 WHERE P3 .required_points & lt; = (selection of users where ID = 2)) P3 where users (user by these user user user group ASG2 ONG 2.ID = u3.group_id WHERE U.ID = 2) & gt; = 4

Comments

Post a Comment

Popular posts from this blog

php - PDO bindParam() fatal error -

-
I am trying to learn PDO, now I have written this small code, but it gives me a serious error: Fatal error: Call a member function at a non-object dot () ... $ con = new mysqli ("127.0.0.1", "root", "", "csvdangercheck"); $ Query = $ con- & gt; ("Id,` var1`, `var2`) values ​​(" id,: var1,: var2) ";); $ query- & gt; bypass pattern (': id', $ id); $ query- & gt; BindParam (': var1', $ VAL1); $ Query- & gt; bindParam (': var2', $ val2); $ Query-> Executed (); I Trying to use print_r ($ con-> errorInfo ()) but Fatal error: Undefined method mysqli :: errorInfo ( ) ... can someone tell me what am I missing? Flaffeh said, you have PDO Missing Mysqy, try it: $ con = new PDO ('mysql: host = 127.0.0.1; dbname = csvdangercheck', 'root', '');
Read more

php - How can I cram 6+31 numeric characters into 22 alphanumeric characters? -

-
I have a 6 digit number and a 31-digit number (such as "234536" and "201103231043330478311223582826") that I The API needs to be crawled in the same 22-character alphanumeric field that uses PHP. I tried to convert each one to 32 (using custom code could not handle the base_convert () large number) and to connect with a single-character delimiter, but It only gives me 26 characters This is a restore API, so the letters should be URI-protected. I would like to do a database table cross with two references without reference to another reference value, if possible, any suggestions? Instead use a radix of 62. This will give you 22 characters for the top, 3.35 for the pre and 17.3 for the next. & gt; & Gt; & Gt; Math.log (10 ** 6) /math.log (62) 3.3474826039165504 & gt; & Gt; & Gt; Math.log (10 ** 31) /math.log (62) 17.295326786902177
Read more

logging - How can I log both the Request.InputStream and Response.OutputStream traffic in my ASP.NET MVC3 Application for specific Actions? -

-
For a specific set of tasks, I need to log in to the incoming request inputstream as well as outgoing response. is. I am using an ActionFilterAttribute for this and overriding the OnActionExecuted and OnResultExecuted methods. So I'm starting with this idea ... Public category ActionLoggerAttribute: ActionFilterArrbit {Public Override Zero On-Offed Execution (ActionActioned Contact Filter Filter) {base.OnActionAxecuted (FilterContext); HttpRequestBase request = filterContext.HttpContext.Request; // TODO: Log the request. InputStream} Public Override Zero OnResultExecuted (ResultExecutedContext FilterContext) {base.OnResultExecuted (filterContext); HTTPRPSPointBase Response = FilterContacts Hpptex response; // TODO: Log on Response.OutputStream}} Ideally I'll hook it up with enterprise library logging because I'm already using it for error logging. Am I reaching the input and output stream at the right time? Can I easily use the Enterprise Library to log i...
Read more