HELP ME! http://www.patreon.com/calebcurry Subscribe to my newsletter: http://eepurl.com/-8qtH Donate!: http://bit.ly/DonateCTVM2.
Original source
MySQL Tutorial 12 – Altering Data and More Advanced Queries (MySQL in English)
HELP ME! http://www.patreon.com/calebcurry Subscribe to my newsletter: http://eepurl.com/-8qtH Donate!: http://bit.ly/DonateCTVM2.
Original source
12 responses to “MySQL Tutorial 12 – Altering Data and More Advanced Queries (MySQL in English)”
I have to say this tutorial playlist is great!
is a whereclause as scary as a werewolf? good video 🙂
plzz give me a process to consult you with any programming queries i am from asia india how can i contact you
your comment on LIMITS left me hanging. Is this a display command or does it affect number of members in the database?
Watch series with autoplay: MySQL Tutorial 1 – What is MySQL @CalebCurry
Donations are greatly needed and appreciated! Click to donate: http://bit.ly/DonateCTVM2
Mis-spelling? should be "WEHRE", right?
Fantastic series! Thanks for making this available to the public for free.
thanks
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.
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?
"I'll just do pushups at my house. Got a problem?"
lol. Nice. I like your style.
Alter Table SQL commmand should be :ALTER TABLE members ADD first name VARCHAR(20);