SQLite database operations in Hindi
RGPV University / DIPLOMA_CSE / MOBILE COMPUTING
SQLite Database Operations in Hindi
SQLite Database Operations in Hindi
SQLite Database Overview
SQLite ek lightweight, self-contained, serverless, aur zero-configuration database engine hai. Iska use zyada tar mobile applications aur embedded systems me hota hai. Yeh relational database management system (RDBMS) hai, jo SQL queries ka istemal karta hai data store karne ke liye. SQLite ko ek single file ke roop me store kiya ja sakta hai aur yeh data ko efficiently manage karta hai.
Creating Database in SQLite
SQLite me database create karna bahut hi simple hai. Aap ek command ke through naya database create kar sakte hain. Jab bhi aap SQLite me new database create karte hain, to wo ek file ke roop me save hota hai. Agar database file pehle se exist karti hai, toh wo us file ko open kar leta hai.
sqlite3 database_name.db
Yeh command ek new SQLite database banayega jiska naam "database_name.db" hoga. Agar file already exist karti hai, toh SQLite usse open kar lega.
Creating Table in SQLite
SQLite me table create karna bhi bahut simple hai. Aapko SQL command ka use karke table create karna hota hai. Har table me columns aur rows hote hain jisme aap apna data store kar sakte hain. Table create karte waqt aapko columns ka data type specify karna padta hai jaise INTEGER, TEXT, REAL, etc.
CREATE TABLE students (
id INTEGER PRIMARY KEY,
name TEXT NOT NULL,
age INTEGER,
grade TEXT
);
Yeh command ek "students" naam ka table create karega jisme columns honge: id, name, age, aur grade. "id" column primary key hai jo unique value store karega.
Inserting Data into SQLite
SQLite me data insert karne ke liye "INSERT INTO" SQL command ka use kiya jata hai. Aap kisi bhi table me data insert kar sakte hain. Yeh command rows ko table me insert karta hai. Har row me column values specify karte hain.
INSERT INTO students (name, age, grade)
VALUES ('Ravi', 21, 'A');
Is example me, "Ravi" naam ka student 21 saal ka hai aur uska grade 'A' hai. Yeh data "students" table me insert ho jayega.
Retrieving Data from SQLite
SQLite se data retrieve karne ke liye "SELECT" query ka use kiya jata hai. Aap SELECT query ka use karke ek ya zyada columns ka data retrieve kar sakte hain. Aap WHERE clause ka use karke specific rows bhi fetch kar sakte hain.
SELECT * FROM students WHERE grade = 'A';
Is query se hum un sab students ke data ko fetch karenge jinka grade 'A' hai. "SELECT *" ka matlab hai ki hum sabhi columns ki data retrieve kar rahe hain.
Updating Data in SQLite
SQLite me data update karne ke liye "UPDATE" SQL command ka use kiya jata hai. Is command ka use karte waqt aapko specific rows aur columns ko update karna hota hai. Update karte waqt aapko "SET" clause ka use karna padta hai jisme aap new values specify karte hain.
UPDATE students
SET grade = 'B'
WHERE name = 'Ravi';
Is query me, hum "Ravi" naam ke student ka grade 'B' update kar rahe hain. "WHERE" clause se hum specific row ko target karte hain.
Deleting Data from SQLite
SQLite me data delete karne ke liye "DELETE" command ka use kiya jata hai. Iska use specific rows ko delete karne ke liye kiya jata hai. Agar aap "WHERE" clause ka use nahi karte, toh saara table ka data delete ho jayega.
DELETE FROM students WHERE name = 'Ravi';
Is query se "Ravi" naam ka student "students" table se delete ho jayega. Agar aap "WHERE" clause use nahi karte, toh poora table delete ho jayega.
SQLite Transactions
SQLite me transactions ka use atomic operations ko perform karne ke liye hota hai. Ek transaction me multiple queries ko group kiya ja sakta hai, aur agar kisi query me error aata hai, toh poori transaction ko rollback kiya ja sakta hai.
BEGIN TRANSACTION;
INSERT INTO students (name, age, grade)
VALUES ('Seema', 22, 'B');
COMMIT;
Is example me, hum "Seema" naam ke student ka data insert kar rahe hain aur uske baad transaction ko commit kar rahe hain. Agar koi error hoti hai, toh rollback se transaction ko cancel kiya ja sakta hai.
SQLite Indexing
SQLite me indexing ka use queries ko fast banane ke liye kiya jata hai. Jab aap kisi column ko index karte hain, toh wo column queries ke liye optimized ho jata hai. Index ka use searching aur sorting me hota hai.
CREATE INDEX idx_grade
ON students (grade);
Yeh command "grade" column par ek index create karega, jisse queries fast ho jayengi jo grade column ko use karte hain.
SQLite Data Types
SQLite me kuch common data types hote hain, jaise INTEGER, TEXT, REAL, BLOB. Ye data types aapko apne table me columns define karte waqt specify karne padte hain. Yeh data types aapke data ko store karne aur retrieve karne me madad karte hain.
- INTEGER: Whole numbers ko store karta hai.
- TEXT: Strings ya text data ko store karta hai.
- REAL: Floating point numbers ko store karta hai.
- BLOB: Binary large objects (images, audio) ko store karta hai.
FAQs
SQLite ek lightweight aur serverless database engine hai jo primarily mobile applications aur embedded systems mein use hota hai. Yeh ek self-contained aur zero-configuration database hai, jiska matlab hai ki aapko server ki zaroorat nahi padti.
SQLite me naya database create karne ke liye aapko simply "sqlite3 database_name.db" command run karni hoti hai. Yeh command ek new SQLite database file create karega, agar wo file pehle se exist nahi karti.
Data insert karne ke liye "INSERT INTO" command ka use hota hai. Example: INSERT INTO table_name (column1, column2) VALUES ('value1', 'value2'); is command se aap kisi table me naye rows insert kar sakte hain.
Data retrieve karne ke liye "SELECT" query ka use hota hai. Aap SELECT * FROM table_name; is query ka use karke poore table ka data retrieve kar sakte hain, ya phir "WHERE" clause ke saath specific rows fetch kar sakte hain.
Data ko update karne ke liye "UPDATE" command ka use hota hai. Example: UPDATE table_name SET column1 = 'new_value' WHERE condition; isse specific rows ka data update ho jata hai.
Data delete karne ke liye "DELETE" command ka use hota hai. Example: DELETE FROM table_name WHERE condition; isse specific rows delete ho jayengi. Agar "WHERE" clause nahi use karte, toh puri table ka data delete ho sakta hai.