473,385 Members | 1,569 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

Move data from one columnt to two others

I have a text file that looks something like this:
Homer Simpson [Nuclear plant] /Marge/Lisa/Bart/.../.../

I have successfuly inserted the text file into a column in my mysql
database. However, I would now like to move the data into two other
columns. For example, I have three columns...name, location,
familymembers. I want to move everything contained in [] to location
and everything starting with the / to the familymembers column. Could
someone explain how to do this with mysql? thanks.
Jul 19 '05 #1
0 1447

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Jeff | last post by:
I have a text file that looks something like this: Homer Simpson /Marge/Lisa/Bart/.../.../ I have successfuly inserted the text file into a column in my mysql database. However, I would now...
1
by: Ray Lavelle | last post by:
I have an application I have developed and been working on for about 2 years. It was written in VB6 with a SQL Server database. Things have been going well but I am reaching the point where I...
11
by: supreeth | last post by:
Hi, Would like to know how to move a file in c++ programmatically.Something like File.Move in .net environment. I am not looking at Invoking the 'move' command through the 'System'. Or...
3
by: hi | last post by:
Hi, I've created a form, on the bottom it has the navigation buttons to move to the next/previous records. However, the button for "new record" is greyed out (i can't select it). How do I make...
7
by: Tim Conner | last post by:
Hi, I am an ex-delphi programmer, and I having a real hard time with the following simple code (example ): Which is the equivalent to the following code ? var chars : PChar; sBack, s :...
5
by: Jarod | last post by:
hey I tried to make ASP.Net site with a datagrid. On the dg there is a button columnt with command set to select. I put in the code some very simple ItemCommandEvent. In the ... generated code...
10
by: Robert | last post by:
I have an app that was originally 1.1, now migrated to 2.0 and have run into some sporadic viewstate errors...usually saying the viewstate is invalid, eventvalidation failed or mac error. My web...
33
by: Frederick Gotham | last post by:
(My dialect of English seems to puzzle people at times, so I'll first clarify a few terms which I use in the following post:) (1) By "domestic", I mean "ordinary, run-of-the-mill, not...
10
by: Peter | last post by:
VS 2003 .NET 1.1 What is the fastest way to move 2 dimensional Array of objects into a DataTable, besides using a loop? I have a about 30,000 elements in my array and I have to move it into a...
12
by: mantrid | last post by:
Hello Can anyone point me in the right direction for the way to read a text file a line at a time and separate the fields on that line and use them as data in an INSERT to add a record to a mysql...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.