Recent questions tagged MySQL

0 votes

1.1k views

1 answer

mysql - What is the difference between "utf8_unicode_ci" and "utf8_unicode_520_ci"

I recently upgraded WAMPServer and now in phpMyAdmin, I see both collations utf8_unicode_ci and utf8_unicode_520_ci. I ... new *_520 collation? See Question&Answers more detail:os...

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

0 votes

775 views

1 answer

mysql - How can i synchronize two database tables with PHP?

I need to use PHP to copy data from one MySQL database to another. I can build and array of all the values to ... anyone tell me how to do this? See Question&Answers more detail:os...

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

0 votes

895 views

1 answer

mysql - Insert statement that checks for duplicate before insert

I need to make a insert but only if similar record don't exists for example: INSERT INTO requests ('user_id',' ... to use. Thanks in advance! See Question&Answers more detail:os...

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

0 votes

825 views

1 answer

mysql - Degrees of Separation Query

I have a table of member-to-member connections. The schema is member_id, friend_id, is_active. I want to ... performance or health over time. See Question&Answers more detail:os...

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

0 votes

897 views

1 answer

mysql - Effectively selecting the closest (distance) record from a database

I've got a database with a 40k venues and growing right now. Assuming I'm the red dot I want to be ... comment on answers within a few days. See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

mysql - PDO PHP insert into DB from an associative array

I have an array like this $a = array( 'phone' => 111111111, 'image' => "sadasdasd43eadasdad" ); When ... functions each type of update. Thanks. See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

mysql - Failed to read auto-increment value from storage engine, Error Number: 1467

When inserting data in mysql i get this error: Error Number: 1467 Failed to read auto-increment value from ... any help will be appreciated. See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

mysql - SQL Insert Into with Inner Join

I want to make my insert query which has an inner join to the Users table. The example of the tables is like ... Orders ON Orders.id = Users.id See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

mysql - Way to store various shop opening times in a database

I want to store opening times for different shops in a database. At the moment I am working with the ... store the information like this? See Question&Answers more detail:os...

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

0 votes

936 views

1 answer

mysql query result into php array

Some code here, I want store mysql query result into an array with php, but my code return result: 2h, not ... 32 http://localhost/img/img32.jpg See Question&Answers more detail:os...

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

0 votes

956 views

1 answer

mysql - COUNT(*) returning multiple rows instead of just one

Why does COUNT() return multiple rows when I just need the total count of how many rows my query generates? Should return 1078. 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 WooCommerce Coupons are stored in Database?

I need to run a script to check my coupons every time I have a new register, but I can't find ... coupon generator (WooCommerce) are stored. See Question&Answers more detail:os...

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

0 votes

799 views

1 answer

mysql - Does MS-SQL support in-memory tables?

Recently, I started changing some of our applications to support MS SQL Server as an alternative back end. One ... it with the permanent ones. See Question&Answers more detail:os...

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

0 votes

853 views

1 answer

mysql - Top N Per Group with Multiple Table Joins

Based on my research, this is a very common problem which generally has a fairly simple solution. My task ... help would be greatly appreciated. See Question&Answers more detail:os...

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

0 votes

847 views

1 answer

mysql - How to use multiple databases for one rails 3.1 app in Heroku?

My Rails 3.1 application connects to 2 databases, one is the default, the other is an Amazon RDS MYSQL instance ... which points to Amazon... 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 id HAVING maximum count of id

Have a products table with item_id and color_id. I'm trying to get the color_id with the most non-null instances. ... I want without 2 queries? See Question&Answers more detail:os...

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

0 votes

942 views

1 answer

mysql - Why is innodb's SHOW TABLE STATUS so unreliable?

I know that you shouldn't rely on the values returned by InnoDB's SHOW TABLE STATUS. In particular, the row ... Are they just corrupt in innodb? See Question&Answers more detail:os...

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

0 votes

798 views

1 answer

mysql - How to connect to 2 databases at the same time in PHP

I am trying to connect to 2 databases on the same instance of MySQL from 1 PHP script. At the moment the only ... the new one. Any other ideas? See Question&Answers more detail:os...

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

0 votes

868 views

1 answer

mysql - What is an index?

What is an index in MySQL ???? See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

mysql - How can I clear a transaction deadlock?

Using 'show engine innodb status' I see that wordpress has two deadlocks. I'd like to clear these up but I ... * WE ROLL BACK TRANSACTION (1) See Question&Answers more detail:os...

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

0 votes

965 views

1 answer

mysql - select multiple rows in one result row

In one of my tables i store my advertisement data, thats one row per advertisement. I also store some dates in an ... by a comma . Any ideas? See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

mysql - Sequelize bulkCreate() returns NULL value for primary key

I am writing rest using node, sequelize as ORM for mySQL. I am using bulkCreate function to create record in bulk. ... -29T07:39:50.000Z" } ] See Question&Answers more detail:os...

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

0 votes

764 views

1 answer

mysql - store TEXT/BLOB in same table or not?

While searching trough SO, I've found two contradicting answers (and even a comment that stated that) but ... a potential performance hit? See Question&Answers more detail:os...

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

0 votes

2.1k views

1 answer

mysql - spring data jpa utf-8 encoding not working

I use spring-data-jpa and mysql database. My tables character set is utf-8. Also I added ?useUnicode=yes&characterEncoding= ... -----------+ See Question&Answers more detail:os...

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

0 votes

888 views

1 answer

mysql - php sql join together multiple tables from different databases

I have 3 databases, and now I need to join several tables from each one of them into a singel query. How ... which database aswell in the query? See Question&Answers more detail:os...

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

0 votes

877 views

1 answer

mysql - how to do a split on a sql table column

I have a table that stores some comma separated strings. Is there a way to write a sql to return me ... obtained by splitting across commas. See Question&Answers more detail:os...

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

0 votes

877 views

1 answer

mysql - Delete all rows which has no id existing in another table

I want to delete all rows which has no existing foreign key in another table example: table1 +----+-- ... a relationship with table1 and table2. See Question&Answers more detail:os...

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

0 votes

740 views

1 answer

mysql - How to query counting specific wins of team and find the winner of the series

Table name: series_type id| type| description 1 | 0| No series (Any team win 1 will be the winner) 2 | 1| Best of 3 ... LV | LGD| 8313| 2| 3| 2| See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags