Nothing here yet.
Nothing here yet.
Jul 5, 2024 · 5 min read · 0) Request - Response This is the very basic model that when the client (initiates the communication) usually sends a request to the server for getting something or performing an action and the server responds with the required files/data. ProsC...
Join discussionMar 10, 2024 · 2 min read · Creating an index denotes taking the column data and storing it in another index column our data is stored on disks as we all know, so file systems is the topic we are talking about now Pages (a way for how to store the data on hard disk) data is abo...
Join discussion
Mar 10, 2024 · 3 min read · Views are about providing a customized, filtered representation of the data Simple View in MySQL simple views are virtual tables taking no space on physical hard disks. syntax in MySQL: create view lvl_300_stds as select * from students where level_i...
Join discussionMar 7, 2024 · 1 min read · Entering the SQL mode \sql connecting with a certain user \connect root@localhost using a specific database use new_db; creating a new user and adding a password for him. create user ali@localhost identified by '123pass' DCL (Data Control Languag...
Join discussionMar 7, 2024 · 4 min read · Transactions A Transaction is a sequence of one or more SQL statements executed as a single unit of work. A transaction represents a logical unit of work that is either fully completed or fully rolled back to its previous state if any part of it fail...
Join discussion