#CREATING A TABLE IN MYSQL HOW TO#

Product_price int, created_at datetime default CURRENT_TIMESTAMP, updated_at datetime default CURRENT_TIMESTAMP)`Д¬tx, cancelfunc := context.WithTimeout(context.Background(), 5*time.Second) query := `CREATE TABLE IF NOT EXISTS product(product_id int primary key auto_increment, product_name text, Let's be a responsible developer and create a context with a timeout so that the create table query times out in case of any network partition or runtime errors. In our case, the create table query doesn't return any rows and hence we will use the ExecContext() context method to create our table. The ExecContext method of the DB package executes any query that doesn't return any rows. Now that we have query, let's convert it into Go code and create our table. The default values of created_at and updated_at is set as the current timestamp. Product_id is an auto incremented int and it serves as the primary key. The MySQL query to create this table is provided below, CREATE TABLE IF NOT EXISTS product(product_id int primary key auto_increment, product_name text, product_price int, created_at datetime default CURRENT_TIMESTAMP, updated_at datetime default CURRENT_TIMESTAMP) We will be creating a table named product with the fields product_id, product_name, product_price, created_at and updated_at. MySQL Series IndexД¬onnecting to MySQL and creating a Database

#CREATING A TABLE IN MYSQL HOW TO#

In this tutorial, we will learn how to create a table and insert records into that table. In the first tutorial, we discussed how to connect to MySQL and create a database. MySQL Tutorial: Creating a Table and Inserting Rows 07 March 2021

Creating a table in mysql