Modify the reader table data, will phone number starting with 181 user accounts pavilion to 'hzlib
'

Delete the reader table data, names begin with a gender to 'male' record delete

CodePudding user response:

 
- to modify data, reader table will phone number starting with 181 user accounts pavilion to 'hzlib 
'The update t 
Set an account pavilion='hzlib' 
The from readers table t 
Where the phone number like '181%' 

- delete readers table data, names begin with a gender for 'male' record delete 
The delete t 
The from readers table t 
Where names like 'a %' and gender='male' 

CodePudding user response:

Can good

CodePudding user response:

The

reference 1/f, started the first reply:

 
- to modify data, reader table will phone number starting with 181 user accounts pavilion to 'hzlib 
'The update t 
Set an account pavilion='hzlib' 
The from readers table t 
Where the phone number like '181%' 

- delete readers table data, names begin with a gender for 'male' record delete 
The delete t 
The from readers table t 
Where names like 'a %' and gender='male' 

That will add images in the database, please brother

CodePudding user response:

I know a little.

CodePudding user response:

Modify the reader table data, will phone number starting with 181 user accounts pavilion to 'hzlib
'
Update a set accounts pavilion='hzlib table where the phone number like the from readers' 182%'

CodePudding user response:

Table forgot to add the alias a