SELECT column_names FROM table_name

import mysql.connector as mysql

db = mysql.connect(
    host = "localhost",
    user = "yourusername",
    passwd = "yourpassword",
    database = "studytonight"
)

cursor = db.cursor()

Thus the output of the above code will be:

**Output:**

('Ramesh', 'CSE', '149 Indirapuram', 1) 

('Peter', 'ME', 'Noida', 2) 

('Amy', 'CE', 'New Delhi', 3) 

('Michael', 'CSE', 'London', 4)

In the next section we will learn how to retrieve data of certain columns from a table.

import mysql.connector as mysql

db = mysql.connect(
    host = "localhost",
    user = "yourusername",
    passwd = "yourpassword",
    database = "studytonight"
)

cursor = db.cursor()

The above code will fetch the **name** column from the **students** table:

**Output:**

('Ramesh',) 

('Peter',) 

('Amy',) 

('Michael',)

### Selecting Multiple columns from a Table

You can also **select multiple columns from a table** at a time by providing multiple column names in the above syntax. Let us see the code snippet given below for clear understanding:

```python
import mysql.connector as mysql

db = mysql.connect(
    host = "localhost",
    user = "yourusername",
    passwd = "yourpassword",
    database = "studytonight"
)

cursor = db.cursor()

The above code will fetch both **name** and **branch** column both from the table **students**:

**Output:**

('Ramesh', 'CSE') 

('Peter', 'ME') 

('Amy', 'CE') 

('Michael', 'CSE')

import mysql.connector as mysql
db = mysql.connect(
    host = "localhost",
    user = "yourusername",
    passwd = "yourpassword",
    database = "studytonight"
)

cursor = db.cursor()
cursor.execute("SELECT * FROM students")

myresult = cursor.fetchone() ##fetches first row of the record

print(myresult)