Channi Studies

Circular QueueA queue is an ADT in which items are inserted at the end of the queue and removed from the front of the queue.The queue enqueue oepration inserts an item at the end of the queue.The queue dequeue operation removes and returns the item at the front of the queue. A queue is reffered to as a first-in first-out (FIFO) ADT. Remembering queue = FIFO and stack = LIFO can make your life ea..

Stack Stack is an Abstract Data Type (ADT) in which items are only inserted on or removed from the top of a stack. The stack push operation inserts an item on the top of the stack. The stack pop operation removes and returns the item at the top of the stack.  A stack is referred to as a Last-In First-Out (LIFO) ADT. A stack can be implemented using a linked list, an array, or a vector.    Suppos..

In this post, we will take a look at two constraints in MySQL—UNIQUE and NOT NULL. UNIQUEUNIQUE constraint ensures that all values in a column are different. We can add a constraint to a table when we create it, or after.  Let's make a new table named product, that stores three columns: id, name, and price of the product. Say we don't want any duplicative product id's in the table. We can use UN..

Let's starty by creating a temporary database for this post. CREATE DATABASE test( my_date DATE, my_time TIME, my_datetime DATETIME);SELECT * from test; To get current date, time, or date time, there are 3 built-in functions, CURRENT_DATE(), CURRENT_TIME, and NOW()Let's try inserting a new row of appropriate data obtained by these functions. INSERT INTO testVALUES (CURRENT_DATE(), CURR..