Database Operation
We are using the integrated environment phpstudy
We will open mysql.exe first
Then we will see To
we need to enter the password, enter the password: root
In this way we will enter our database, below Let’s take a look at what’s in our database
Write command
##Create database
Let’s create a login database
How to know whether we have successfully created the login database
Method 1: Yes View on the web management side
Method 2: Use command; View all databases
Next we will create database tables
How to create data tables
Note: PRIMARY KEY (id) If the primary key is not set, it cannot be created.
In this way, our table will be created
Let's check on the web management side to see if there is a user table in the login database. If it exists, we have created it successfully
Next Section