From @gmmastros’s answer Whenever you see the message…. string or binary data would be truncated Think to yourself… The field is NOT big enough to hold my data. Check the table structure for the customers table. I think you’ll find that the length of one or more fields is NOT big enough to hold the data … Read more
Combine the creation and insert into a single statement: If it doesn’t create the table, AS SELECT … clause is ignored.
Open and edit /etc/my.cnf or /etc/mysql/my.cnf, depending on your distribution. Add skip-grant-tables under [mysqld] Restart MySQL You should be able to log in to MySQL now using the below command mysql -u root -p Run mysql> flush privileges; Set new password by ALTER USER ‘root’@’localhost’ IDENTIFIED BY ‘NewPassword’; Go back to /etc/my.cnf and remove/comment skip-grant-tables Restart MySQL Now you will be able to login with the … Read more
Works fine for me in 5.0.27 I just get a warning (not an error) that the table exists;
Can anyone give me a good example of when CROSS APPLY makes a difference in those cases where INNER JOIN will work as well? See the article in my blog for detailed performance comparison: INNER JOIN vs. CROSS APPLY CROSS APPLY works better on things that have no simple JOIN condition. This one selects 3 … Read more
There are many formats supported by SQL Server – see the MSDN Books Online on CAST and CONVERT. Most of those formats are dependent on what settings you have – therefore, these settings might work some times – and sometimes not. The way to solve this is to use the (slightly adapted) ISO-8601 date format that is supported by SQL … Read more
Rather slow, but working method to include any of words: If you need all words to be present, use this: If you want something faster, you need to look into full text search, and this is very specific for each database type.
Your subquery is selecting two columns, while you are using it to project one column (as part of the outer SELECT clause). You can only select one column from such a query in this context. Consider joining to the users table instead; this will give you more flexibility when selecting what columns you want from … Read more
you should put those two dates between single quotes like.. or can use keep in mind that the first date is inclusive, but the second is exclusive, as it effectively is ‘2011/02/27 00:00:00’