I’ve searched around but didn’t find if it’s possible. I’ve this MySQL query: INSERT INTO table (id,a,b,c,d,e,f,g) VALUES (1,2,3,4,5,6,7,8) Field id has a “unique index”, so there can’t be two of them. Now if the same id is already present in the database, I’d like to update it. But do I really have to specify … Read more
After noticing an application tended to discard random emails due to incorrect string value errors, I went though and switched many text columns to use the utf8 column charset and the default column collate (utf8_general_ci) so that it would accept them. This fixed most of the errors, and made the application stop getting sql errors … Read more
I’m a bit confused on how to order by date formats. For the format YYYY-MM-DD you would do this: …ORDER BY date DESC… How would you order by DD/MM/YYYY? This isn’t working: SELECT * FROM $table ORDER BY DATE_FORMAT(Date, ‘%Y%m%d’) DESC LIMIT 14 8 Answers 8
If I have a trigger before the update on a table, how can I throw an error that prevents the update on that table? 7 Answers 7
I often see people are using Delimiters. I tried myself to find out what are delimiters and what is their purpose. After 20 minutes of googling, I was not able to find an answer which satisfies me. So, my question is now: What are delimiters and when should I use them? 4 Answers 4
I want to begin writing queries in MySQL. show grants shows: +————————————–+ | Grants for @localhost | +————————————–+ | GRANT USAGE ON *.* TO ”@’localhost’ | +————————————–+ I do not have any user-id but when I want to make a user I don’t have privilleges, also I don’t know how to make privileges when even … Read more
Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers. We don’t allow questions about general computing hardware and software on Stack Overflow. You can edit the question so it’s on-topic for Stack Overflow. Closed 8 months ago. The community reviewed whether to reopen this question 2 months ago and … Read more
CREATE TABLE foo SELECT * FROM bar copies the table foo and duplicates it as a new table called bar. How can I copy the schema of foo to a new table called bar without copying over the data as well? 4 Answers 4
Here’s how I do it: Table names are lower case, uses underscores to separate words, and are singular (e.g. foo, foo_bar, etc. I generally (not always) have a auto increment PK. I use the following convention: tablename_id (e.g. foo_id, foo_bar_id, etc.). When a table contains a column that is a foreign key, I just copy … Read more
How to restore one of my MySQL databases from .myd, .myi, .frm files? 11 Answers 11
