Programmer Think

Interview Handwritten SQL - Ask questions for 3 consecutive days, and finally meet! Some time ago when I went to a company in Shanghai for an interview in autumn enrollment, I was confused. The interviewer directly asked me to write SQL on the spot. The Title I gave was also confused at that time. The Title sounded not difficult, but the inter ...

JDBC introduction JDBC(Java Database Connectivity) is a common interface (a set of API s) independent of a specific database management system and general SQL database access and operation. It defines the standard Java class libraries used to access the database (java.sql,javax.sql). These class libraries can be used to access database res ...

catalogue 3, DDL and DML 1, Data Definition Language DDL 1. Database creation (1) Create database (2)   Delete database (3)   Use database (enter database) 2. Creation of data table (1)   Create data table (2)   View table structure (3)   Modify table structure ① Add column in table ② Delete columns in table ...

In the process of using the database, the most exposed is the table in the database, which stores all the data in the database. Therefore, the table is the basic information storage structure of SQL Server database system and the most important part of the database. Managing the table naturally manages the database. 1. Data sheet overview & ...

From: Jian Shu, author: Wangcai doesn't cry Link: https://www.jianshu.com/p/d4b012769a3b After a long test, I will migrate to mysql8.0 as a whole; Mysql8.0 adds / optimizes many related JSON API operations for JSON operations; After reading the official documents, although most JSON operations are completed by the application layer, you can ...

Multi table query, also known as association query, refers to two or more tables completing the query operation together. Prerequisite: these tables queried together are related (one-to-one, one to many). There must be an associated field between them. This associated field may or may not have a foreign key. For example, employee table a ...

Wan A10: how does mysqldump achieve consistent backupExperimental sceneMySQL 8.0.25 InnoDBExperimental steps:Start general first_ Log observe the changes in the export execution processset global general_log=ON;mysqldump key parameter description:--Single transaction parameter description:Set the isolation level to REPEATABLE READ and start a r ...

Advanced 1. Direct query – single field in query table – select sNo from student; – single field in query table – select sNo, sName from student; – query all fields in the table select * from student; Note: which library to use when querying all fields 2. Query constant value select 100; select 'male'; ...

1. View A view is a virtual table, which is different from a direct operation data table. A view is created based on a SELECT statement (which will be described in detail below). Therefore, when operating a view, a virtual table will be generated according to the SELECT statement that created the view, and then SQL operations will be performed ...

Part 1: init initializes MySQL connection related API s: (1) mysql_init : MYSQL* mysql_init(MYSQL *mysql); Returns a MySQL handle. Corresponding to this handle, MySQL will allocate an object in the database and open up memory to store the processing information associated with the connection. All subsequent operations on this database conne ...