Home > database >  Mysql table how to let the user name and the hotel name is converted into digital (there are repeate
Mysql table how to let the user name and the hotel name is converted into digital (there are repeate

Time:09-26

CodePudding user response:

Create a user table and hotel information table, the two tables have on the ID, it is ok to save the two ID, if you want to display name, you are associated

CodePudding user response:

Good advice, thank you

CodePudding user response:

Group respectively name and username and then give the corresponding Numbers, add code in your code list,
Then use the update it is ok to make changes,

CodePudding user response:

SELECT
HEX (' force high crowne plaza),
UNHEX (
'E58A9BE9AB98E79A87E586A0E58187E697A5E98592E5BA97'
),
HEX (' seven star commercial hotel),
UNHEX (
'E4B883E6989FE59586E58AA1E98592E5BA97'
)
The FROM
DUAL;
  • Related