DROP TABLE prompt IF EXISTS;

create table prompt (
  prompt_id INT primary key auto_increment NOT null,
	language VARCHAR(100),
	length VARCHAR(50),
	code VARCHAR(500)
);


insert into prompt(prompt_id, language, length, code) VALUES ('1','python','short', "# This program adds two numbers

num1 = 1.5
num2 = 6.3

# Add two numbers
sum = num1 + num2");

insert into prompt(prompt_id, language, length, code) VALUES ('2','python','med', "# Store input numbers
num1 = input('Enter first number: ')
num2 = input
('Enter second number: ')

# Add two numbers
sum = float(num1) + float(num2)

# Display the sum
print('The sum of {0} and {1} is {2}'.format(num1, num2, sum))");

insert into prompt(prompt_id, language, length, code) VALUES (3,'python','short', "print('The sum is %.1f' %(float(input('Enter first number: ')) + float(input('Enter second number: '))))");

insert into prompt(prompt_id, language, length, code) VALUES (4,'python','short', 'name = "Programiz"

# print literals     
print(5)

# print variables
print(number)
print(name)');

insert into prompt(prompt_id, language, length, code) VALUES (5,'python','short', "# using input() to take user input
num = input('Enter a number: ')

print('You Entered:', num)

print('Data type of num:', type(num))");