Tag: mysql

How can I update date of datetime field with mysql only?

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: Fiddle: http://sqlfiddle.com/#!2/28d71/1 For

set decimal places of sum in sql

decimal mysql sql sum

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

java jdbctemplate mysql spring sql

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? Thanks *Edit: code * Answer You

mysql selecting multiple rows that match array of ids

arrays mysql php sql

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’

mysql sql

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_INCREMENT why there is error? Should I change the

MySQL Query selection

mysql sql

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

ldap mysql php sql sql-server

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 number is unique. I get so

Time difference between swipe-in and swipe-out for employees; allow for tailgating and exit on different day

mysql sql

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 increase the complexity. Points to be considered are : There are two

Select by -3 days?

mysql select sql

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 alias

PHP SQL Views counter using PDO prepare()

mysql pdo php sql

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