Insert Records to the database Using PHP and MySQL

-

 

To add records to the MySQL table the INSERT statement is used 

To add any new records to the table we use INSERT query, which is very simple to understand and work with.

Syntax:

INSERT INTO Table_name (Column1, Column2, Column3, Column4... Column N) VALUES (Value1, Value2, Value3, Value4... Value N)

Example:

INSERT INTO mydata_tbl (Name, Gender, Age, Education) VALUES ('ABCD', 'F', 25, 'MSc')

Here, in the example mydata_tbl is the name of the given table.

Name, Age, Gender,  and Education are the Columns and their values are ABCD, F,25, and MSc respectively.

                                                              

Other Essential MySQL Commands

SELECT - To choose specific data ( record ) from your Database 
CREATE DATABASE - To generate a new Database
ALTER DATABASE - To modify an existing Database



                                                                                                                          HAPPY CODING😍


Comments

Post a Comment

Popular posts from this blog

Validation Code For Phone Number Using preg_match() in Php

-
Image
Phone Number Validation Using preg_match() Below code shows validation of Phone Number 1)Checking whether user input (Phone Number) contains an alphabet in Phone Number          <?php         $mobile_no="123fdgdg890";        if(preg_match("/[a-z][A-Z]/i", $mobile_no))        {   echo "Invalid Phone Number!";        }else{                echo "Valid Phone Number!";        }      ?> Output :Invalid Phone Number! Syntax preg_match("/[a-z][A-Z]/i", $mobile_no) The above syntax will verify whether given phone number is well-formed or not.if it is not, it will show an error message. The    preg_match()  function helps to find whether a given variable is valid or not. 2 )Checking whether user input (Phone Number) contains 10 digits in Phone Number      <?php...
Read more

Writing data to a file using Python

-
  Writing data to a file using Python Writing data to a file in Python can be done in a variety of ways, depending on the file type and how you want to save the data. Here's a general guide to common formats. 1. Writing Text to a Plain Text File # Writing text data data = "This is some text data." # Open a file in write mode ('w') and write data with open("output.txt", "w") as file:     file.write(data) 2. Writing Data to a CSV File import csv # Data to write data = [     ["Name", "Age", "City"],     ["Rajesh", 25, "India"],     ["Shaun", 30, "San Francisco"],     ["Afzal", 35, "Chicago"] ] # Writing to a CSV file with open("output.csv", "w", newline="") as file:     writer = csv.writer(file)     writer.writerows(data) 3. Writing Data to a JSON File import json # Data to write data = {     "Name": "Alice", ...
Read more

Update and Delete Record Using PHP and MySQL

-
Update and Delete Record Using PHP and MySQL UPDATE  Query :  To Update data in your Database Syntax: UPDATE Table_name SET column=value WHERE other_column = other_value DELETE Query To delete the record from your Database To delete the data frothe m database you should use the DELETE query, the syntax is given below: DELETE  FROM Table_name WHERE column = value                                                                                                                                                      HAPPY CODING😍
Read more