Creating the table

In this section of the tutorial, we will create the new table Employee. We have to mention the database name while establishing the connection object.

We can create the new table by using the CREATE TABLE statement of SQL. In our database PythonDB, the table Employee will have the four columns, i.e., name, id, salary, and department_id initially.

The following query is used to create the new table Employee.

<br />
>  create table Employee (name varchar(20) not null, id int primary key, salary float not null, Dept_Id int not null)<br />

Example

<br />
import mysql.connector</p>
<p>#Create the connection object<br />myconn = mysql.connector.connect(host = “localhost”, user = “root”,passwd = “google”,database = “PythonDB”)</p>
<p>#creating the cursor object<br />cur = myconn.cursor()</p>
<p>try:<br />    #Creating a table with name Employee having four columns i.e., name, id, salary, and department id<br />    dbs = cur.execute(“create table Employee(name varchar(20) not null, id int(20) not null primary key, salary float not null, Dept_id int not null)”)<br />except:<br />    myconn.rollback()</p>
<p>myconn.close()<br />

Creating table

Now, we may check that the table Employee is present in the database.

Alter Table

Sometimes, we may forget to create some columns, or we may need to update the table schema. The alter statement used to alter the table schema if required. Here, we will add the column branch_name to the table Employee. The following SQL query is used for this purpose.

<br />
alter table Employee add branch_name varchar(20) not null<br />

Consider the following example.

Example

<br />
import mysql.connector</p>
<p>#Create the connection object<br />myconn = mysql.connector.connect(host = “localhost”, user = “root”,passwd = “google”,database = “PythonDB”)</p>
<p>#creating the cursor object<br />cur = myconn.cursor()</p>
<p>try:<br />    #adding a column branch name to the table Employee<br />    cur.execute(“alter table Employee add branch_name varchar(20) not null”)<br />except:<br />    myconn.rollback()</p>
<p>myconn.close()<br />

Creating the table

原创文章，作者：ItWorker，如若转载，请注明出处：https://blog.ytso.com/263641.html

Creating the table

Creating the table

Example

Alter Table

Example

相关推荐

发表回复