Tag: mysql database
April 22, 2023
Artificial Intelligence, blockchain, ChatGPT (OpenAI), design pattern, design questions, software design, software development, STEEM, SteemIt, System Design
Yesterday, the ChatGPT has been integrated to Steem Blockchain, but the initial design has problems and so other bot commands e.g. !bing, !price, !info and !thumbup. The applications are …
Querying the Database e.g. MySQL could be very expensive relative to just a cache which is just a key value store . And for SELECT statements, we want to …
Given a table salary, such as the one below, that has m=male and f=female values. Swap all f and m values (i.e., change all f values to m and …
Given the following SQL Schema: Create table If Not Exists Employee (Id int, Name varchar(255), Department varchar(255), ManagerId int) Truncate table Employee insert into Employee (Id, Name, Department, ManagerId) …
SQL Left Outer Join can be illustrated by the following: where the query will take everything from left table and those fields from the right table. Let’s take a …