Is it a good idea to index datetime field in mysql?
I am working on designing a large database. In my application I will have many rows for example I currently have one table … Read more
MySQL
LEFT JOIN only first row
I read many threads about getting only the first row of a left join, but, for some reason, this does not work for … Read more
Access denied for user ‘[email protected]’ (using password:NO)
I’m new to MySQL, I’m trying to run WordPress in my Windows desktop and it needs MySQL. I install everything with Web Platform … Read more
Increment a database field by 1
With MySQL, if I have a field, of say logins, how would I go about updating that field by 1 within a sql … Read more
Should MySQL have its timezone set to UTC?
Follow up question of https://serverfault.com/questions/191331/should-servers-have-their-timezone-set-to-gmt-utc Should the MySQL timezone be set to UTC or should it be set to be the same timezone … Read more
How to get the number of days of difference between two dates on MySQL?
I need to get the number of days contained within a couple of dates on MySQL. For example: Check in date is 12-04-2010 … Read more
How to define a custom ORDER BY order in mySQL
In MySQL how do I define a custom sorting order. To try to explain what I want consider this table: ID Language Text … Read more
SQL – Update multiple records in one query
I have table – config. Schema: config_name | config_value And I would like to update multiple records in one query. I try like … Read more
MySQL Like multiple values
I have this MySQL query. I have database fields with this contents sports,shopping,pool,pc,games shopping,pool,pc,games sports,pub,swimming, pool, pc, games Why does this like query … Read more
How do I retrieve my MySQL username and password?
I lost my MySQL username and password. How do I retrieve it? 10 Answers 10
