Getting a NamError when using Python and SQL

Question

I'm running a student database and using python 2.7 on pycharm. Here is the script

FirstName = input("Enter the Student's first name")
    if not FirstName or type(FirstName) != str:
    print("Enter a real name silly")
    exit()

and the create Table stement looks like so

drop table if exists StudentID;
drop table if exists FirstName;
drop table if exists LastName;
drop table if exists GPA;
drop table if exists Major;
drop table if exists FacultyAdvisor;
CREATE TABLE Student(
  StudentID int PRIMARY KEY AUTOINCREMENT ,
  FirstName varchar(25),
  LastName varchar(25),
  GPA NUMERIC,
  Major varchar(10),
  FacultyAdvisor varchar(25)
)

and the error I'm getting is

FirstName = input("Enter the Student's first name")
  File "<string>", line 1, in <module>
NameError: name 'john' is not defined

You are using Python2 I assume. Use raw_input() instead of input() — Alan Kavanagh
– Alan Kavanagh, Commented Feb 26, 2019 at 22:48

Alan Kavanagh · Accepted Answer · 2019-02-26 22:49:51Z

1

My guess is that you're using Python2

You need to use the raw_input() method when receiving String input from the user:

FirstName = raw_input("Enter the Student's first name")

answered Feb 26, 2019 at 22:49

Alan Kavanagh

9,9338 gold badges46 silver badges68 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Getting a NamError when using Python and SQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related