Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
MySQL: Need help splitting a field
Hi Tony, Thanks for your reply. That's done the trick, just need to loop it now. Have never used a SUBSTRING_INDEX before (yes, i really am that new lol) Thanks again, much appreciated. Matt -
Ghost Tables
Hi YoungManRiver, I have 2 possible solutions for you, but i'm sure others will post better ones (i'm still fairly new to MySQL myself) However 2 ways are this: CREATE TABLE new_table AS SELECT * FROM existing_table ORDER BY primary_key; This will re-create a new table which contains all of... -
MySQL: Need help splitting a field
Hi, First time posting, but i have found this forum really useful in the past. The issue i have is that i need to be able to take information from a single field and split it into many fields within another table. I'm developing new processes for an all ready exisiting system which has it's own...
