Recent questions tagged MySQL

0 votes

474 views

1 answer

mysql - Rails 3 - Eager loading with conditions

Okay, I'm thoroughly stumped on this one. I'm trying to build a menu of published web pages organized by ... } Thanks again for your help. See Question&Answers more detail:os...

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

0 votes

630 views

1 answer

mysql - is there a length limit to group_concat or another reason why it would not work on a text field

First, here is the query: SELECT GROUP_CONCAT(title) title, GROUP_CONCAT(description) description, skill_id, count(*) ... this would not work? See Question&Answers more detail:os...

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

0 votes

415 views

1 answer

mysql - Encryption at rest and/or AES_ENCRYPT

I am trying to improve the security a a MySQL database that will contain sensitive data. I am struggling to ... use AES_ENCRYPT instead/as well See Question&Answers more detail:os...

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

0 votes

516 views

1 answer

mysql - Show all dates between, even if no result

SELECT User_JoinDate, COUNT(User_ID) FROM Users WHERE `User_JoinDate` BETWEEN '2012-11-22' AND '2012-12- ... implementations. Any suggestions? See Question&Answers more detail:os...

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

0 votes

738 views

1 answer

mysql - How to allow fulltext searching with hyphens in the search query

I have keywords like "some-or-other" where the hyphens matter in the search through my mysql database. I'm ... ) ORDER BY score DESC "; See Question&Answers more detail:os...

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

0 votes

774 views

1 answer

mysql - Execute INSERT if table is empty?

Is there a way to do an insert under a count condition, something like: INSERT INTO my_table (colname) VALUES('foo' ... empty. I'm using mysql. See Question&Answers more detail:os...

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

0 votes

355 views

1 answer

mysql - Display all tables. Describe-like functionality

How can I display all tables in a database similar to the output like DESCRIBE myTable. Adding functionality for: ... like to award this bounty. See Question&Answers more detail:os...

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

0 votes

580 views

1 answer

mysql - java.sql.SQLException: Field 'supplier_id' doesn't have a default value

I got an error message from this： java.sql.SQLException: Field 'supplier_id' doesn't have a default value at com. ... mysql-connector-java-5.0.8 See Question&Answers more detail:os...

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

0 votes

954 views

1 answer

mysql - SQLSTATE[HY000]: General error: 1835 Malformed communication packet on LARAVEL

Suddenly got SQLSTATE[HY000]: General error: 1835 Malformed communication packet (SQL: select * from tb_users where ... Any experience in this? See Question&Answers more detail:os...

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

0 votes

433 views

1 answer

mysql - Inventory management with stock options

I'm trying to create an inventory management schema where I can track the stock of various options related to ... sizes and colors for each. See Question&Answers more detail:os...

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

0 votes

745 views

1 answer

mysql - Array data type, split string,

I'm currently working on a function in MYSQL, I have a comma delimited string (1,22,344,55) from another table, ... where I can do foreach()? See Question&Answers more detail:os...

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

0 votes

472 views

1 answer

mysql - Database Historization

We have a requirement in our application where we need to store references for later access. Example: A user can ... from the db? Thank you! See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

mysql - PHP Laravel: No connection could be made because the target machine actively refused it

I am building a web application in Laravel 5. The application is supposed to get "category names" stored on a ... be denying access to Laravel? See Question&Answers more detail:os...

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

0 votes

504 views

1 answer

mysql - What are the max number of allowable parameters per database provider type?

There is a limit of 2,100 parameters which can be passed to a Sql Server query i.e. via ADO.Net, ... MySql PostgreSql Sqlite Does anyone know? See Question&Answers more detail:os...

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

0 votes

690 views

1 answer

mysql - BIGINT UNSIGNED value is out of range

I am getting the error BIGINT UNSIGNED value is out of range in '(1301980250 - mydb.news_articles.date)' When I run ... 5.5.x Any help please? See Question&Answers more detail:os...

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

0 votes

515 views

1 answer

mysql count into PHP variable

Let say that we have the following query: SELECT DISTINCT COUNT(`users_id`) FROM `users_table`; this query will ... you recommend to do this ? See Question&Answers more detail:os...

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

0 votes

652 views

1 answer

mysql - php (fuzzy) search matching

if anyone has ever submitted a story to digg, it checks whether or not the story is already submitted, I assume ... be up to 250chars in length See Question&Answers more detail:os...

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

0 votes

452 views

1 answer

mysql - How do I limit the number of rows per field value in SQL?

For example, I have a table like this in Hive: 1 1 1 4 1 8 2 1 2 5 3 1 3 2 and I want to only return the first two ... 1 1 1 4 2 1 2 5 3 1 3 2 See Question&Answers more detail:os...

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

0 votes

507 views

1 answer

mysql - Python's MySqlDB not getting updated row

I have a script that waits until some row in a db is updated: con = MySQLdb.connect(server, user, pwd, db) ... JDBC, that is set on autocommit. See Question&Answers more detail:os...

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

0 votes

504 views

1 answer

mysql - Entity Framework C# Insert Data russian encoding problems

I'm using an EDM model in my project. When I insert russian words in the database via a post ... DEFAULT CHARSET=utf8 COLLATE utf8_unicode_ci; See Question&Answers more detail:os...

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

0 votes

478 views

1 answer

mysql - Why in SQL NULL can't match with NULL?

I'm new to SQL concepts, while studying NULL expression I wonder why NULL can't match with NULL can anyone ... example to simply this concept? See Question&Answers more detail:os...

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

0 votes

651 views

1 answer

mysql - What does SQL Select symbol || mean?

What does || do in SQL? SELECT 'a' || ',' || 'b' AS letter See Question&Answers more detail:os...

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

0 votes

464 views

1 answer

mysql - recursive self query

I have the following table: myTable: +----+----------+ | id | parentID | +----+----------+ | 1 | null ... WHERE id=5" would give me: 5, 4, 2, 1 See Question&Answers more detail:os...

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

0 votes

469 views

1 answer

mysql - how to bind dynamic json into treeview wpf

I get JSON as follow: explain format = json select... Text is different depending on the type of operator select. ... UML in wpf. Thx for advice See Question&Answers more detail:os...

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

0 votes

557 views

1 answer

mysql - Rails select random record

I don't know if I'm just looking in the wrong places here or what, but does active record have a method for ... . I'm using mysql as well. See Question&Answers more detail:os...

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

0 votes

962 views

1 answer

mysql - Split comma delimited string --> FUNCTION db.CHARINDEX does not exist

I need to split comma delimited string into a second columns I have the following table : CL1 POS POS2 LENGHT ... test.CHARINDEX does not exist See Question&Answers more detail:os...

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

0 votes

589 views

1 answer

mysql - How to select non "unique" rows

I have the following table, from which i have to fetch non unique rows +------+------+------+ | id | ... b WHERE a.RVT_ID=b.RVT_ID GROUP BY idA) See Question&Answers more detail:os...

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

0 votes

573 views

1 answer

mysql - How to SELECT by MAX(date)?

This is the table structure: CREATE TABLE `reports` ( `report_id` int(11) NOT NULL auto_increment, `computer_id` int( ... clue how to do that. See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags