9 questions
There is a table as below.Books Table-----------------------COLUMN NAME | TYPEid | integername | character varyingsubjects | character varying [] subjects array types when is stored as the {educat...
I want to search using SELECT statement in php file, but if the value of the search is title and the title part of the database is 'Jeju Rape Flower Festival' and only 'Jeju Island' can I get a query ...
There is a table that takes the user ID (INT) and login time (Timestamp) as columns, and INSERTs the record once every time the user logs in.I'd like to get the number of duplicate daily visitors from...
Here's what I want to do.Example A)select col_name from table_a where col_name like '%val%';Result A)val1val2val3Example B)select col, count(col) from table_bwhere color '%result A value 1%' OR color ...
The table structure is shown below. What I want to show you is to show the materials that belong to the product in the product list. Product 1 | (Material 1, Material 2) Product 2 | (Material 1, Mater...
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...
I want to set the same string to always be entered in one property in the table.What should I do>?
As the title suggests, when importing a value from DB, the input value is an array. Unfortunately, it would be nice if the DB column corresponds 1:1 with each value in the array, but it is not.In DB, ...
I made a GROUP based on ID in Table A.SELECT TOP 200 A.ID,COUNT(A.ID) AS CNT FROM A A LEFT join ANAME as Aname on A.ID = Aname.ID LEFT join BNAME as Bname on Aname.SEQ = Bname.SEQ where A.POI_ID > ...
© 2024 OneMinuteCode. All rights reserved.