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

en voir plus : loop mysql table update, ajax div refresh mysql table update, mysql fix 2013 query, mysql table update script, mysql execute script file table update, update query mysql, mysql table update, update query mysql aspnet, csv mysql table update, create update query mysql

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

Nº du projet : #8493229

57 freelance font 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 [login to view URL] Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(849 Commentaires)
8.4
sprextech

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(274 Commentaires)
7.4
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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(271 Commentaires)
6.8
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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(115 Commentaires)
6.7
AndrewYer

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(188 Commentaires)
6.4
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 [login to view URL] [login to view URL] Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(332 Commentaires)
6.7
techvolcano

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(226 Commentaires)
6.6
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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(21 Commentaires)
6.0
l4logics

Hii Simple Update Query for this fields Can i do for this.? I will do this work very easily , no worry Thanks

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(108 Commentaires)
6.2
danale72

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(81 Commentaires)
5.8
mrbacklink

A proposal has not yet been provided

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(85 Commentaires)
5.9
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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(110 Commentaires)
5.9
wrarvw

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(33 Commentaires)
5.7
UmidKZ

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(29 Commentaires)
5.2
GenieCode

I can do this dateTime Update for u in no time. Pay only if u r satisfied with my work. I am expert in SQL, MySQL, PHP. I can do this job for u in a little time. I will be available to u any time. I will help u unti Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(20 Commentaires)
5.0
vinaysinghh

A proposal has not yet been provided

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(41 Commentaires)
5.1
baguswah

Hi, I would be happy to create the sql script for you to update the date as your request

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(25 Commentaires)
4.7
angnut

Hi, I can give you the query to update all the date field values. you can find my skill and reference on linkedin (angnut) thanks Angelo

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(14 Commentaires)
4.4
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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(27 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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(46 Commentaires)
4.7