Jump to content

Database Support

0

How to change all the birthday in SQL to 0000-00-00

Asked by mightyryan,
September 14, 2015

Share

https://rathena.org/board/topic/103106-how-to-change-all-the-birthday-in-sql-to-0000-00-00/

Question

Poring

mightyryan

Posted September 14, 2015

Posted September 14, 2015 (edited)

Hello! Does anybody know here what to query in MySQL to change all the birthday of all the accounts(login) to 0000-00-00?

Edited September 14, 2015 by mightyryan

Quote

2 answers to this question

Recommended Posts

Poring

EL Dragon

Posted September 14, 2015

Posted September 14, 2015

run in mysql

update login set birthdate = '0000-00-00'

1

Quote

Poring

mightyryan

Posted September 15, 2015

Author

Posted September 15, 2015

thanks it works! +1

Quote

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest

Answer this question...

× Pasted as rich text. Paste as plain text instead

Only 75 emoji are allowed.

× Your link has been automatically embedded. Display as a link instead

× Your previous content has been restored. Clear editor

× You cannot paste images directly. Upload or insert images from URL.

Insert image from URL

×

Share

https://rathena.org/board/topic/103106-how-to-change-all-the-birthday-in-sql-to-0000-00-00/

Go to question listing

Recently Browsing 0 members
- No registered users viewing this page.

×

Forums
Docs
- Back
- Get Started
  - Back
  - Installing rAthena
- User Guides
- rA Docs Folder
- Wiki
Github
Downloads
Community
My Account
- Back

×

Create New...