Novice, please guide, a great god a look-CodePudding

//remove the database user password in the table corresponding to the user's password
The SELECT user_PWD, purview INTO: CORRECT_PSWD, : G_right FROM USER_info
WHERE user_id=: G_USER or username=: G_USER;

This piece of code INTO: the colon CORRECT_PSWD is what effect??

CodePudding user response:

The

refer to the original poster u011722433 response:

//remove the database user password in the table corresponding to the user's password
The SELECT user_PWD, purview INTO: CORRECT_PSWD, : G_right FROM USER_info
WHERE user_id=: G_USER or username=: G_USER;

This piece of code INTO: the colon CORRECT_PSWD is what effect??

Note: for a variable of PB, after will put the value of the corresponding to the variable

CodePudding user response:

Retrieve data from a database, stored in the variable

 
The SELECT user_PWD, purview 
INTO: CORRECT_PSWD, : G_right 
The FROM USER_info 
WHERE user_id=: G_USER 
The or username=: G_USER;

Is through the user name or user ID from "USER_info" table to retrieve the user's password stored into CORRECT_PSWD variables,
This section of the statement execution is successful, CORRECT_PSWD the value of the variable is the user's password,

CodePudding user response:

Upstairs is a positive solution,

CodePudding user response:

Is fixed usage of SQL, said to take to write the value of the variable

CodePudding user response:

The grammar of the PB is this,

CodePudding user response:

Pb in writing the SQL statements directly, can query the data saved in the variable you want to save for you below, behind that colon is to explain the colon is a variable that can store data, can also be used as the query in the SQL statements where conditions, no matter how, pb and SQL statements for as long as variables in the SQL statement, all have to use a colon

CodePudding user response:

Is fixed usage of SQL, said to take to write the value of the variable

CodePudding user response:

Long knowledge

CodePudding user response:

Assignment is to transform the SELECT user_PWD, purview INTO: CORRECT_PSWD, : G_right FROM USER_info
WHERE user_id=: G_USER or username=: G_USER;
Query the user_PWD purview respectively assigned to: CORRECT_PSWD, : G_right
Is to add in pb: to assign a value, there=: almost the same is true of,

CodePudding user response:

: a variable name is this PB fixed method
As TSQL (used) in the local variable method is @ the variable name all variables are @ @ variable name
Example select userid into @ userid from the user;
Up SQLPLUS (oracle) is directly variable name
Cases of the select userid into user_id from the user;
Take in PB userid is
The select userid into: user_id from the user;
If it's taking account
Select the username into: user_name the from user where userid=: user_id;

CodePudding user response:

The basic syntax, this in to help

CodePudding user response:

Almost four months, also not to knot, also often see someone to DingTie