sql tag

625 questions


1 answers
81 views
0
Cannot enter the database within Postgresql.

https://github.com/blobmon/simplechanI want to enter the database as a user, but I can't.Now, once you are back again being the normal, default user, cd into /sql/ directory in Simplechan repository.W...


1 answers
75 views
0
I am creating a site for uploading images with php and mysql...

I am a beginner about php, mysql.As stated in the title, I am currently using php and mysql to create an image upload page, but it does not work.I was told that it was not acceptable to register binar...

1 years ago

1 answers
124 views
0
Understanding Data Combination in MySQL

The following databases are available:Please let me know if there are any SQL statements that combine the same names but lack data.

1 years ago

1 answers
121 views
0
Migration does not work.I am using laravel 5.6.

Migration does not work.I am using laravel 5.6.We are doing the first slide 66 below.https://schoo.jp/class/3651#Run Results phpartisan migrate<!doctype html><html><head><title>...

1 years ago

1 answers
80 views
0
I want to create a search page with php and extract records according to the conditions from DB.

Created a search page where you can extract data from DB.(index.php)However, even if I specify conditions, I can't pull records according to those conditions from DB well...[What do you want to do?] I...

1 years ago

1 answers
123 views
0
Table is locked when connecting to SQL server in EXCEL query

as stated in the titleWhen you connect to SQL Server from an Excel query, the table is It locks until you exit Excel.- Only SELECT privileges for connected users- Application is Mashup Engine-Queries ...

1 years ago

2 answers
51 views
0
extracting and sorting mysql maximums

I would like to ask you an additional question regarding the contents of your reply.mysql Work Data ID Extraction Across DatesThe ID is now displayed every 15 minutes as shown below.この I would like to...

1 years ago

1 answers
98 views
0
SQL Injection Countermeasures Using Slick in Playframework 2

Currently, I am trying to list the words entered from the form that match the title.defindByWord(word:String): Future [Seq[Item]]=db.run{ Query.filter(row=>(row.title like % + word+%).result}This i...


2 answers
34 views
0
About SQL Errors (1064)

Using HeidiSQL 9.4.0.5125I copied 2-4 exactly from the following sites and changed the table name to tmptreagency and the column to name.http://www.geocities.jp/mickindex/database/db_tree_ns.html#Loca...

sql
1 years ago

1 answers
78 views
0
I would like to improve the speed of SQL statements (with code) that INNER JOIN 12 tables.I have changed it to LEFT OUTER JOIN, but it does not lead to improvement.

SQL statements include:In this SQL, there are only two tables that are INNER JOIN and WHERE statements.This will take about 10 seconds to complete the aggregation.However, due to this requirement, the...

1 years ago
« - 8 - »

© 2024 OneMinuteCode. All rights reserved.