How to create a user information table in MySQL?

9 months ago

Ava Mitchell

1 minute

You can use the following SQL statement to create a user information table:

This table contains the following fields:

id – an auto-increment primary key field used to uniquely identify each record.
username – username, VARCHAR type, maximum length of 50 characters.
password – password, VARCHAR type, maximum length of 50 characters.
email – email, VARCHAR type, maximum length of 100 characters.
age – age, INT type.
address – address, VARCHAR type, maximum length of 200 characters.