Recent questions tagged MySQL

0 votes

700 views

1 answer

mysql - Could I make a column in a table only allows one 'true' value and all other rows should be 'false'

In MySQL, Can I put a restriction like below at database level? I need to make sure 1. a specific column can ... should be having 'true' value? See Question&Answers more detail:os...

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

0 votes

676 views

1 answer

mysql - 'LIKE ('%this%' OR '%that%') and something=else' not working

I have a select query where I am trying to search strings for multiple patterns LIKE ('%this%' or '%that%' ) ... both, how will it handle that? See Question&Answers more detail:os...

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

0 votes

689 views

1 answer

mysql - Handling large records in a Java EE application

There is a table phonenumbers with two columns: id, and number. There are about half a million entries in the ... a limited no. of people. See Question&Answers more detail:os...

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

0 votes

606 views

1 answer

mysql - SQL Scripts - Does the equivalent of a #define exist?

I have a script that I use to construct both the tables and stored procedures. For example I have a column ... a solution to this problem? See Question&Answers more detail:os...

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

0 votes

842 views

1 answer

mysql - Removing duplicate rows from a table

id lat long speed date address 1 22.92138131 72.44103313 3.96 km/h 2011-09-26 National, Gujarat, India ... rows according to the address. See Question&Answers more detail:os...

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

0 votes

859 views

1 answer

mysql - Python MySQLdb WHERE SQL LIKE

I have recently started to learn Python and MySQL for web purposes and I have run into a following problem : I ... c.close() Thanks in advance. See Question&Answers more detail:os...

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

0 votes

608 views

1 answer

mysql - Minimal example of using select... for update to isolate rows

UPDATE: There is now SKIP LOCKED and NOWAIT for Mysql and Postgres. Old question follows. I want concurrent ... affected (0.00 sec) See Question&Answers more detail:os...

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

0 votes

825 views

1 answer

mysql - How to cascade persist using JPA/EclipseLink

I am having problems performing a cascade persist operation on a parent entity. When the child entity is persisted, the ... ('addr_gen', 0); See Question&Answers more detail:os...

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

0 votes

685 views

1 answer

mysql - How to cascade persist using JPA/EclipseLink

I am having problems performing a cascade persist operation on a parent entity. When the child entity is persisted, the ... ('addr_gen', 0); See Question&Answers more detail:os...

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

0 votes

634 views

1 answer

mysql - Minimal example of using select... for update to isolate rows

UPDATE: There is now SKIP LOCKED and NOWAIT for Mysql and Postgres. Old question follows. I want concurrent ... affected (0.00 sec) See Question&Answers more detail:os...

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

0 votes

955 views

1 answer

mysql - How to cascade persist using JPA/EclipseLink

I am having problems performing a cascade persist operation on a parent entity. When the child entity is persisted, the ... ('addr_gen', 0); See Question&Answers more detail:os...

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

0 votes

717 views

1 answer

mysql - Python MySQLdb WHERE SQL LIKE

I have recently started to learn Python and MySQL for web purposes and I have run into a following problem : I ... c.close() Thanks in advance. See Question&Answers more detail:os...

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

0 votes

709 views

1 answer

mysql - Minimal example of using select... for update to isolate rows

UPDATE: There is now SKIP LOCKED and NOWAIT for Mysql and Postgres. Old question follows. I want concurrent ... affected (0.00 sec) See Question&Answers more detail:os...

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

0 votes

804 views

1 answer

mysql - How to cascade persist using JPA/EclipseLink

I am having problems performing a cascade persist operation on a parent entity. When the child entity is persisted, the ... ('addr_gen', 0); See Question&Answers more detail:os...

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

0 votes

605 views

1 answer

mysql - 'LIKE ('%this%' OR '%that%') and something=else' not working

I have a select query where I am trying to search strings for multiple patterns LIKE ('%this%' or '%that%' ) ... both, how will it handle that? See Question&Answers more detail:os...

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

0 votes

663 views

1 answer

mysql - Handling large records in a Java EE application

There is a table phonenumbers with two columns: id, and number. There are about half a million entries in the ... a limited no. of people. See Question&Answers more detail:os...

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

0 votes

703 views

1 answer

mysql - SQL Scripts - Does the equivalent of a #define exist?

I have a script that I use to construct both the tables and stored procedures. For example I have a column ... a solution to this problem? See Question&Answers more detail:os...

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

0 votes

946 views

1 answer

mysql - Removing duplicate rows from a table

id lat long speed date address 1 22.92138131 72.44103313 3.96 km/h 2011-09-26 National, Gujarat, India ... rows according to the address. See Question&Answers more detail:os...

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

0 votes

731 views

1 answer

mysql - Python MySQLdb WHERE SQL LIKE

I have recently started to learn Python and MySQL for web purposes and I have run into a following problem : I ... c.close() Thanks in advance. See Question&Answers more detail:os...

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

0 votes

758 views

1 answer

mysql - Minimal example of using select... for update to isolate rows

UPDATE: There is now SKIP LOCKED and NOWAIT for Mysql and Postgres. Old question follows. I want concurrent ... affected (0.00 sec) See Question&Answers more detail:os...

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

0 votes

790 views

1 answer

mysql - How to cascade persist using JPA/EclipseLink

I am having problems performing a cascade persist operation on a parent entity. When the child entity is persisted, the ... ('addr_gen', 0); See Question&Answers more detail:os...

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

0 votes

840 views

1 answer

mysql - Delete huge amounts of data from huge table

I have two tables. Let's call them KEY and VALUE. KEY is small, somewhere around 1.000.000 records. VALUE ... Some nice tricks that could help? See Question&Answers more detail:os...

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

0 votes

676 views

1 answer

mysql - Many tables or rows, which one is more efficient in SQL?

I'm building a program that stores news headlines for companies and its timestamp from various sources. Let's ... terms of performance and why? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

mysql - Illegal mix of collations for operation 'concat'

I'm trying to execute this concat query in mysql SELECT CONCAT(if(fName,fName,''),Name) From Student ... of collations for operation 'concat' See Question&Answers more detail:os...

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

0 votes

732 views

1 answer

mysql - What does # mean in sql?

Does anyone know what something like OR 1# means in the context of mysql injection? See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

mysql - Why does Rails ignore a Rollback in a (pseudo)nested transaction?

As per the docs ActiveRecord::Transactions::ClassMethods, a non-new nested transaction will ignore a Rollback. From ... within a nested child? See Question&Answers more detail:os...

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

0 votes

921 views

1 answer

mysql - spring jpa application.properties useSSL

I am trying to turn off ssl, to my local mysql database. But I cannot find the actual property in a ... mysql://localhost:3306/test&useSSL=false See Question&Answers more detail:os...

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

0 votes

803 views

1 answer

mysql - Get row with highest or lowest value from a GROUP BY

I'm trying to get the row with the highest/lowest number, after performing a GROUP BY: Here is my test data ... on what the lowest value is? See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags