Collections:
Creating a Test Table in MySQL
How To Create a Testing Table in MySQL?
✍: FYIcenter.com
If you want to practice DML statements, like INSERT, UPDATE and DELETE, you should create a testing table. The tutorial exercise shows you a good example:
mysql> CREATE TABLE fyi_links (id INTEGER PRIMARY KEY, url VARCHAR(80) NOT NULL, notes VARCHAR(1024), counts INTEGER, created TIMESTAMP DEFAULT CURRENT_TIMESTAMP()); Query OK, 0 rows affected (0.08 sec)
You should keep this table to practice other tutorial exercises presented in this collection.
2018-01-24, 701👍, 0💬
Popular Posts:
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...
Where Is the Export Dump File Located in Oracle? If you are not specifying the dump directory and fi...
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...
What Is SQL in MySQL? SQL, SEQUEL (Structured English Query Language), is a language for RDBMS (Rela...