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

BASIC EXCEL FORMULAS

  MS OFFICE MS Office introduced in the year 1987 has enhanced the speed of work and enriched the work life of an employee. With the introduction of this package by Microsoft all of a sudden dramatic changes occurred in the work system followed in the periods prior to 1987.  Earlier people were using WordStar and QuickPro, FoxPro, which has been replaced with latest and ultra modern package of Microsoft Office applications.  All of a sudden there occurred a dramatic change in the work style with the introduction of IBM Computers and other Companies also upgraded their Computer to run Windows and MS Office.  The easy and quick actions of these applications changed the technology and brought a revolution in the office work of each employee. MS EXCEL MS Excel is one of the packages application introduced by Microsoft.  Microsoft applications started spreading like anything its development was very quick and aspiring.  Even though MS Excel has be...
Post a Comment
Read more

BLOG IDEAS FOR BEGINNERS

BLOG IDEAS FOR BEGINNERS There are various job sites available in the Internet you can create a blog about the information regarding these sites. DAYS AND THEIR IMPORTANCE  During the entire year there are various Days which are celebrated through out the year like Women's Day, Valentines Day etc. It is possible to create a blog in this category which will be useful to all. IMPORTANT PLACES AND THEIR SPECIALITIES  People are searching about various places in the world as well as in India to check the suitable location for visiting or for business purpose, people around the world usually visit various countries in that case if such a blog is created that would be beneficial for people to search their desired location and take details about these places. IMPORTANT FOOD ITEMS AND THEIR SPECIALITIES  There are various channels in TV now days working round the clock regarding preparation of food and specialties of food available at different areas in the world, so it is a ...
Post a Comment
Read more

APPRENTICE REGISTRATION

Those who have passed the technical education / non technical education can do apprenticeship from any one of the Industries situated in India.  In order to register in the Apprenticeship Portal you should possess qualification in technical / non technical fields. First of all you have to visit the website WWW.APPRENTICESHIP.GOV.IN  and click on the topic Apprentice Registration on the bottom of the Home Page of above Website. Please fill up all the details like Name, Father's Name, Age, Aadhar No., Mobile No., Qualification, Trade, University and the first preference i.e. if anybody having BSC Chemistry qualification can choose Chemical and for Sub-Heading Designated Trades Attendant Operator Chemical is to be selected for BSC Chemistry Qualification.  Attach required documents, photo and mark sheets. Upon successfully entering the details and captcha text you can click the submit button, which will guide you to another link and the link will tell you...
Post a Comment
Read more