Scribd
Upload
5 views1 page

SQL User Data Management Example

The document outlines SQL commands for managing a 'user_Data' table, including creating the table, inserting multiple user records, and performing various queries such as selecting, deleting, and updating records. It demonstrates operations like retrieving usernames based on specific conditions and ordering results. Additionally, it includes an example of inserting a new user record into the table.

Uploaded by

kyliejones48530
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
5 views1 page

SQL User Data Management Example

The document outlines SQL commands for managing a 'user_Data' table, including creating the table, inserting multiple user records, and performing various queries such as selecting, deleting, and updating records. It demonstrates operations like retrieving usernames based on specific conditions and ordering results. Additionally, it includes an example of inserting a new user record into the table.

Uploaded by

kyliejones48530
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

CREATE TABLE user_Data (

serial_num number(5),
username varchar(50),
password varchar(10)
)

INSERT INTO User_Data values (00251, 'silly.ghost22', 'sillyvery$$1');


INSERT INTO User_Data values (00354, 'free_tips302', 'gOdisme2093*!');
INSERT INTO User_Data values (00102, 'jksrightpillow_', 'JkisGod90&');
INSERT INTO User_Data values (00987, 'headFree_or_freeHead', 'goofing01_1');
INSERT INTO User_Data values (00143, '142_127_119', 'NCTits');
INSERT INTO User_Data values (00127, 'Regular_huh?', 'NCT0as');
INSERT INTO User_Data values (00127, 'save_your_tearsfor.today', 'NCTcrumbs');

SELECT username from User_Data where serial_num = 127;


SELECT username from User_Data where password = 'NCTits';

SELECT *From User_Data ORDER by password, serial_num, username;

SELECT DISTINCT username From User_Data;

DELETE from User_Data where serial_num = 251;

UPDATE User_Data set username = 'free_grips;)' where serial_num = 354;

INSERT into User_Data values (00119, '[Link]', 'SlayG1DlE%');

You might also like