Asksearch_php.cn

Community

Learn

Tools Library

AI Tools

Leisure

English

Popular searches：
PHP
MySQL
jquery
HTML
CSS

About database queries

Regarding data query, how to query in order

驱魔鮔 2019-02-20 21:21:47

Query the data of a specified date in a specified table in mysql database? There are details

{Code...} The above is the existing query statement, which can find all the tables in the entire database and how much data is in the table. Now I want to break it down: For example, there are 1,000 tables in the test database, and I only want to check 200 of them (specified) that contain the specif...

PHP中文网 2017-05-18 10:49:37

How does Thinkphp query the database in batches?

1. I have such a requirement: there are 4 kinds of inventory in the warehouse receipt. I want to query whether there is such inventory in the existing table. If there is, increase the quantity. If not, create new data. The where condition is an array. How should I query? 2. where condition {code...}...

天蓬老师 2017-05-27 17:42:03

Use UNION in SQL to pivot data on two query results

I'm trying to get a pivot table of two query results from a MySql database Here is my SQL query: SELECT*FROM(SELECT'NotSpot'asNotSpot,SUM(builds.Duration)asDuration,DATE_FORMAT(builds.date,"%Y- %c-%d")asdateFROMbuildsJOINlabelsONbuilds.Labels_label_i

P粉642436282 2024-04-03 19:32:52

How to query the first 50 data in laravel's Eloquent ORM

{Code...} This is to investigate and deal with all products. I want to output 50 pieces of data on the html page first; when the user pulls down, go to ajax to query the subsequent data. How can I query the first 50 pieces of data for the data on the html page? And it is conditional. The product mus...

阿神 2017-05-16 16:56:07

How to use PHP to query database content and solve

Use PHP to interconnect with the database to realize PHP query of database content.

L W 2019-04-16 15:14:55

How to query the 5 pieces of data starting with a specified ID in laravel5.2?

For example, there are 10 pieces of data with IDs 1-10. Now I want to query the 5 pieces of data after the specified ID based on the passed ID. For example, if the input ID is 1, the query IDs are 1, 2, 3, and 4. ,5 data, if the incoming id is 3, how to query the data with id 3,4,5,6,7? Thank you

ringa_lee 2017-05-16 16:48:32

mysql - Query to modify the database optimization problem

I have a table with hundreds of thousands of data. Every time an event is triggered, all tables will be queried. If the conditions are met (most of them will be met), a certain field of the table data will be modified (the modified data will be different for each one). ) Please tell me how to do it ...

漂亮男人 2017-05-18 10:46:43

Looking for a data export after query in ThinkPhp 3.2

The student management system built using ThinkPhp 3.2 is always unable to export the queried data. What is exported is all the data, and the data exported by the sub-administrator is also all the data. The query at the front desk is appropriate but the export is inappropriate. Which one? The master...

为梦兼程 2019-04-20 10:40:12

When getting data from multiple tables, how to query based on entries in the table in SQL grouping

I have two tables click 2.ride click table id | time ride table id | timestamp I want to get data from both tables GROUPBYEXTRACT(DAYFROMride.timestamp) but only if I have same day in both tables I only get the data when an entry is made, but I need the data regardless of whether the two tables have...

P粉038856725 2024-04-04 08:58:17

Why is my TP5 database query so slow?

I am currently studying the ThinkPHP5 course. I saw that Teacher Zhu’s database query speed was 0.000239s, while mine was 1.027s. When the query statements are the same, the database is configured locally. Why is this?

3维 2019-09-29 11:31:14

PHP query data has no results

Weird problem. The code that worked before suddenly failed to produce results today. I used SQL statements to check the database and could find it. I don’t know where the problem lies. The PHP version number is 5.2.0. The code is as follows: {code...}

曾经蜡笔没有小新 2017-05-24 11:31:07

Learn how to use the JSR223 sampler to store SQL query results into a database table

Please provide step by step process how to connect MySQL database using jsr223 sampler and execute query and store the result in database table? Please provide sample code for this theme

P粉633309801 2023-08-29 22:13:53

How to sort query results according to fields of another table through chain operations in TP5

Specific situation: one user table and the other is a user level table. I query (select) the information of the user table and want to sort it according to the power field of the user level table. What I wrote myself is to query the records one by one through a for loop and then write them to In a t...

葫芦娃平衡盘 2018-04-19 16:50:01

MySQL query statement: display data for the last 4 weeks

How to write a query in MySQL to retrieve data for the past 4 weeks starting from today. I googled the query but I only get last week's data. The week should start today and last 4 weeks. The following is my data|sales|dated|---------------------------------|12|01-08- 202221:00||34|30-07-202221:00||...

P粉818561682 2024-04-01 13:12:56

Why can't I query the data after adding the where statement?

Why can’t I query the data after adding the where statement?

HZz 2018-03-31 14:57:59

java - Encountering problems with paging queries in Oracle database

This is the case. There is a field KS_ZKZ in my table. This field is not unique in the table. Each student number appears multiple times. Now I want to perform a paging query based on this student number: First, enter the student number. Repeat and sort in ascending order: {code...} After having thi...

PHP中文网 2017-05-17 10:04:43

How to build cross database query in PHP?

In our last episode (How to Build Cross-Database Queries in MySQL), I learned how to build cross-database queries in MySQL. This worked great, but when our hero tried to use this newfound knowledge in PHP, he found that his best friend failed. I looked into PHP's mysql_select_db. This seems to mean ...

P粉197639753 2023-10-22 11:40:00

How to use php+mysql to make dynamic data tables, urgent! ! !

How to use php+mysql to make dynamic data tables, urgent! ! ! How to use php+mysql to make dynamic data tables, urgent! ! ! How to use php+mysql to make dynamic data tables, urgent! ! ! How to use php+mysql to make dynamic data tables, urgent! ! ! How to use php+mysql to make dynamic data tables, ur...

joer 2021-05-12 02:06:09

python - Query data with flask+sqlalchemy

After I log in and it is included in the main page, will the data on the main page be received using a form? I don’t know how to put the found data on the page. Is there any information you can recommend or some guidance?

怪我咯 2017-05-18 10:59:39