469,313 Members | 2,642 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,313 developers. It's quick & easy.

Data Processing and SQL INSERTING

Data Processing and SQL INSERTING

Hello guy's i'm faced with a horrible dilemma i have whole dictionary that i
have to enter into a database. I have all the text and i would like to
convert it into a sql insert query so i don't have to enter all that data
manually. I would like some recommendation on the best way i could get this
data into the data. If anyone has any suggestions please help. this is what
I'm facing.


This is how data is originally

Step 1:

dominize - 1. To line up dominoes in interesting patterns and knock them
over, causing the domino effect. 2. To do this with any other multiple
rectangular objects. 3. To utterly destroy the whole by defeating one small
part, much in the same manner.
e.g., Did you see that episode of "America's Funniest Home Videos" where
those guys dominized a thousand empty VHS cases? That was awesome.
submitted by BigAssFries - (www)
Step 2: remove "submitted by BigAssFries - (www)"

dominize - 1. To line up dominoes in interesting patterns and knock them
over, causing the domino effect. 2. To do this with any other multiple
rectangular objects. 3. To utterly destroy the whole by defeating one small
part, much in the same manner.
e.g., Did you see that episode of "America's Funniest Home Videos" where
those guys dominized a thousand empty VHS cases? That was awesome.

Step 3: Seperate text * when there is more then one meaning there are
numbers other wise there aren't. example"dome - "your head, above the face."
e.g., "John just got mugged! They slapped a lead pipe against his dome!"
submitted by dust" there are also sometimes " at the begining of meaning and
some times not.

dominize -
1. To line up dominoes in interesting patterns and knock them
over, causing the domino effect.
2. To do this with any other multiple
rectangular objects.
3. To utterly destroy the whole by defeating one small
part, much in the same manner.
e.g., Did you see that episode of "America's Funniest Home Videos" where
those guys dominized a thousand empty VHS cases? That was awesome.
Step 4: Format text

dominize - add \" and \'
1. To line up dominoes in interesting patterns and knock them over, causing
the domino effect.
2. To do this with any other multiple rectangular objects.
3. To utterly destroy the whole by defeating one small part, much in the
same manner.
e.g., Did you see that episode of \"America's Funniest Home Videos\" where
those guys dominized a thousand empty VHS cases? That was awesome.

Step 5: Remove - and e.g.,

dominize
1. To line up dominoes in interesting patterns and knock them over, causing
the domino effect.
2. To do this with any other multiple rectangular objects.
3. To utterly destroy the whole by defeating one small part, much in the
same manner.
Did you see that episode of "America's Funniest Home Videos" where those
guys dominized a thousand empty VHS cases? That was awesome.
Step 6: Create SQl query - NULL is always NULL and yes is always yes the
numbers must increment look at the example below.

INSERT INTO vocab VALUES (1, 'dominize', 'yes');
INSERT INTO meaning VALUES (NULL, 1, 'To line up dominoes in interesting
patterns and knock them over, causing the domino effect.', NULL, 'Did you
see that episode of "America's Funniest Home Videos" where those guys
dominized a thousand empty VHS cases? That was awesome.');
INSERT INTO meaning VALUES (NULL, 1, 'To do this with any other multiple
rectangular objects.', NULL, 'NULL');
INSERT INTO meaning VALUES (NULL, 1, 'To utterly destroy the whole by
defeating one small part, much in the same manner.', NULL, 'NULL');
INSERT INTO vocab VALUES (2, 'word #2', 'yes');
INSERT INTO meaning VALUES (NULL, 2, 'To line up dominoes in interesting
patterns and knock them over, causing the domino effect.', NULL, 'Did you
see that episode of "America's Funniest Home Videos" where those guys
dominized a thousand empty VHS cases? That was awesome.');

INSERT INTO vocab VALUES (2, 'word #3', 'yes');
INSERT INTO meaning VALUES (NULL, 3, 'To line up dominoes in interesting
patterns and knock them over, causing the domino effect.', NULL, 'Did you
see that episode of "America's Funniest Home Videos" where those guys
dominized a thousand empty VHS cases? That was awesome.');
INSERT INTO meaning VALUES (NULL, 3, 'To line up dominoes in interesting
patterns and knock them over, causing the domino effect.', NULL, 'NULL');
Jul 19 '05 #1
0 1869

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Redd | last post: by
4 posts views Thread by oshanahan | last post: by
1 post views Thread by Ramesh | last post: by
9 posts views Thread by David Harris | last post: by
5 posts views Thread by Chris | last post: by
1 post views Thread by Steveaux | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by harlem98 | last post: by
1 post views Thread by Geralt96 | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.