Put the date in single quotes and move the parenthesis (after the ‘yes’) to the end: But you can always use dates without STR_TO_DATE() function, just use the (Y-m-d) ‘20120101’ or ‘2012-01-01’ format. Check the MySQL docs: Date and Time Literals
Since you want to pivot multiple columns of data, I would first suggest unpivoting the result, score and grade columns so you don’t have multiple columns but you will have multiple rows. Depending on your version of SQL Server you can use the UNPIVOT function or CROSS APPLY. The syntax to unpivot the data will be similar to: See SQL Fiddle … Read more
No, you should run mysql -u root -p in bash, not at the MySQL command-line. If you are in mysql, you can exit by typing exit.
You need to identify the primary key in TableA in order to delete the correct record. The primary key may be a single column or a combination of several columns that uniquely identifies a row in the table. If there is no primary key, then the ROWID pseudo column may be used as the primary … Read more
You need to specify where the database directory is installed to. eg Failing that you will need to set the environment variable PGDATA. Something like
Works for MySql version < 5.7.3 Look for the Section – We can use INFORMATION_SCHEMA Tables. Useful Queries To check about all the locks transactions are waiting for: A list of blocking transactions: OR A List of locks on particular table: A list of transactions waiting for locks: Reference – MySQL Troubleshooting: What To Do When Queries Don’t Work, … Read more
I’m assuming that id is supposed to be an incrementing value. You need to set this, or else if you have a non-nullable column, with no default value, if you provide no value it will error. To set up auto-increment in SQL Server Management Studio: Open your table in Design Select your column and go to Column Properties Under Indentity … Read more
First check if it’s a workbench or connection problem. 1) In your windows run ‘cmd’ to open a terminal Try both 2a) mysql -u root -p -h 127.0.0.1 -P 3306 2b) mysql -u root -p -h > localhost -P 3306 3) If the connection is good you will get a password prompt, see if you can connect … Read more
The error is because fName is included in the SELECT list, but is not included in a GROUP BY clause and is not part of an aggregate function (Count(), Min(), Max(), Sum(), etc.) You can fix that problem by including fName in a GROUP BY. But then you will face the same issue with surname. So put both in the GROUP BY: Note I used Count(*) where you wanted SUM(orders.quantity). However, orders isn’t included … Read more
You can use STR_TO_DATE() to convert your strings to MySQL date values and ORDER BY the result: However, you would be wise to convert the column to the DATE data type instead of using strings.