Skip to main content

INSERT DATA INTO MYSQL

Insert data into MySQL



How to insert data into MySQL :

After installation of WampServer a short cut will appear on the desktop.

Click on the short cut and you will be asked whether the programme to be allowed to open, then click yes.

Then "w" icon will be displayed on the shortcut bar on the bottom which will first appear as red then orange and then green.

Right click on the icon and select PHPMYADMIN for inserting data into MySQL.

You will be directed to login page login after giving the required credentials.

You will be directed to the phpmyadmin page then select new on the left panel to create a new data base viz. "empdetails".  

Then save and go 

Then you will be asked to create table give name of the table as "empadress".

Create four coloumns as displayed :

id

empname

qtrno

persno


int for id

Varchar for empname
Int for qtrno
Into for persno

Click on A/I box and activate. A/I is for auto increment of ID i.e. in your case Sr.No. or any auto numbering for your database.


Click on "Go"


Then Save and the table will be created.


Browse the table and insert the data one by one.


The latest version of MySQL is 8.0.20 released couple of weeks ago.  MySQL is a database where you can meet all your challenges to database maintenance with an everlasting support.  

Till date this database management system has been serving the people with the right approach and generosity and free of cost.  Commercial usage may be chargeable. We do not need to check out about the commercial usage.  We are using this for our private purpose and learning something about how to insert database and maintain this for short term usage and there we depend upon the Wampserver for all including package comes with all packages like PHP, MariaDB, MySQL, PHPMYADMIN and Apache. 


Comments

Post a Comment

Popular posts from this blog

How to Install Wampserver in Windows 10

What is WAMPSERVER :  WAMPSERVER IS A LOCAL WEBHOSTING PACKAGE HOW TO INSTALL WAMPSERVER IN WINDOWS 10 WAMP stands for Windows Apache  MySQL  and PHP. WAMPSERVER is a server for executing Hypertext Preprocessor programming language. Normally PHP is used as a server side programming language in building beautiful web applications and websites. In a  web development  activity WAMPSERVER playing the role of displaying the webpages without the help of a  Browser .  HTML and CSS is also used on side by side to display the webpages and ultra modern web applications and graphical presentations. What is PHP?   PHP was initially "Personal Home Page" and now it is  known as Hyper-text Pre Processor".  PHP is very widely used to build stunning web applications and websites.  There are many such websites built with PHP.  PHP was initially developed by 'Rasmus Leadoff' which is further developed by PHP Team.  The introdu...
Post a Comment
Read more

LEARN HOW TO CREATE A REGISTER FORM IN HTML

LEARN HOW TO CREATE A REGISTER FORM IN HTML In order to create a database and table in the database require XAMPP Webserver.  For XAMPP download and install visit site  https://www.apachefriends.org/index.html. After installing the Server localhost C:\xampp and open  'htdocs'  folder  where you will create your form  form1.html ,  close the folder and on desktop click shortcut of XAMPP and it will be opened at the bottom of the screen then click on the icon appearing on the taskbar then a pop box XAMPP control panel will appear on the screen then click on the first start button and second start button.  Then the port numbers will appear in front of the start button and start button will become stop button also click second button for starting MySql then the button will become stop button, when you close the local host you need to click on both the stop buttons before shutting down the pc or laptop. Then click on the button next to start ...
Post a Comment
Read more

Human Resource Management in Indian Context:

  Human Resource Management   in Indian Context : The term Human Resource Management implies the organizing and managing the employees of an Organization.  Human Resource is the most important asset of an Organization.  In order to properly develop and train the people of an Organization there is a dire need to recruit suitably qualified employees at proper time and at regular intervals.  The size of the Organization is relevant but the people recruited should be of high quality and value and should gain goodwill to the Organization. According to the need of the Organization w hether it is big or small Organization, the recruitment of the right people for right job is necessary.  The term Human Resource meant for all levels of Organization.  In each and every small to medium to large Organizations a well equipped Human Resource Department is essential to look after the employee relations and its management.  It is said that if the Human conte...
Post a Comment
Read more