Posts

Showing posts from April, 2024

About MySQL

Image
What is MySQL ? MySQL is used to store data in tables that map to objects. Each table has a scheme defining what columns each row of the table will have. Developers can reliably store and retrieve many data types, including text, numbers, dates, time, and even JSON. How To Program In MySQL? How to see you data in MySQL? Code--  Show databases; To create your data. Code-- Create database (Any name you want to give your data) ; Example-- Create database demo; To work in your data that you made. Code-- use (your data name); example-- use demo; Some basic information before creating table. For Alphabets you have to use a code i.e.-- Varchar . you also have to add the limit of data by putting values in( ) . Example - Name varchar (12);  For Numbers you have to use a code i.e. -- int And again put limit in ( ).  Example -- RollNo int(10); To create a table. code-- create table (name you want to give your table) (enter information); Example-- Create Table student (name varchar(...