I have a table like this I want to update only the date but dont know where to start from. I mean in the datetime field date i want to update the date ‘2014-01-08’ to ‘2014-01-01’. How can i do that? I have tried this. Here is the Fiddle Structure Answer One option is to use this: Fidd…
Tag: mysql
set decimal places of sum in sql
I have a database I use for a debating competition I am trying to sort the standings out to see which schools will play off in the finals at the end of the semester. I have this working as shown below however I am not able to round the ptc field, it currently returns up to 4 decimal places eg
Why does Spring’s JDBC Templates doesn’t use the tables default value
I have a table in MYSQL and I am using JDBC Templates to do an insert into that table. One of the columns has a default value, and I am not specifying it in the Map<String, Object> parameters map. I am getting an exception Column ‘colName’ cannot be null. Can anyone explain this please? Than…
mysql selecting multiple rows that match array of ids
First of all: SELECT `key`, `value` FROM settings WHERE `key` = :base_url OR `key` = :google_analytics OR `key` = :site_domain Is this correct way of selecting multiple rows? Or is there a …
ERROR 1062 (23000): Duplicate entry ‘2147483647’ for key ‘PRIMARY’
I have a table: As we can see, the previous value, just went wrong into table. Should be 16 numbers and not only 10, actually different numbers. When i try to insert a new value: I get this error: ERROR 1062 (23000): Duplicate entry ‘2147483647’ for key ‘PRIMARY’ If bank_card is AUTO_I…
MySQL Query selection
I have a big database table called pricing. The fields are following: id code description rrp buy stock date distributor vendor version User select the vendor field only. version field can be vary …
php/mysql: get data from one table, convert and insert in another table
Ok I will try to explain, (I am Portuguese lol). I have a Database where I have the fallowing MySQL: Database: ad Table: notebooks Fields: ID, tag, so, lastlogon, lastlogh My ldap query gets data from ldap server (active directory) and stores it in my MySQL database (ad/notebooks). I get tag which is tag numb…
Time difference between swipe-in and swipe-out for employees; allow for tailgating and exit on different day
This is continuation of/added complexity to the question: sql query – Get the difference time between swipe in – Swipe out for employee. We have similar swipe-in/out data, but additional constraints. Sample source data: The data comes in the above format but the desired output and input data incre…
Select by -3 days?
I’m trying to select data from a specific table in my database, but I want to be able to only view the last 3 days worth of data, I have the following code but for some reason I can’t get it to work. Answer You may avoid usage of DATE_ADD() at all: As @OGHaza mentioned, you specified column with a…
PHP SQL Views counter using PDO prepare()
I have a variable $id which gives me the id of the current article and this can help me to make an update query in my database on current article. This is my code: I don’t get any errors but my code is still not working… Answer Your correct code is here: ; from the end of sql is not