Channi Studies

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

Array–Based List An array-based list is a list ADT implemented using an array. An array-based list supports the common list ADT operations, such as append, prepend, insert after, remove, and search.In many programming languages, arrays have a fixed size. An array-based list implementation will dynamically allocate the array as needed as the number of elements changes. Initially, the array-based ..