Recently has been studying the blog, in fact, is now a popular self-media, it is interesting that the netizens have written their own blog, the establishment of a small station, and now went to the platform for others to work free, but also enjoy themselves, do not know what the situation.
Blog information:
Topics: Learning topics related to reading notes.
Web site: Use a. NET domain name as the URL.
Content: Writing and contributing, such as: Camel Xiangzi good word good words
This system uses SQL Server database, because Microsoft's database is quite good, more handy, so continue, but I am a database small white, also do not program, can only slowly learn.
Query statement:
SELECT * FROM Dbo.blog.category where cate_id=5
This is a query statement, mainly used to query the database from the station how many columns, and display the relevant information column.
Delete * from Dbo.blog.category where cate_id=5
This is a DELETE statement, mainly used to delete columns from the database, of course, this is for testing, not easy to do.
The syntax above:
Query or delete a select Delete
The asterisk denotes all content, everything you query, or all content you delete, is a wildcard character.
from which table to query, the scope of the query
where represents a conditional vocabulary, followed by a query condition.
The above is the content of today's study, as a small white, from the beginning to learn is very important, I believe we will think so!
Learn notes SQL Server database bulk query and delete content execution statements