Fermé

Fix mysql query help

Hi!

I have a DB field type datetime in which there are some dates, like:

2015-09-17 14:09:48

I now want to change all the dates to the following one:

2015-09-16 00:00:00

But simply dont know how the update query looks like.

Table is imagefound, column is first_found

Anybody who can help?

Compétences : MySQL, PHP, Architecture Logicielle

Voir plus : loop mysql table update, mysql fix 2013 query, mysql table update script, update query mysql, mysql table update, update query mysql aspnet, csv mysql table update, create update query mysql

Concernant l'employeur :
( 104 commentaires ) Lüneburg, Germany

N° du projet : #8493229

59 freelance ont fait une offre moyenne de 16 $ pour ce travail

rajeshsonisl

Hello! With 98% to 99% completion rate, 850+ successfully completed projects, and a 5.00 reputation (maximum possible, 5.0) (Yes, not even 4.99 average rating, can be verified on my profile page https://www.freelanc Plus

34 $ USD en 1 jour
(647 Commentaires)
7.8
sprextech

----------------------------------------------------------Please Consider on My BID---------------------------------------------------Hello Sir, I have 7 + years experience of web site development. Expert in Custom Cor Plus

28 $ USD en 1 jour
(137 Commentaires)
6.4
techvolcano

Hello, We can help you to build this update query. Give us the db dump. Ready to start now. Thanks.

25 $ USD en 1 jour
(221 Commentaires)
6.6
csajit

HELLO THERE, Over 200+ Positive Reviews. Over 90% Completion Rate. 5 Star Rating. 8+ Years of experience in PHP/MYSQL I AM INTERESTED IN WORKING ON THIS PROJECT. PLEASE CHECK MY REVIEWS AND THEN DECIDE ON Plus

30 $ USD en 1 jour
(223 Commentaires)
6.6
AndrewYer

Предложение еще не подано

10 $ USD en 0 jours
(76 Commentaires)
5.7
danale72

-- set DATE type for colunm which store date but not time ALTER TABLE imagefound CHANGE COLUMN first_found first_found DATE

10 $ USD en 1 jour
(77 Commentaires)
5.8
sat12

Hi, i will start right now and do it like you said. it is y-m-d H:i:s I am joomla, virtuemart expert having 5 years of experience... recently i completed these projects http://www.ticotogo.com http://www.uniquest Plus

15 $ USD en 1 jour
(214 Commentaires)
6.3
codinglover89

Please use SQL below: ##################################### UPDATE imagefound SET first_found = '2015-09-16 00:00:00' ##################################### Please use above command and check by yourself After Plus

10 $ USD en 1 jour
(20 Commentaires)
6.0
vermagarima

dear sir i m very good with php and my sql plzz chk my profile thanks ============================================================================================================================================ Plus

14 $ USD en 1 jour
(24 Commentaires)
5.4
BitLabs

Dear sir, I will complete your project asap, LIFETIME error free guarantee and provide ONE YEAR support... I have gone through your outsourced requirement "Fix mysql query help" and have analysed that I have right Plus

20 $ USD en 1 jour
(51 Commentaires)
5.1
UmidKZ

Hello, thank you for posting this project. Experienced PHP developer, ready to start immediately. Regards, Umid

15 $ USD en 0 jours
(29 Commentaires)
5.2
tanseercena

Hello Sir, I can fix your query issue so please message me to discuss it. Thanks............................... "Happy Hiring"

30 $ USD en 0 jours
(30 Commentaires)
4.6
softtechsurat

Hello sir/madam, we have read and understand your requirement and very much confident that we can complete this project within low budget and less time . Give us chance to serve you better Looking forward to be Plus

24 $ USD en 1 jour
(22 Commentaires)
4.6
hellocp150

Hi let's do it now i have more than 5 years of exp in core php and mysql i will do it as per your requirements thanks

34 $ USD en 1 jour
(46 Commentaires)
4.7
shengui

A proposal has not yet been provided

13 $ USD en 0 jours
(19 Commentaires)
4.4
yamandhuliye

hi, i can easily do this work. i can easily update your datetime field. You can just provide me table for which i have to update.

12 $ USD en 0 jours
(16 Commentaires)
3.9
wrarvw

Hello. I have a lot of experience with SQL and MySQL and I think your task can be done in short time.

20 $ USD en 1 jour
(25 Commentaires)
4.2
Webbleu

Greetings, We have gone through your requirement and would to take this opportunity to work on this project. Can you send a detailed requirement about your project. Please check few work done by us: Feel Plus

24 $ USD en 1 jour
(14 Commentaires)
3.8
suvasiniwebguru

Dear Sir, We am Interesting in this work. please check my freelancer profile https://www.freelancer.in/u/suvasiniwebguru.html Here we ware given all time 100% satisfaction. and also check (“Repeat Hire Rate”) Plus

11 $ USD en 1 jour
(17 Commentaires)
3.6
vinaysinghh

A proposal has not yet been provided

15 $ USD en 1 jour
(4 Commentaires)
3.7