sql tag

625 questions

1 answers
42 views
0

I want to determine if there is a record that matches the condition in SQL.

tableAID YMD DAY SECSE CODE22 1997090100 KG0010022 199709010 10 KG0061022 199709010 11 KG0104222 199709010 12 KG0036122 199709010 13 KG0036322 199709010 20 KG0115022 199709010 30 KG0163122 199709010 3...

c# sql

2 years ago

1 answers
105 views
0

LiferayA portlet that connects to MySQL in the local environment and outputs elements of the table.

I was trying to use the JDBC driver to display the acquired value in jsp, but I looked it up and found that it is common to use Service Builder to retrieve and display values.I even set the table defi...

java mysql jsp framework

2 years ago

1 answers
44 views
0

Mysql also retrieves unlinked data from two tables

When I retrieve data from two tables like the one below, I would like to obtain category data that does not have any categories attached to the template. What should I do?If possible, I would like to ...

mysql

2 years ago

3 answers
48 views
0

Selectively extract data from mysql SELECT statements

I want to extract a record with four fields: id category user_id text and user_id 1 .However, if there is a record with user_id of 5 in the same category, I would like to extract that record first.Is ...

mysql

2 years ago

1 answers
44 views
0

Deleting by Conditions Using Multiple Tables in MySQL

I would like to extract duplicate data from two tables in MySQL and delete duplicate data.This is what I'm thinking.Suppose you have a table like this.Table A |Address|Date of birth|Name|| XX City | J...

mysql sql

2 years ago

1 answers
42 views
0

Error logging in My SQL

When logging in with mysql-h%-uroot-pERROR 2005 (HY000): Unknown MySQL server host '%' (0) will appearHow can I solve this problem?

mysql

2 years ago

1 answers
54 views
0

Is it possible to use the WITH clause in the IN clause?

Is it possible to include the WITH clause in the IN clause as shown in SQL below?SELECT* FROM customer WHERE id IN( WITH_t2AS (SELECT id FROM t2 WHERE id > 1) SELECT* FROM t1 WHERE id1 IN (SELECT i...

postgresql

2 years ago

1 answers
111 views
0

I want to add a search function to the list screen.

We are creating a system that allows you to apply for overtime on the web using PHP.I want to display everything you have applied for in the list so that you can search at the top of the screen.I want...

php mysql pdo

2 years ago

1 answers
48 views
0

Why is RENAME DATABASE dangerous?

Found this keyter while renaming the database.Enable RENAME DATABASE without dumping in MySQLAt the beginning of the article, it says, The phantom command whose existence has been erased because of it...

mysql sql

2 years ago

1 answers
145 views
0

I don't know how to connect PgAdmin4 to a DB container containing data on docker.

I would like to connect PgAdmin4 to a DB container with data in Win10 and WSL2 and operate it from a browser.Use the following containers with data, and they seem to be doing well, so you can throw a ...

docker postgresql docker-compose wsl

2 years ago

- 23 -

Popular Tags

python x 4647

android x 1593

java x 1494

javascript x 1427

c x 927

c++ x 878

ruby-on-rails x 696

php x 692

python3 x 685

html x 656