sql tag

625 questions


1 answers
55 views
0
Understanding Shell Conditional Expressions

#!/bin/sh# variable settingexport BATCH_E=$(cd$(dir$0)/..&pwd)source$BATCH_E/bin/conf/batch.conf# Batch processing typeTYPE='25'# Launching the JAVA$SH_COMMAND $BATCH_RUNNER_SH batch.Dataupd $TYPE...

1 years ago

3 answers
77 views
0
I want to replace Distinct with Exist in SQL

To speed up the query of the search results, I wanted to replace Distinct with Exist, but it was too complicated for me to replace it well.There are two, but they are as follows.Also, when I measured ...

1 years ago

1 answers
90 views
0
Please teach me about SQL.

Thank you for taking care of me.I would like to get data with the same ID, date, and serial number, code 1234 and 1235.tableA ID Date Serial Number  Code 120060223 1 1234 120060223 1235 120060415 111...

1 years ago

1 answers
93 views
0
I want to set search criteria from outside for subqueries that are being viewed in SQL SERVER

I wanted to manage the history of the data, so I tried to create the following view in SQL SERVER.I don't know how to set conditions externally for columns in subqueriesIf you don't give the condition...

1 years ago

1 answers
43 views
0
Understanding Partial Matching for Ambiguous Searches

% value %This is a conditional expression using LIKE that allows to retrieve partially matched records.I am currently writing the basic processing of the search function that retrieves data from MySQL...

1 years ago

1 answers
114 views
0
Database Errors in Chef Solo

[Question] $bundle exec knife solo cookie node nameThe following error occurs in Error executing action create on resource 'mysql_database [aws]'*Currently, recipes that do not use database are workin...

1 years ago

1 answers
32 views
0
Ravel8 Which SQL query is better?

There are two tables. ArArticlesList of articles posted by users FFavoritesList of articles that users have registered as favoritesThe article and its information are registered in には.② will have the ...

1 years ago

1 answers
50 views
0
CakePHP does not display modified correctly.

I recently started studying CakePHP.I'm suffering from an error right away...I think it's a rudimentary problem, so If anyone knows, please reply.<div class=topics index> <h2><?phpecho_...

1 years ago

1 answers
35 views
0
On duplicate key update lock conditions

Access MySQL on AWS RDSWhen adding API (Apache+Fuel PHP) and performing load testWhile Apache stopped accepting connections, Waiting for RDS logs on RDS performance insights synch/cond/mysys/my_thread...

1 years ago

2 answers
53 views
0
MyBatis only gives errors when there are many parameters

Operating Environment org.postgresql:postgresql:9.3-1102-jdbc41org.mybatis:mybatis:3.2.7Connecting to RedShift to retrieve dataSELECT* FROM sample_table WHERE <foreach item=item collection=lists op...

1 years ago
« - 36 - »

© 2024 OneMinuteCode. All rights reserved.