SQL注入学习日记2

0x00 What we have learned yesterday?
We've learned what is SQL and it's main features.
We've also learned how to create a new database and select it.

Then today we will learn some basic concept like tables,rows,columns,etc.

0x01 create a table
Why should we create a table? Because we must make a structure for the database. When we create a database, it's empty, we must define some structure for it to make it sensitive.
So now I want to store my basic information into the database, I'm gonna to create a new table:
CREATE TABLE christopherwu(name VARCHAR(20),sex CHAR(1),id VARCHAR(10),birth DATE);
like this.
I must make a explanation about varchar: the values' length in varchar is changeable. It's more flexible than char.

This is a example:

So we successfully created a table!

Fuck I need to write mt EDA experiment export,
so this is what we learned today XD.

posted @ 2020-11-17 22:07  ChristopherWu  阅读(40)  评论(0编辑  收藏  举报