MySQL simple additions and deletions to change the search

Using Mysql-essential-5.1.55-win32.msi and Navicat for MYSQL

1. Add a table

CREATE TABLE userinfo (uuid varchar(36) NOT NULL PRIMARY KEY,username varchar(30) NOT NULL,userpassword varchar(30) NOT NULL)

The new status after

2. Inserting data

INSERT INTO userinfo VALUES("1","name","123456")

State after inserting data

3. Delete data

DELETE FROM userinfo WHERE uuid="2"

Pre-delete state

Perform the Delete

Delete Succeeded

4. Modify the data

UPDATE userinfo SET username = "xiaoming" WHERE uuid="2"

Before modification

Perform modifications

Modification succeeded

5. Query data

(1) Search all contents

SELECTFROM

Query results

(2) Query the specified content

SELECT username FROM userinfo WHERE uuid="2"

Query results

MySQL simple additions and deletions to change the search