التخطي إلى المحتوى الرئيسي

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














تعليقات

المشاركات الشائعة من هذه المدونة

Uncontrolled form input in React-JS

  Uncontrolled form input in React-JS? If we want to take input from users without any separate event handling then we can uncontrolled the data binding technique. The uncontrolled input is similar to the traditional HTML form inputs. The DOM itself handles the form data. Here, the HTML elements maintain their own state that will be updated when the input value changes. To write an uncontrolled component, you need to use a ref to get form values from the DOM. In other words, there is no need to write an event handler for every state update. You can use a ref to access the input field value of the form from the DOM. Example of Uncontrolled Form Input:- import React from "react" ; export class Info extends React . Component {     constructor ( props )     {         super ( props );         this . fun = this . fun . bind ( this ); //event method binding         this . input = React . createRef ();...

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...

JDBC using JSP and Servlet

JDBC means Java Database Connectivity ,It is intermediates from Application to database. JDBC has different type of divers and provides to communicate from database server. JDBC contain four different type of approach to communicate with Database Type 1:- JDBC-ODBC Driver Type2:- JDBC Vendor specific Type3 :- JDBC Network Specific Type4:- JDBC Client-Server based Driver  or JAVA thin driver:- Mostly we prefer Type 4 type of Driver to communicate with database server. Step for JDBC:- 1  Create Database using MYSQL ,ORACLE ,MS-SQL or any other database 2   Create Table using database server 3   Create Form according to database table 4  Submit Form and get form data into servlet 5  write JDBC Code:-     5.1)   import package    import java.sql.*     5.2)  Add JDBC Driver according to database ide tools     5.3)  call driver in program         ...