Recent questions tagged MySQL

0 votes

776 views

1 answer

mysql - Using LIKE vs. = for exact string match

First off, I recognize the differences between the two: - Like makes available the wildcards % and _ - significant ... that it doesn't matter? 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 escape underscore in the string query in hibernate and SQL?

The _ (underscore) given in the SQL query is not honored. Example : SELECT * FROM employee WHERE NAME LIKE ' ... and also in Hibernate? Thanks. See Question&Answers more detail:os...

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

0 votes

763 views

1 answer

mysql - NULL value in multi-column primary key

I've got a table with several columns making up the primary key. The nature of the data stored allows some of these ... , say, '0' for NULL? See Question&Answers more detail:os...

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

0 votes

995 views

1 answer

mysql - Calling stored procedure in codeigniter

I am using latest codeigniter and trying to call stored procedure from my model. Also I am using mysqli as ... the core of codeigniter?? See Question&Answers more detail:os...

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

0 votes

765 views

1 answer

mysql - Update Field When Not Null

I have an update statement that updates fields x, y and z where id = xx. In the table I have a few ... Any ideas on how to accomplish this? See Question&Answers more detail:os...

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

0 votes

903 views

1 answer

mysql - What are the JPA @Table annotation "catalog" and "schema" variables used for?

Why are these important, what effect do they have on the database at hand? Isn't the "schema" already decided ... for the "schema" field. See Question&Answers more detail:os...

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

0 votes

797 views

1 answer

mysql - Float or decimal for prices?

Which type (Float or decimal) is best used to store prices in a mysql database? See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

mysql - mysqldump problems with restore error: 'Please DISCARD the tablespace before IMPORT'

I run a daily backup mysqldump backup of the production database (mysql version 5.1.66): mysqldump --user= ... thanks in advance for reading. See Question&Answers more detail:os...

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

0 votes

1.5k views

1 answer

mysql - Slick 3.0 bulk insert or update (upsert)

what is the correct way to do a bulk insertOrUpdate in Slick 3.0? I am using MySQL where the ... [MultiInsertResult, NoStream, Effect.Write] See Question&Answers more detail:os...

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

0 votes

950 views

1 answer

mysql - How to replace/remove 4(+)-byte characters from a UTF-8 string in PHP?

It seems like MySQL does not support characters with more than 3 bytes in its default UTF-8 charset. So, in ... like by some other character? See Question&Answers more detail:os...

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

0 votes

607 views

1 answer

mysql - SQL JOIN many-to-many

Sorry about the minimalistic title but I don't know how to describe it in short. I have three tables: The ... in MySQL. Thank you in advance See Question&Answers more detail:os...

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

0 votes

741 views

1 answer

mysql - SELECT that returns list of values not occurring in any row

Query: select id from users where id in (1,2,3,4,5) If the users table contains ids 1, ... question following several inapplicable answers) See Question&Answers more detail:os...

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

0 votes

871 views

1 answer

mysql - Fetching rows added last hour

I keep a record of logins in a table. I have columns for id, ip, date and time. From that record of ... them correctly. Can somebody help me? See Question&Answers more detail:os...

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

0 votes

767 views

1 answer

mysql - SQL: Select "until"

I'm looking for a way to select until a sum is reached. My "documents" table has "tag_id" and "size" fields. I ... to this app. I'm using mysql. See Question&Answers more detail:os...

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

0 votes

744 views

1 answer

mysql - PHP/SQL Database querying good practice and security

So I'm a slightly seasoned php developer and have been 'doin the damn thing' since 2007; however, I am ... that hit the php-mysql security. See Question&Answers more detail:os...

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

0 votes

765 views

1 answer

mysql - Is it possible to concatenate strings from multiple rows and tables into one result column?

I am trying to write a MySQL query that retrieves one record from table "projects" that has a one-to-many relationship ... 5 'foo','bar','etc' See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

mysql - UPDATE Same Row After UPDATE in Trigger

I want the epc column to always be earnings/clicks. I am using an AFTER UPDATE trigger to accomplish this ... //EPC should update automatically See Question&Answers more detail:os...

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

0 votes

716 views

1 answer

mysql - SQL Injection attack - What does this do?

I have detected some failed SQL injection attacks on my website. The failed queries are of the form: SELECT 6106 ... :1' for key 'group_key' See Question&Answers more detail:os...

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

0 votes

806 views

1 answer

mysql - Extra Fields with SQL MIN() & GROUP BY

When using the SQL MIN() function, along with GROUP BY, will any additional columns (not the MIN column, or one ... , I'm working with MySql. See Question&Answers more detail:os...

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

0 votes

722 views

1 answer

mysql - When should database indexes be rebuilt?

I was reading about refactoring a large slow SQL Query over here, and the current highest response is from ... stays under a few gigabytes? See Question&Answers more detail:os...

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

0 votes

832 views

1 answer

mysql - SQL select nth member of group

If I have a USER table like class | age -------------- 1 20 3 56 2 11 1 12 2 20 Then I can easily ... the way, I'm using MySql v.5.0. Cheers, See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

mysql - OpenSSL - error 18 at 0 depth lookup:self signed certificate

I was trying to create a SSL certificate to use with MySQL as like mentioned here : http://dev.mysql.com/doc ... the document in the above link. See Question&Answers more detail:os...

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

0 votes

827 views

1 answer

mysql - How to enable relation view in phpmyadmin

When working in XAMPP with phpmyadmin, after creating a table I have the option to click "relation view" after ... phpmyadmin for it to work. See Question&Answers more detail:os...

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

0 votes

608 views

1 answer

mysql - How to properly use transactions and locks to ensure database integrity?

I develop an online reservation system. To simplify let's say that users can book multiple items and each item ... . Added follow-up questions. See Question&Answers more detail:os...

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

0 votes

1.5k views

1 answer

mysql - How to encode (utf8mb4) in Python

How do I encode something in ut8mb4 in Python? I have two sets of data: data I am migrating to my new MySQL ... to my iOS app. Please help! See Question&Answers more detail:os...

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

0 votes

728 views

1 answer

mysql - MySQLdb Python insert %d and %s

Precursor: MySQL Table created via: CREATE TABLE table(Id INT PRIMARY KEY NOT NULL, Param1 VARCHAR(50)) Function: . ... ", (int(id), string) See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

mysql - ERROR 1049 (42000): Unknown database 'mydatabasename'

I am trying to restore database from .sql file , i have created the database in phpmyadmin and also using the ... i solve this issue. Thanks, See Question&Answers more detail:os...

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

0 votes

747 views

1 answer

mysql - SQL Delete Rows Based on Another Table

This is probably very easy, but it's Monday morning. I have two tables: Table1: Field | Type | Null | Key | ... =69. Thank you for any help. See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags