Recent questions tagged MySQL

0 votes

656 views

1 answer

mysql - #1060 - Duplicate column name 'id'

Why I get #1060 - Duplicate column name 'id' SELECT COUNT(*) FROM (SELECT * FROM `tips` `t` LEFT JOIN tip_usage ON ... =t.id GROUP BY t.id) sq See Question&Answers more detail:os...

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

0 votes

717 views

1 answer

mysql - Trigger calls in cascade deleting

I have table "A" in MySQL. It has some references with cascade deleting to some other tables ("B", "C", ... maybe, there is another way to call See Question&Answers more detail:os...

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

0 votes

635 views

1 answer

mysql - Can you GROUP BY with a CASE WHEN THEN alias name?

I have a SELECT statement being calculated from a CASE WHEN THEN state (or could use multiple IF statements) aliased ... ' which isn't right.. See Question&Answers more detail:os...

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

0 votes

518 views

1 answer

mysql - java.sql.SQLException: Unknown system variable 'query_cache_size'

I have a app running with JDBC and get data from MySQL, but I can't build it because of this error ... Mysql workbench is 8.0 version See Question&Answers more detail:os...

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

0 votes

709 views

1 answer

mysql - query "not equal" doesn't work

I have very simple query like this: SELECT * FROM `all_conversations` WHERE `deleted_1` != '1'; And my deleted_1 ... ' AND `deleted_1` != 23 See Question&Answers more detail:os...

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

0 votes

564 views

1 answer

mysql - Cannot Initialize mbstring with PHP 7

Whenever I try to access phpMyAdmin, I receive the following error: "The mbstring extension is missing. Please check ... let me know. Thanks. See Question&Answers more detail:os...

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

0 votes

465 views

1 answer

mysql - Database modeling for a weak entity

I have 2 tables in my database orders and orderHistory. ----------------- ------------ ... historyLineID are surrogate keys. Thanks in advance. See Question&Answers more detail:os...

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

0 votes

541 views

1 answer

mysql - How to prevent Duplicate records from my table Insert ignore does not work here

mysql> select * from emp; +-----+---------+------+------+------+ | eno | ename | dno | mgr | sal | +-----+-- ... ---+---------+----------------+ See Question&Answers more detail:os...

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

0 votes

623 views

1 answer

mysql - Query using group_concat is returning only one row

This is a query that is supposed to get the user's information, their project's information, and a group_concat ... above to see the problem. See Question&Answers more detail:os...

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

0 votes

535 views

1 answer

mysql - Does Postgresql SERIAL work differently?

I have a postgres table with a SERIAL id. id (serial) name age Insert usually happens from a web application. ... other SQL have the same issue? See Question&Answers more detail:os...

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

0 votes

678 views

1 answer

mysql - error running apache after xampp install

I installed xampp on win7 and get this error when starting apache. I unchecked skype and nothing changes. How ... : Starting 150 worker threads. See Question&Answers more detail:os...

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

0 votes

538 views

1 answer

mysql - How to INSERT a record or UPDATE if it already exists?

I have a table with columns record_id (auto inc), sender, sent_time and status. In case there isn't ... otherwise update the existing record? See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

mysql - Unknown column in 'having clause'

I need to find in sakila database the longest rental period of a movie. I have tried this: SELECT DISTINCT customer ... data. What am i missing? See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

mysql - COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'latin1'

I am trying to fix a character encoding issue - previously we had the collation set for this column utf8_general_ci which caused ... ----------+ See Question&Answers more detail:os...

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

0 votes

491 views

1 answer

mysql - Create an ActiveRecord database table with no :id column?

Is it possible for me to create and use a database table that contains no :id column in ActiveRecord, Ruby on ... something like this in rails? See Question&Answers more detail:os...

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

0 votes

639 views

1 answer

mysql - Selecting all records from one year ago till now

I have a table filled with a lot of rows and I need to select all the rows that are less than a year old ... between now and a full year ago? See Question&Answers more detail:os...

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

0 votes

536 views

1 answer

mysql - Table 'performance_schema.session_variables' doesn't exist

I m new at using MySql data base, i have downloaded EasyPHP-Devserver-16.1, when I run my server ... have no problem with that See Question&Answers more detail:os...

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

0 votes

765 views

1 answer

mysql - Calculate delta(difference of current and previous row) in sql

I have a table like : trans is the name of the table for example Id | Trans_Date | Account_Id | Amount | ... help me in resolving this query. See Question&Answers more detail:os...

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

0 votes

518 views

1 answer

mysql - When should I close a database connection in PHP?

I'm nothing like a php developer but I do have to use it and I'm not really aware on how PHP handle ... does my pattern relevant in PHP ? See Question&Answers more detail:os...

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

0 votes

485 views

1 answer

mysql - Improving a query using a lot of inner joins to wp_postmeta, a key/value table

am working with a wordpress website that is performing the following query, but I see this query is doing many ... ---+ Wordpress schema here. See Question&Answers more detail:os...

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

0 votes

524 views

1 answer

mysql - Is it possible to count two columns in the same query

Let's say I have the following table structure: t1 ------------- id // row id userID_follower // ... WHERE userID_following = ".$myID." Thanks. See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

mysql - Laravel Cannot delete or update a parent row: a foreign key constraint fails

For some reason a user cannot delete a post if it has been liked, it was working before but when I linked posts ... went wrong'], 400); } See Question&Answers more detail:os...

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

0 votes

495 views

1 answer

mysql - Getting group by sum and total sum in a single query

Is there any way to get total price of all products by category and total price of all products in a ... FROM products Group BY category_id See Question&Answers more detail:os...

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

0 votes

524 views

1 answer

mysql - How do you implement an auto-incrementing primary ID in MongoDB?

Just like in MYSQL, I want an incrementing ID. See Question&Answers more detail:os...

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

0 votes

620 views

1 answer

mysql - php script to log the raw data of POST

I am sending data using HTTP POST to my server. But in the server, I am not receiving the data. And somehow I ... not check "print_r" or "echo" See Question&Answers more detail:os...

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

0 votes

700 views

1 answer

mysql - joining the same table twice on different columns

I've got a user table and a complaint table. The complaint table has the following structure: [opened_by] [ ... show usernames rather than IDs. See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

mysql - Laravel migration (errno: 150 "Foreign key constraint is incorrectly formed")

I have an orders table and a have a sell_shipping_labels which references orders.id as a foreign. However when I ... are in the correct order. See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

mysql - Database corruption with MariaDB : Table doesn't exist in engine

I'm in an environement setup, running OSX with MariaDB 10.0.12-MariaDB Homebrew I've screwed up the ... you can resolve the problem. See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags