Recent questions tagged MySQL

0 votes

687 views

1 answer

mysql - Is it better to return one big query or a few smaller ones?

I'm using MySQL to store video game data. I have tables for titles, platforms, tags, badges, reviews, developers, ... m unsure what is best.... See Question&Answers more detail:os...

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

0 votes

798 views

1 answer

mysql - Get the latest inserted id in a trigger?

I use a trigger to insert a row and want to use the last created id for using in the subsequent query. How ... tagPairId = OLD.id END IF; END See Question&Answers more detail:os...

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

0 votes

676 views

1 answer

mysql - SQL - error code 1005 with error number 121

I'm running the following MySQL script (trimmed down), generated automatically by MySQL Workbench and I get the ... ACTION) ENGINE = InnoDB; See Question&Answers more detail:os...

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

0 votes

577 views

1 answer

mysql - Minimizing SQL queries using join with one-to-many relationship

So let me preface this by saying that I'm not an SQL wizard by any means. What I want to do is ... and comments are stored in separate tables. See Question&Answers more detail:os...

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

0 votes

687 views

1 answer

mysql - Codeigniter parentheses in dynamic Active Record query

I'm producing a query like the following using ActiveRecord SELECT * FROM (`foods`) WHERE `type` = 'fruits' ... foreach loop throws me off.. See Question&Answers more detail:os...

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

0 votes

999 views

1 answer

mysql - Convert lat/lng pairs using GeomFromText('POINT(1 1)') and insert in another column

In my previous question Search for range Latitude/Longitude coordinates My solution was to create the table below. mysql> select ... ----------+ See Question&Answers more detail:os...

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

0 votes

661 views

1 answer

mysql - Display SQL query results in php

I'm tring to diplay results in php from sql database MySQL statement is correct and does what i want in phpMyAdmin ... to max by the table id See Question&Answers more detail:os...

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

0 votes

794 views

1 answer

mysql - Laravel eager loading vs explicit join

This might sound like an obvious question but I just want to get some reassurance. Using Laravel's eager loading ... you can measure the impact. See Question&Answers more detail:os...

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

0 votes

764 views

1 answer

mysql - after insert ignore get primary key

i am running a query in mysql insert ignore into........ using Python after running the query I want to know the ... is the best way to do this? See Question&Answers more detail:os...

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

0 votes

866 views

1 answer

mysql - @Column(unique=true) does not seem to work

Even though I set the attribute to be @Column(unique=true), I still insert a duplicate entry. @Entity public ... did not create table using JPA See Question&Answers more detail:os...

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

0 votes

984 views

1 answer

mysql - SQL subtract two rows based on date and another column

I need to subtract two rows in MySQL by using the most recent date from the previous date: Starting table: ... handle any number of dates. See Question&Answers more detail:os...

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

0 votes

907 views

1 answer

mysql - how to skip duplicate records when importing in phpmyadmin

I have a db on my local machine and I want to import the data to the db on my hosting. Both db's ... a quick solution for this with phpmyadmin? See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

mysql - Error while inserting date - Incorrect date value:

I have a column called today and the type is DATE. When I try to add the date in the format '07-25-2012' ... value: '07-25-2012' for column See Question&Answers more detail:os...

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

0 votes

629 views

1 answer

mysql - What does the number in parenthesis really mean?

I always thought that the number in the parenthesis represented the field length? However, I understand that is not ... instead of INT for age? See Question&Answers more detail:os...

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

0 votes

695 views

1 answer

mysql - Calculated column in where-clause - performance

Since you can't use a calculated column in a where-clause in MySQL like this: SELECT a,b,c,(a*b+c) AS ... but not to have a WHERE-clause. See Question&Answers more detail:os...

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

0 votes

566 views

1 answer

mysql - How to normalize a SQL Database

I was wondering if anyone had any suggestions on how to normalize a database. Now, I don't mean designing the ... will do what I'm asking. See Question&Answers more detail:os...

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

0 votes

514 views

1 answer

mysql - Difference between using REFERENCES with and without FOREIGN KEY?

Basically I'd like to know the difference between using REFERENCES with or without a foreign key. I have these ... if it's referencing itself? See Question&Answers more detail:os...

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

0 votes

798 views

1 answer

mysql - Multiple insert/update statements inside trigger?

Just a quick question that no doubt someone out there will know the answer to. I need to be able to do ... i'm doing wrong? Cheers Gavin See Question&Answers more detail:os...

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

0 votes

480 views

1 answer

mysql - How to search and replace all instances of a string within a database?

I have a string that is contained inside of a wordpress install (the name of a server) thousands of ... record problematically? Thank you, See Question&Answers more detail:os...

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

0 votes

908 views

1 answer

mysql - DateTime group by date and hour

I have a datetime called activity_dt and the data looks like this: 2/5/2013 9:24:00 AM 2/7/2013 7:17:00 AM How do i group by date and hour? See Question&Answers more detail:os...

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

0 votes

925 views

1 answer

mysql - how to update swap values of two rows with single query

Is there a query with which i can exchange the values of two rows with single query? See Question&Answers more detail:os...

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

0 votes

576 views

1 answer

mysql - How can I improve DELETE FROM performance on large InnoDB tables?

I have a fairly large InnoDB table which contains about 10 million rows (and counting, it is expected to become ... about one million of rows. See Question&Answers more detail:os...

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

0 votes

734 views

1 answer

mysql - Enable binary mode while restoring a Database from an SQL dump

I am extremely new to MySQL and am running it on Windows. I am trying to restore a Database from a ... and data which is not comprehensible. See Question&Answers more detail:os...

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

0 votes

590 views

1 answer

mysql command for showing current configuration variables

Can not find a command that displays the current configuration of mysql from within the database. I know I could look ... is not what I need. See Question&Answers more detail:os...

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

0 votes

733 views

1 answer

mysql - PHP ~ Column count doesn't match value count at row 1

I'm creating a registration and I'm using just straight PHP not JavaScript to send my form to the MySQL database, ... ) or die (mysql_error()); See Question&Answers more detail:os...

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

0 votes

801 views

1 answer

mysql - "Specified key was too long; max key length is 1000 bytes"

I can't create index on varchar(500). MySQL: Specified key was too long; max key length is 1000 bytes See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

mysql - Doctrine: ON DUPLICATE KEY UPDATE

How can I write an INSERT doctrine query with option ON DUPLICATE KEY UPDATE? See Question&Answers more detail:os...

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

0 votes

591 views

1 answer

mysql - How to update from select with a Join

How can I update a table that is also present in a subquery? Do I have to do it in 2 stages? ( ... 'invoiceLine' for update in FROM clause See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags