• Sunday , 15 October 2017

MySQL Tutorial 12 – Altering Data and More Advanced Queries (MySQL in English)

Code Canyon



HELP ME! http://www.patreon.com/calebcurry Subscribe to my newsletter: http://eepurl.com/-8qtH Donate!: http://bit.ly/DonateCTVM2.

Original source

3d Ocean

Related Posts

12 Comments

  1. amir oliaee
    September 16, 2017 at 18:23

    I have to say this tutorial playlist is great!

  2. Ja va
    September 16, 2017 at 18:23

    is a whereclause as scary as a werewolf? good video 🙂

  3. AndroidGaming Tricks
    September 16, 2017 at 18:23

    plzz give me a process to consult you with any programming queries i am from asia india how can i contact you

  4. Michael Maurer
    September 16, 2017 at 18:23

    your comment on LIMITS left me hanging. Is this a display command or does it affect number of members in the database?

  5. CalebTheVideoMaker2
    September 16, 2017 at 18:23

    Watch series with autoplay: MySQL Tutorial 1 – What is MySQL @CalebCurry

    Donations are greatly needed and appreciated! Click to donate: http://bit.ly/DonateCTVM2

  6. Timothy Lo
    September 16, 2017 at 18:23

    Mis-spelling? should be "WEHRE", right? 

  7. Justin Harris
    September 16, 2017 at 18:23

    Fantastic series! Thanks for making this available to the public for free.

  8. science2491
    September 16, 2017 at 18:23

    thanks

  9. CalebTheVideoMaker2
    September 16, 2017 at 18:23

    YES you can. Although the query is much more intense and there is no predefined function that I know of. This would be a process of SUBSTRINGing (see my functions vid) the first and last part of the results of LOCATE…LOCATE is used to find the the space within a string and then you just work your databasing magic to separate the first part followed by the last part and insert them in to new rows. hit up stack overflow if you want to know more. Or find me on Fbook.

  10. snowwolph
    September 16, 2017 at 18:23

    Instead of just deleting the name column with all the data, is it possible to split the name column into `first_name` and `last_name` based on the `space` between the first and last name?

  11. santeyio
    September 16, 2017 at 18:23

    "I'll just do pushups at my house. Got a problem?"

    lol. Nice. I like your style.

  12. Da Kop
    September 16, 2017 at 18:23

    Alter Table SQL commmand should be :ALTER TABLE members ADD first name VARCHAR(20);

Leave A Comment

You must be logged in to post a comment.