625 questions
There is a table called A. If A has 10 data, compare these 10 data under certain conditions조건에 맞는 데이터들만 뽑으려면 어떻게 해야하나요? EX) Outputs a list of data of which the value of the column id is different amon...
While creating a web page, I realized that there are absolute and relative paths when setting the image path.There is a picture called everyow.gif called C:\Document\Homepage\image.Absolute path img s...
I am using Postgresql DB.I want to read the created_at column value and check how many hours of row it was created.select EXTRACT(HOUR FROM (NOW() - created_at)) as agefrom tableThe prices are coming ...
Hello, everyoneWhen defining the Django model fieldDefine the primary key id = models.IntegerField()Is there a way to make the ID number automatically increase per row like AutoField?
Hi, everyone. Shoveling now because of group_concat().First of all, select group_concat(cu1.cu_inflow_type),count(cu1.cu_inflow_type) from cu_test cu1 left join cu_test cu2 on cu2.seq=cu1.seq group b...
You want to get the number of all rows in the database.Right now $sql = SELECT table_name , table_rows FROM INFROMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'Table Name'; $res = mysqli_query($conn, $s...
ex) select distinct(user_level) from UserInfo; ex) select min(play_time) from UserInfo where user_lever in(select distinct(user_level) from UserInfo)I thought this would list the minimum play time for...
There are two tables, A and B.A is a post, and B is a comment on the post. Like a typical bulletin board, a list of posts is printed, and I want to print a list of comments at the bottom of each list ...
Hello, incumbent a newcomer to the society as a planning service 21 years old!I am studying mysql at the company and learning to manage data such as sales.We are currently creating a data table that c...
How do I access my MySQL database from Java?
| « | - 55 - | » |
© 2024 OneMinuteCode. All rights reserved.