Recent questions tagged MySQL

0 votes

1.3k views

1 answer

mysql - Spring data query for localdate returns wrong entries - minus one day

In my Entity i have a field of type LocalDate "day" in MySQL it is mapped to "date" type. MySQL seems ... (TimeZone.getTimeZone("UTC")); works See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

mysql - create database with pdo in php

When I create database without using bind param, it works perfectly. $login = 'root'; $password = 'root'; $dsn = ... 2 by reference on line 17 See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

mysql - Count of other rows in table with the same value

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

mysql - Why can't I use a variable as the table name in a stored procedure?

I'm trying to use a variable as the table name within a stored procedure and it's using it as a string literal instead of ... ---------------- See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

mysql - Triggering a Java program based on database updates and time interval

I want a mechanism that will start a java program ( quite a big one ) depending on 2 conditions: N new ... option that I am overlooking at? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.0k views

1 answer

mysql - How to sort results order by timestamp except one of them?

I have a table like this: // Mytable +----+--------------------+------+------------- ... BY Type, {I need to add something here}, timestamp See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

985 views

1 answer

mysql - Multiple relationships between two entities, is this good practice?

I have the following typical scenario regarding an office and its staff: Each staff member belongs to one office ... the scenario. Many thanks See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

938 views

1 answer

mysql - Select all rows that have at least a list of features

I have EXPERIMENTAL_RUNS (runId), each of which have any number of SENSORS (sensorId) associated with them. With that in ... 11 AND 13 AND 15. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

mysql - Displaying Date from database PHP

right now I'm storing a date in the database, in the format date("Y-m-d") and im storing it in ... display it like October 31st 2010 Thanks! See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

929 views

1 answer

mysql - How can I use JOIN in UPDATE statement?

I have a table like this: // QandA +----+----------------------------------------+-------- ... .related AND accepted = 1 ) ) OR free IS NULL ) ) See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

mysql - BCrypt Verify stored password hash

Storing the hashed password in database is successful. But when verifying if the input password and the hash stored ... .Focus()) End If See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

2.2k views

1 answer

mysql - Failed to add the foreign key constraint. Missing index for constraint Error Code: 1822

So I'm trying to create a table 'Prerequisite_to', which is basically a relation that shows what classes are ... table 'Class' 0.00038 sec See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

951 views

1 answer

mysql - ckfinder php 2.6.2 settings view, display, sorting doesn't working

the example Functions are not working. someone with the same problem? any suggestion? thanks See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

mysql 5.5 - how to do LOAD DATA LOCAL INFILE in laravel 5.4

i need to convert the following query in laravel 5.4 $loadDataToTempTableSql = "LOAD DATA LOCAL INFILE '".$filename." ... guide, what to do? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

mysql - Datetime in PHP Script

I use a PHP script for a banlist that fetches the date and time, but I have an error and don't know how ... '] this comes all from the plugin See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

mysql - How to use CASE function in ORDER BY?

My friend asked a question a few times ago. Also there is a answer under that and it is good, but not ... 0 means question and 1 means answer See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.0k views

1 answer

mysql - Best and optimal way to join max value from other table

I want to find the optimal way to run this query, here the details, lets say the following are my tables with ... Is there any other better way? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.0k views

1 answer

mysql - How to differentiate between same field names of two tables in a select query?

I have more than two tables in my database and all of them contains same field names like table A table B table ... them all in a single query? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

mysql - Calculating distance (pythagoras) and running count in sql query

I am trying to build a rather complicated query in SQL, and being a beginner i would immensely appreciate some ... for helping a newbie out! See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.0k views

1 answer

mysql - How to create a stored procedure containing a DELIMITER in PHP with PDO?

In my model I defined some procedures. The code (generated by MySQL Workbench) contains DELIMITER ... containing DELIMITER statements? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

mysql combine query results side by side

Simple question that I cant get my head around. I want to just combine two tables with no common data side by side. table1 ... c d g h i j i j See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

mysql - PHP form not uploading file

I have a PHP form that is inserting information into a database. It all works except for the file upload. ... .php?add=success");` See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

mysql - Updating Already Checked Checkboxes in PHP

let's say I have a list of checkboxes that the user selects. <input type="checkbox" name="utility[]" id=" ... has already been checked in PHP? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.0k views

1 answer

mysql - Select rows from one table, join most recent row from other table with one-to-many relationship

What I would like to do is select a specific set of rows from one table (table A) and join with ... somewhere, or something similarly easy. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.0k views

1 answer

mysql - Configure mail server to work with PHP

My current project is a form that receives input from a user. After I receive that data, I must send a ... anyone recommend a good mail server? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

mysql - SQL: SUM the MAX values of results returned

The following SQL statement produces the results listed below. Question is, how do I modify this statement to provide ... 101; = 6,904 Thanks See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

997 views

1 answer

mysql - First three Groups with Highest Marks should have specific points

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

mysql - Which DB design is faster: a unique index and INSERT IGNORE, or using SELECT to find existing records?

I have a table with just one column: userid. When a user accesses a certain page, his userid is being inserted ... found. Which one is faster? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

Categories

Just Browsing Browsing

Most popular tags