this is the same as the pervious question this the format of MySQL The program i

Question

this is the same as the pervious question this the format of MySQL

The program is not responding to add anything and how to add the first row using insert statements

1 SELECT * FROM starter. student; INSERT INTO starter,' student ID LastName, FirstName , Email, Sex DateofBirth, EnrolledDate Major!D, Scholarship) 10 VALUES 12 ( Alrahem', 'Ali, 'se0879581@acad.tri-c.edu', M, 2016-10-15', 1, '4000.00) 13 Result Grid Filter Rows: Wrap Cell Content: LastName FirstName Email Sex DateOfBirth EnrolledDate MajorID Scholarship Dearnalv Rachael RachaelDearnalv@college.edu F 1992-09-16 2016-10-15 1 4000.00

Explanation / Answer

As per your question if our table already have record in first row then we are not able to add the in first row.

if you want to add record in first then we need to update the first row using update quary.

for the update quary :

Update 'starter'.'student' set LastName='Alrahem',FirstName='Ali',email='SS00879581@acad.tri-c.edu',sex='M',dateOfBirth='2000-12-01',enrolledDate='2016-10-15', MajorID=1 ,Scholarship='4000.00' where Id=1;

otherwise Insert new record change in next row by using below query don't miss any column value

INSERT INTO 'starter'.'student' ('ID',
'LastName','FirstName','email','sex','dateOfBirth','enrolledDate', 'MajorID','Scholarship' ) VALUES (2,'Alrahem', 'Ali', 'S00879581@acad.tri-c.edu','M','1992-12-10','2016-10-15',1,'4000.00');

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.