Open Navicat MySQL management tool
Connecting to a database
Select Test Database
Click Query
Enter the corresponding SQL command
Create TableTuser (unamevarchar( -) not NULL Primary Key, Upwdvarchar( -) not NULL );Create TableP_info (Pkeyvarchar( the) not NULL Primary Key, PNamevarchar( -) not NULL, Psexvarchar( -) not NULL, pagevarchar( -) not NULL, Padressvarchar( -) not NULL, Pmoneyvarchar( -) not NULL);INSERT intoTuser (' uname ', ' upwd ')VALUES('admin888','123456');INSERT intoP_info (' Pkey ', ' pname ', ' psex ', ' page ', ' padress ', ' Pmoney ')VALUES('10028','Zhang San','male',' +','102, Tongan District, Xiamen City, Fujian province','2500');INSERT intoP_info (' Pkey ', ' pname ', ' psex ', ' page ', ' padress ', ' Pmoney ')VALUES('10031','John Doe','female',' +','206, Tongan District, Xiamen City, Fujian province',' the');INSERT intoP_info (' Pkey ', ' pname ', ' psex ', ' page ', ' padress ', ' Pmoney ')VALUES('10081','Shen Huadong','male',' at','10086, Tongan District, Xiamen City, Fujian province','8800');
Such as
The corresponding database table and data insertion succeeded