Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with mysql
Search options not deleted
user 164652
All versions of MySQL (not Microsoft SQL Server). Please also add a version-specific tag like mysql-5.7 if that is relevant to the question.
7
votes
3
answers
17k
views
How to select the rows affected by an update
When performing an update query (the following is just an example; any update query could be used) such as:
update t1
inner join t2 on t1.id=t2.id
set t1.name="foo" where t2.name="bar";
Query OK, 324 …
- 203
0
votes
1
answer
79
views
Why are some numbers converted after load data local infile?
ai_ci |
+-------+--------------------------------------------------------------------+
$ cat num_file
8.04
$ echo "load data local infile 'num_file' into table nums (@num)
set num=truncate(@num,8);" | mysql …
- 203
1
vote
Why are some numbers converted after load data local infile?
Here are the issues:
mysql's load data documentation indicates "LOAD DATA regards all input as strings", so "8.04" is being read as a string, not a numeral
truncate() documentation indicates "When th …
- 203
0
votes
Is it possible to change ENUM() lists?
You can add to or remove values from ENUM lists with no problem (MySQL 5.7 and up), but attempting to simply rename a given value will result in data loss, unless an approach like MySQL Change a column …
- 203
0
votes
Aurora Serverless alter table Error 1114 table is full
On the AWS Forums, LawrenceAtAWS said,
the amount of temporary storage space associated with Serverless increases linearly with the number of associated ACUs. If you're having issues running out o …
- 203
0
votes
1
answer
288
views
Select data at row number in warning
When running show warnings in mysql, sometimes the results give a row number, such as "Warning | 1265 | Data truncated for column 'identifier' at row 12343". … What's the best way to see the data referenced by mysql warnings? …
- 203
0
votes
1
answer
208
views
Why would a group by return multiple groups with the same value?
|
| | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci |
+-----------+--------------------------------------------------------------------+
I'm using mysql …
- 203
1
vote
Why would a group by return multiple groups with the same value?
As suggested by Rick James, turning off Aurora's parallel query seems to solve the issue and give the expected results.
- 203
1
vote
1
answer
1k
views
Aurora Serverless alter table Error 1114 table is full
Using Aurora Serverless, when attempting to alter table mytable add column mynewcolumn decimal(10,3) after myoldcolumn I receive "ERROR 1114 (HY000): The Table 'mytable' is full". The table has hundre …
- 203