Question

Answer the following question:-

1. What is the procedure to start XAMPP office?

2.How will your login to MqSQL?

3.What is the command to insert record into a table ?

4.How will u fetch records from a table ?

5.Write the difference between Update and Insert command .


Class:8


•Don't copy from google.
•Don't post unwanted answer.
​

Answer 1

Explanation:

2.Enter mysql.exe –uroot –p , and MySQL will launch using the root user. MySQL will prompt you for your password. Enter the password from the user account you specified with the –u tag, and you'll connect to the MySQL server

Answer 2

$\huge\fbox\pink{Answer}$

1.

• Step 1: Download.

• Step 2: Run .exe file.

• Step 3: Deactivate any antivirus software.

• Step 4: Deactivate UAC.

• Step 5: Start the setup wizard.

• Step 6: Choose software components.

• Step 7: Choose the installation directory.

• Step 8: Start the installation process.

2.

• At the command line, log in to MySQL as the root user: mysql -u root -p.

• Type the MySQL root password, and then press Enter.

• Type \q to exit the mysql program.

• To log in to MySQL as the user you just created, type the following command.

• Type the user's password, and then press Enter.

3.

To insert records into a table, enter the key words insert into followed by the table name, followed by an open parenthesis, followed by a list of column names separated by commas, followed by a closing parenthesis, followed by the keyword values, followed by the list of values enclosed in parenthesis.

4.

• A select statement is a SQL statement that begins with the word "select."

• Select statements are used to retrieve data from SQL tables.

• An asterisk after the word "select" means retrieve all fields (columns).

• The name of the table from which you are retrieving data is specified in the From clause.

5.

Insert is for adding data to the table, update is for updating data that is already in the table. An UPDATE statement can use a WHERE clause but INSERT cannot.

Insert is for putting in a fresh record to the table. while the update enables you to modify the inserted record e.g. modifying data type etc.