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
Closed. This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the question so it can be answered with facts and citations by editing this post. Closed 7 years ago. Improve this question Here we go again, the old argument still arises… Would we better have a business key … Read more
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
Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this question? Update the question so it focuses on one problem only by editing this post. Closed 3 years ago. Improve this question NoSQL refers to non-relational data stores that break with the history of relational databases and … Read more
