kimjunki-8 님의 블로그

Starting SQL basic information1. creating a databaseCREATE DATABASE (name of database);2. creating tablesCREATE TABLE name of the table (     column1 data type    column2 data type    ... );Ex.CREATE TABLE students (     id INT, -> id: A column that stores integer data (`INT`).    name VARCHAR(50), -> A column that can store a string of up to 50 characters (`VARCHAR(50)`).    age INT -> A column..

DB -> DataBase = In short, it's a big folder storing dataSELECT/FROMselect * -> used when getting the data. used to all the Query viewing datafrom food_orders * -> Bring all the columnfrom-> statement to specify the table when bringing dataSelecting necessary parts of the columnselect restaurant_name, addrfrom food_orders select (specific name of the column), (specific name of the column), ....f..

starting with formEx.   Name:         Email:         Submit -> Send the user's input data to the serveraction = ->Specifies the URL to which the data will be sent (/submit is the server's endpoint to process the data).method method: Specifies the HTTP transfer method. GET and POST are mainly used.GET: Sends data as a query string in the URL.POST: Sends data as the body of the HTTP request. Ex. ..

Ah....Ah....................Ahh...how to use variables. var, let, constvar = -> function scope, may cause an error, not much used.let = -> Block scope, mostly used, can be reallocated.const = -> Unlike let, this cannot be reallocated.Ex)var name = "John";  // function scopelet age = 25;       // block scopeconst country = "Korea";  // cannot reallocated Conditional statements and loopsif, else i..

AAAAAAAAAAAAAAAAAAAAaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa.............I don't know when all the things went wrong    Command Palette -> Python: Create Environment... -> Venv -> Python 3.8.6 64-bitIt was wrong...it showed an error codeSo, I tried all the way to make it through Chat GPTfrom flask import Flask, render_template, requestimport requestsapp = Flask(__name__)res = requests.get(    "http://kobi..

Today,I've made a lottery site(quite hard....)From this, I was able to learn how to make a server. (flask, venv)flask folder structure- - - flask |— venv |— app.py (server) |— templates          |— index.html (client file)I could not understand the whole part, but I could get some ideas(like the frame itself?)it was a great chance to get close to ChatGPT. from flask import Flask, render_template..

Today, I learned about the function, for(foreach), if(if-else), jQuery, and Fetch -> it was hard :For function. It's like a vending machine -> If I order, it will automatically give me what I want.Ex.body>    script>        function state (x, y) {            return x + y        }        console.log(state('hi', 'hello')) //hihello    script>body>Make a box named 'state' and put (x, y) next to it...

Today, I finished studying with variable, operator, list, and dictionary.For variable, it's like a box with a number or any type of code inside.Ex.let a = 10 -> I'm putting 10 inside to 'a'Then I don't have to write 10 every time I need but I can use variable 'a' like console.log (a)or I can use it with operatorconsole.log(a+10)**%/+whateveras well as the list and dictionaryIt will be very borin..

Today, I finished chapter 1.I am unsure if I fully understood, but I'm sure I was pretty funny.There are some points that I must remember.1. Never try to understand all the codes -> because I will find the codes I need on the internet.2. not all CSS should be written in the head part but also the body part. -> Only on the codes I want3. If there is a problem I can't get into it, try to search it..

Today, I learned about GTP web development.1. How the web works-The web browser receives the codes of HTML and turns them into an actual web page(which we can interact with)Let's say putting a web address on the search bar -> asking the web browser that contains the HTML codes to turn them into an actual web page 1. client - gives the HTML codes to the server(in page address form).2. server - re..