Create category table

Created by Tung NGUYEN on 2016-01-06 14:28:51
Last modified on 2016-01-06 15:30:42
Create category table in it4bus database. The aim is to classify the news.
To do this task, I have reviewed knowledge of 
  1. Interacting to MySQL Server via terminal: mysql -u root -p
  2. Creating a table: CREATE TABLE table_name (id int NOT NULL primary key increment, name varchar(100), slug(150));
  3. Inserting data into the table: INSERT INTO table_name VALUES(....);
  4. Adding the foreign key to news: category_id using ALTER TABLE table_name ....
  5. Updating table: UPDATE table_name SET field1=value1 WHERE....;
Category: Uncategorized
Tags: 1
© 2013 - 2026. Tung NGUYEN. Using CI version: 3.0.2 | Page rendered in 0.0043 seconds.