Channi Studies

Today, we learned about:Row insertingSELECT Row Insert Continued from yesterday's database, our employee table in myDB database has following columns We want to add a row of data into the table. In such situation, we will be using INSERT command. INSERT INTO employeesVALUES (1, "Eugene", "Krabs", 25.50, "2024-10-22");When insrting a row to a table, the new data have to follow the order of the co..

Database works like a folder, and table works like a file in SQL. We will work in the query window of MySQL Workbench Software, that can be accessed after succesfully connecting to MySQL server. Database To create a database, we use CREATE query (MySQL is not case-sensitive, meaning that you can use either CREATE, Create, create, CrEaTe, etc)CREATE DATABASE myDB;  To use the created database, yo..

이번 포스트부터 매일 조금씩 SQL을 공부하는 프로젝트를 시작합니다.  Relational Database Management System (RDBMS) software that manages and stores data in a structured format, using tables with rows and columns, and allows users to interact with the data using a structured query language (SQL). We will studying with MySQL, one of the most popular RDMBS used worldwide.  Why We Use MySQL?✅ Structured Data Storage – MySQL is ..

Big O notation is a mathematical way of describing how a function (running time of an algorithm) generally behaves in relation to the input size. Given a function that describes the running time of an algorithm, the Big O notation for that function can be determined using the following rules:If f(N) is a sum of several terms, the highest order term (the one with the fastest growth rate) is kept ..