To create a table, we could directly type our commands into the command line but, in case of any errors that occur we will use a MySQL script file so that it is easier to correct mistakes in typing. This script file will have commands that are a part of the Data Manipulation Language (DML), which is a sublanguage of SQL that allows for the modification and retrieval of information from database objects. The reason for this, from painstaking mistakes on my part, is to make it as easy as possible to execute commands. Let's take a look at the code below.
In this previous blog post, we discussed how to create a database and a table with initialized columns by using a script. We will continue that post and now insert data into the student table. The first approach is entering in one row at a time. This is the first line that we see in the code box.
In this post, you will learn how to use the UPDATE feature in MySQL. The syntax of the UPDATE command will be shown in the code below. Using the information that was entered into an SQL table from this blog post, we can now update information at a specfic column.