Re: DATETIME vs CHAR for "timestamp"
> On Apr 14, 2017, at 1:07 PM, shawn l.green wrote: > > That all depends. Do you... Hi Shawn, I thought I had replied to your response, but it looks like I didn’t. Thank you for your email. It was a thorough response and the links were very helpful, as well. I’ve settled on both DATE and DATETIME, depending on whether the time is needed or not, which means I’ll have to change some of my code, but that will only strengthen the script in the long run. Thanks again, Frank https://www.surfshopcart.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
DATETIME vs CHAR for "timestamp"
I have creation date/time fields in my script that are formatted as |MM|DD|hh|mm|ss. Short of changing the script, should I set the field type in MySQL to DATETIME, or would it be better in terms of speed and efficiency to set it as char(19)? Or would it not make a difference? Thanks, Frank -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Automated SQL checker?
> On Apr 12, 2017, at 3:38 PM, Ronan McGlue wrote: > > Enable the slow log on the DB. Thanks Ronan. That sounds like it would be beneficial. I take it you’re referring to a setting on the server, though. If that’s the case, I don’t think I can do that as I’m on shared hosting (unless I’m misunderstanding you). When I get some free time (hah!) maybe I’ll set up MySQL on my laptop. Unfortunately, installing DBI on OS X can be a nightmare, so I don’t know if/when that will happen. Thanks again, Frank https://www.surfshopcart.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Automated SQL checker?
> On Apr 11, 2017, at 1:26 PM, Michael Munger > wrote: > > Use MySQL workbench. Thanks, Michael. I played with it some already and it looks like it will give me a lot to work with. Will it also let me know if field types are wrong for the given information type, or is that asking for too much? Frank https://www.surfshopcart.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Automated SQL checker?
Is there a way, perhaps with a script or a service, that one can check MySQL code to see about making it more efficient? I maintain an open source shopping cart written in Perl and it’s been awhile since the SQL has been worked on, so I want to see if it could use some updating. Thanks, Frank http://www.surfshopcart.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql