Recent questions tagged MySQL

0 votes

778 views

1 answer

mysql - Hibernate encodes wrong while persisting objects [UTF-8]

I'm facing with UTF-8 encoding problem while persisting my model objects. In Turkish '?' is a letter. Also there ... /props> </property> </bean> See Question&Answers more detail:os...

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

0 votes

703 views

1 answer

mysql - Is “Where IN” with multiple columns defined in Standard SQL?

I'm working on a query like this: SELECT * FROM requests where (id,langid) IN (SELECT nid,langid FROM node) ... but I'm not interested in that. See Question&Answers more detail:os...

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

0 votes

748 views

1 answer

mysql, space equals empty string

Just took me 2 hours to troubleshoot an issue on my backend. Cause was that of empty string being equal to space: ... this? Is it a setting? See Question&Answers more detail:os...

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

0 votes

829 views

1 answer

mysql - How to determine what is more effective: DISTINCT or WHERE EXISTS?

For example, I have 3 tables: user, group and permission, and two many2many relationships between them: user_groups ... situation? Why? Thanks! See Question&Answers more detail:os...

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

0 votes

709 views

1 answer

mysql - What would be a sql query to remove from the text?

I am using MySQL. My data has a column called text, which uses the TEXT data type. There are several newlines for ... query. How can I do that? See Question&Answers more detail:os...

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

0 votes

843 views

1 answer

mysql - How can I add a foreign key when creating a new table?

I have these two CREATE TABLE statements: CREATE TABLE GUEST ( id int(15) not null auto_increment PRIMARY KEY, ... not create a new table. See Question&Answers more detail:os...

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

0 votes

949 views

1 answer

mysql - Last inserted id from specific table

SELECT LAST_INSERT_ID() as id FROM table1 Why does this query sometimes return the last inserted id of another table ... I can only do queries. See Question&Answers more detail:os...

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

0 votes

948 views

1 answer

mysql - PHP strtotime() function wrong by 1 hour?

I am converting dates and times into timestamps using PHP before they are inserted into my MySQL database. My problem ... hour to all my dates? See Question&Answers more detail:os...

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

0 votes

800 views

1 answer

mysql - Update a boolean to its opposite in SQL without using a SELECT

Is it possible to upgrade a bool field by telling it to update the field to the opposite of what it is without ... query if that is possible ? See Question&Answers more detail:os...

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

0 votes

752 views

1 answer

mysql - Operation not allowed when innodb_forced_recovery > 0 [SqlYog]

I have created a table using SQLyog. When i insert values into it, it pops up following error message: Operation ... ', 'slugOne', 'descOne') See Question&Answers more detail:os...

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

0 votes

752 views

1 answer

mysql - How To Left Join 2 Tables On 2 Different Databases?

I have first database (dbA) with table like this, named Username : +------------------+--------------+ | Username | ... -----------------------+ See Question&Answers more detail:os...

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

0 votes

847 views

1 answer

mysql - Adding constraints in phpMyAdmin

I feel like I'm being stupid, but I can't find anywhere on the phpMyAdmin interface to add constraints ... it through the graphical interface. See Question&Answers more detail:os...

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

0 votes

839 views

1 answer

mysql - Cannot resolve table name close to

I want to create a references to foreign table. but i'm getting the following error: query: CREATE TABLE category_ids (id ... in set (0.00 sec) See Question&Answers more detail:os...

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

0 votes

712 views

1 answer

mysql - Why is Rails is adding `OR 1=0` to queries using the where clause hash syntax with a range?

The project that I'm working on is using MySQL on RDS (mysql2 gem specifically). When I use a hash ... and Ranges are handled differently. See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

mysql - Cannot login to phpMyAdmin, no errors shown

I have MySQL set up correctly on my linux computer, however I want a better way to input data into the database ... shows after I click "go". See Question&Answers more detail:os...

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

0 votes

871 views

1 answer

mysql - How to limit results of a LEFT JOIN

Take the case of two tables: tbl_product and tbl_transaction. tbl_product lists product details including names and ids ... wish it wasn't! See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

mysql - should I reuse the cursor in the python MySQLdb module

I'm writing a python CGI script that will query a MySQL database. I'm using the MySQLdb module. Since the ... ) result4 = cursor.fetchall() See Question&Answers more detail:os...

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

0 votes

902 views

1 answer

mysql - What are the benefits of only_full_group_by mode?

I updated mysql and I went from MySQL Version 5.6.17 to version 5.7.14 Since I have errors on my sql queries ... by' on my query? Thank you See Question&Answers more detail:os...

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

0 votes

773 views

1 answer

mysql - TOP and ORDER BY sql error

I am trying to select the last record from a table in MySQL using PHP. I believe I have an SQL error. Here is ... have a PHP error, tell me. See Question&Answers more detail:os...

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

0 votes

904 views

1 answer

mysql - Hotel Room Rates for different seasons

I have a database (MySQL) with a table containing date ranges (as startdate and enddate) and a rate field. The ... . Hope i have clarified. Tom See Question&Answers more detail:os...

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

0 votes

829 views

1 answer

mysql - How to run or load .po/.mo files for localization in php

I have installed poedit and running my file through it, it creates .po and .mo files for them. But I ... possible source but not succeeded. See Question&Answers more detail:os...

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

0 votes

969 views

1 answer

mysql - calculate the differences between two rows in SQL

I have a SQL table, one row is the revenue in the specific day, and I want to add a new column in ... /MySQL Workbench. thanks in advance, Lin See Question&Answers more detail:os...

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

0 votes

950 views

1 answer

mysql - ...mysql2/mysql2.so: [BUG] Segmentation fault ruby 2.0.0p247

I'm using windows7x64, ruby2.0.0p247, rails4.0.0 and mysql5.5.27. When I run the $ rails server command, I got ... can I get rid of this error? See Question&Answers more detail:os...

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

0 votes

802 views

1 answer

mysql - how to get distinct rows with max value

my apologies for asking what must be very simple to solve, but I just can't seem to wrap my mind around this.. I ... at all... Any ideas? :o) See Question&Answers more detail:os...

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

0 votes

809 views

1 answer

mysql - SELECT distinct values for multiple rows of same ID

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

0 votes

1.3k views

1 answer

mysql - How to LEFT JOIN two tables with the same column name

I want to LEFT JOIN two tables with the same column name. I have two tables which I am trying to join but ... same column name in each table? See Question&Answers more detail:os...

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

0 votes

804 views

1 answer

mysql - Spark JoinWithCassandraTable on TimeStamp partition key STUCK

I'm trying to filter on a small part of a huge C* table by using: val snapshotsFiltered = sc.parallelize( ... partition key? Why it freezes? See Question&Answers more detail:os...

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

0 votes

808 views

1 answer

mysql - UPDATE Syntax with ORDER BY, LIMIT and Multiple Tables

Learning SQL, sorry if this is rudimentary. Trying to figure out a working UPDATE solution for the following ... confused, thanks in advance. See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags