Query the database column (x1, y1) in the first row x2, y2 values of the same line, and return enthandle value

CodePudding user response:

Query the database column x1=y1 x2 value in the first row and column fields=y2 values in the first line of line, and return enthandle value

CodePudding user response:

Select * from vanshubiao where x1 x2=and=y1 y2

CodePudding user response:

Select number From cansubiao Where x1 In (Select x2 From cansubiao Where id=160) And y1 In (Select y2 From cansubiao Where id=160) And serial number & lt;> 160

CodePudding user response:

reference of123 reply: 3/f

Select number From cansubiao Where x1 In (Select x2 From cansubiao Where id=160) And y1 In (Select y2 From cansubiao Where id=160) And serial number & lt;> 160

Extract: if I want to visit the x2, y2 and put them to array, how to do, and the select whether can only return to a record, if return to multiple records, is used to record set