Skip to main content

MySQL for Developers

MySQL for Developers:-




Before reading this you should read the following articles related to the database.

https://www.shivatutorials.com/2020/08/database-tutorials-sql-tutorials-mysql.html


 If you are Web Developers or Desktop Developers then you should have knowledge of MYSQL Commands, Methods, and Operator to perform database operation.


When you create a database of any software then first you should know about table implementation.


Now MYSQL Provide GUI tools using this we can easily create database and table structure, you can easily create Primary Key, Foreign-Key, Index, etc.


If you are PHP or Java Developer then you can use PHPMYADMIN or MYSQL Yog Software tools of MYSQL.


When you work on PHP Software or Web development then XAMPP, WAMP, MAMP this software by default has MYSQL Server. then no need to install MYSQL separately.


How to work MYSQL With XAMPP?


1)  INSTALL XAMPP to download from https://www.apachefriends.org/index.html


2)  Open XAMPP Control Panel and Start MYSQL and Apache both


3)  Open Web Browser and type localhost/PHPMyAdmin


4)  It provides offline web-based IDE using this you can create database and table


5) Click on Databases option



6)  Write database name according to your working project, for example, my project is computer sales and services then it will create database name as csr1 then click on Create button.



7)  Select the Database then Create a table.

Now I am creating a user registration table using 5 different column



8) Click on go button:-

now create table column using Name and Type and length option if you are taking varchar then length is mandatory.



 8)  Create a primary key to userid or any unique column key. 


You should scroll table structure and go on Index Column.


The primary key will be single in one table and it provided unique and not null column values.




9)  Click on Save button on bottom then table will be created














Comments

Popular posts from this blog

DSA in C# | Data Structure and Algorithm using C#

  DSA in C# |  Data Structure and Algorithm using C#: Lecture 1: Introduction to Data Structures and Algorithms (1 Hour) 1.1 What are Data Structures? Data Structures are ways to store and organize data so it can be used efficiently. Think of data structures as containers that hold data in a specific format. Types of Data Structures: Primitive Data Structures : These are basic structures built into the language. Example: int , float , char , bool in C#. Example : csharp int age = 25;  // 'age' stores an integer value. bool isStudent = true;  // 'isStudent' stores a boolean value. Non-Primitive Data Structures : These are more complex and are built using primitive types. They are divided into: Linear : Arrays, Lists, Queues, Stacks (data is arranged in a sequence). Non-Linear : Trees, Graphs (data is connected in more complex ways). Example : // Array is a simple linear data structure int[] number...

JSP Page design using Internal CSS

  JSP is used to design the user interface of an application, CSS is used to provide set of properties. Jsp provide proper page template to create user interface of dynamic web application. We can write CSS using three different ways 1)  inline CSS:-   we will write CSS tag under HTML elements <div style="width:200px; height:100px; background-color:green;"></div> 2)  Internal CSS:-  we will write CSS under <style> block. <style type="text/css"> #abc { width:200px;  height:100px;  background-color:green; } </style> <div id="abc"></div> 3) External CSS:-  we will write CSS to create a separate file and link it into HTML Web pages. create a separate file and named it style.css #abc { width:200px;  height:100px;  background-color:green; } go into Jsp page and link style.css <link href="style.css"  type="text/css" rel="stylesheet"   /> <div id="abc"> </div> Exam...

Top 50 Most Asked MERN Stack Interview Questions and Answers for 2025

 Top 50 Most Asked MERN Stack Interview Questions and Answers for 2025 Now a days most of the IT Company asked NODE JS Question mostly in interview. I am creating this article to provide help to all MERN Stack developer , who is in doubt that which type of question can be asked in MERN Stack  then they can learn from this article. I am Shiva Gautam,  I have 15 Years of experience in Multiple IT Technology, I am Founder of Shiva Concept Solution Best Programming Institute with 100% Job placement guarantee. for more information visit  Shiva Concept Solution 1. What is the MERN Stack? Answer : MERN Stack is a full-stack JavaScript framework using MongoDB (database), Express.js (backend framework), React (frontend library), and Node.js (server runtime). It’s popular for building fast, scalable web apps with one language—JavaScript. 2. What is MongoDB, and why use it in MERN? Answer : MongoDB is a NoSQL database that stores data in flexible, JSON-like documents. It...