Help with how to insert alot off rows at same time

kotsh · Jan 7, 2013

i need idea to how to add this rows at 1 step cuz i don't know how to insert all this rows at the same time i only can add 1 by 1 please help me

Code:

1	46000	MOB_AR_BARUSWOLF_ADONIS1	??? ???	MOB_EU_BARUSWOLF	SN_MOB_AR_BARUSWOLF_ADONIS1	xxx	0	1	1	2	1	1	5000	3	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	692	0	0	0	0	0	9	41	105	0	17	0	mob\arabia\baruswolf_adonis1.bsr	xxx	xxx	xxx	xxx	30100
1	46001	MOB_AR_BARUSWOLF_ADONIS1_CLONE	???? ??	MOB_EU_BARUSWOLF	SN_MOB_AR_BARUSWOLF_ADONIS1_CLONE	xxx	0	1	1	2	1	1	5000	3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	655	0	0	0	0	0	9	41	80	0	13	0	mob\arabia\baruswolf_adonis1.bsr	xxx	xxx	xxx	xxx	30101
1	46002	MOB_AR_BARUSWOLF_ADONIS2	??? ???	MOB_EU_BARUSWOLF	SN_MOB_AR_BARUSWOLF_ADONIS2	xxx	0	1	1	2	1	1	5000	3	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	711	0	0	0	0	0	9	41	105	0	17	0	mob\arabia\baruswolf_adonis2.bsr	xxx	xxx	xxx	xxx	30102
1	46003	MOB_AR_BARUSWOLF_ADONIS2_CLONE	??? ????	MOB_EU_BARUSWOLF	SN_MOB_AR_BARUSWOLF_ADONIS2_CLONE	xxx	0	1	1	2	1	1	5000	3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	655	0	0	0	0	0	9	41	80	0	13	0	mob\arabia\baruswolf_adonis2.bsr	xxx	xxx	xxx	xxx	30103
1	46004	MOB_AR_MANGYANG_PLUNDER1	??? ????	MOB_AR_MANGYANG_PLUNDER1	SN_MOB_AR_MANGYANG_PLUNDER1	xxx	0	1	1	2	1	1	5000	3	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	692	0	0	0	0	0	8	12	100	0	8	0	mob\arabia\mangyang_plunder1.bsr	xxx	xxx	xxx	xxx	30104
1	46005	MOB_AR_MANGYANG_PLUNDER1_CLONE	??? ???	MOB_AR_MANGYANG_PLUNDER1	SN_MOB_AR_MANGYANG_PLUNDER1_CLONE	xxx	0	1	1	2	1	1	5000	3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	655	0	0	0	0	0	8	12	80	0	6	0	mob\arabia\mangyang_plunder1.bsr	xxx	xxx	xxx	xxx	30105
1	46006	MOB_AR_MANGYANG_PLUNDER2	???? ????	MOB_AR_MANGYANG_PLUNDER1	SN_MOB_AR_MANGYANG_PLUNDER2	xxx	0	1	1	2	1	1	5000	3	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	711	0	0	0	0	0	8	12	110	0	9	0	mob\arabia\mangyang_plunder2.bsr	xxx	xxx	xxx	xxx	30106
1	46007	MOB_AR_MANGYANG_PLUNDER2_CLONE	???? ???	MOB_AR_MANGYANG_PLUNDER1	SN_MOB_AR_MANGYANG_PLUNDER2_CLONE	xxx	0	1	1	2	1	1	5000	3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	673	0	0	0	0	0	8	12	90	0	7	0	mob\arabia\mangyang_plunder2.bsr	xxx	xxx	xxx	xxx	30107
1	46008	MOB_AR_UNEG	?? ???	MOB_EU_MOVOI	SN_MOB_AR_UNEG	xxx	0	1	1	2	1	1	5000	3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	655	0	0	0	0	0	15	45	90	0	9	0	mob\arabia\uneg.bsr	xxx	xxx	xxx	xxx	30108
1	46009	MOB_AR_WENEG	??? ?? ???	MOB_EU_MOVOI	SN_MOB_AR_WENEG	xxx	0	1	1	2	1	1	5000	3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	673	0	0	0	0	0	15	45	100	0	10	0	mob\arabia\uneg.bsr	xxx	xxx	xxx	xxx	30109
1	46010	MOB_AR_MUJIGI_KOOLD	?? ?? ??	MOB_KT_MUJIGI	SN_MOB_AR_MUJIGI_KOOLD	xxx	0	1	1	2	1	1	5000	3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	673	0	0	0	0	0	25	95	100	0	20	0	mob\arabia\mujigi_koold.bsr	xxx	xxx	xxx	xxx	30110
1	46011	MOB_AR_BASTET_MAD	?? ??? ??	MOB_SD_BASTET	SN_MOB_AR_BASTET_MAD	xxx	0	1	1	2	1	1	5000	3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	673	0	0	0	0	0	20	100	100	0	8	0	mob\arabia\bastet_mad.bsr	xxx	xxx	xxx	xxx	30111
1	46012	MOB_AR_BASTET_MAD_THIEF	??? ?? ??	MOB_SD_BASTET	SN_MOB_AR_BASTET_MAD_THIEF	xxx	0	1	1	2	1	1	5000	3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	692	0	0	0	0	0	20	100	100	0	8	0	mob\arabia\bastet_thief.bsr	xxx	xxx	xxx	xxx	30112
1	46013	MOB_AR_BLACKROBBERARCHER_MAD	?? ??? ??	MOB_OA_BLACKROBBERARCHER	SN_MOB_AR_BLACKROBBERARCHER_MAD	xxx	0	1	1	2	1	1	5000	3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	692	0	0	0	0	0	16	75	80	0	8	0	mob\arabia\blackrobberarcher_mad.bsr	xxx	xxx	xxx	xxx	30113
1	46014	MOB_AR_BLACKROBBERARCHER_THIEF	??? ?? ??	MOB_OA_BLACKROBBERARCHER	SN_MOB_AR_BLACKROBBERARCHER_THIEF	xxx	0	1	1	2	1	1	5000	3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	692	0	0	0	0	0	16	75	80	0	8	0	mob\arabia\blackrobberarcher_thief.bsr	xxx	xxx	xxx	xxx	30114
1	46015	MOB_AR_BLACKROBBERARCHER_THIEF_CLONE	?? ?? ??	MOB_OA_BLACKROBBERARCHER	SN_MOB_AR_BLACKROBBERARCHER_THIEF_CLONE	xxx	0	1	1	2	1	1	5000	3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	731	0	0	0	0	0	16	75	90	0	9	0	mob\arabia\blackrobberarcher_thief.bsr	xxx	xxx	xxx	xxx	30115
1	46016	MOB_AR_BLACKROBBER_MAD	?? ??? ???	MOB_OA_BLACKROBBER	SN_MOB_AR_BLACKROBBER_MAD	xxx	0	1	1	2	1	1	5000	3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	692	0	0	0	0	0	20	75	100	0	9	0	mob\arabia\blackrobber_mad.bsr	xxx	xxx	xxx	xxx	30116
1	46017	MOB_AR_BLACKROBBER_THIEF	??? ?? ??	MOB_OA_BLACKROBBER	SN_MOB_AR_BLACKROBBER_THIEF	xxx	0	1	1	2	1	1	5000	3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	711	0	0	0	0	0	20	75	100	0	9	0	mob\arabia\blackrobber_thief.bsr	xxx	xxx	xxx	xxx	30117
1	46018	MOB_AR_BLACKROBBER_THIEF_CLONE	?? ?? ??	MOB_OA_BLACKROBBER	SN_MOB_AR_BLACKROBBER_THIEF_CLONE	xxx	0	1	1	2	1	1	5000	3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	731	0	0	0	0	0	20	75	100	0	9	0	mob\arabia\blackrobber_thief.bsr	xxx	xxx	xxx	xxx	30118
1	46019	MOB_AR_DARKKHEPRI_EVIL	??? ????	MOB_SD_DARKKHEPRI	SN_MOB_AR_DARKKHEPRI_EVIL	xxx	0	1	1	2	1	1	5000	3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	692	0	0	0	0	0	40	75	100	0	20	0	mob\arabia\darkkhepri_evil.bsr	xxx	xxx	xxx	xxx	30119
1	46020	MOB_AR_DARKKHEPRI_EVIL_CLONE1	??? ???	MOB_SD_DARKKHEPRI	SN_MOB_AR_DARKKHEPRI_EVIL_CLONE1	xxx	0	1	1	2	1	1	5000	3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	711	0	0	0	0	0	40	75	100	0	20	0	mob\arabia\darkkhepri_evil.bsr	xxx	xxx	xxx	xxx	30120
1	46021	MOB_AR_DARKKHEPRI_EVIL_CLONE2	??? ???	MOB_SD_DARKKHEPRI	SN_MOB_AR_DARKKHEPRI_EVIL_CLONE2	xxx	0	1	1	2	1	1	5000	3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	731	0	0	0	0	0	40	75	100	0	20	0	mob\arabia\darkkhepri_evil.bsr	xxx	xxx	xxx	xxx	30121
1	46022	MOB_AR_BLOOD_HYENA_WILDWOLF	??? ???	MOB_SD_BLOOD_HYENA	SN_MOB_AR_BLOOD_HYENA_WILDWOLF	xxx	0	1	1	2	1	1	5000	3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	692	0	0	0	0	0	30	110	35	0	14	0	mob\arabia\blood_hyena_wildwolf.bsr	xxx	xxx	xxx	xxx	30122
1	46023	MOB_AR_BLOOD_HYENA_WILDWOLF_CLONE	???? ???	MOB_SD_BLOOD_HYENA	SN_MOB_AR_BLOOD_HYENA_WILDWOLF_CLONE	xxx	0	1	1	2	1	1	5000	3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	692	0	0	0	0	0	30	110	40	0	16	0	mob\arabia\blood_hyena_wildwolf.bsr	xxx	xxx	xxx	xxx	30123
1	46024	MOB_AR_BLOOD_HYENA_FASTWOLF	??? ???	MOB_SD_BLOOD_HYENA	SN_MOB_AR_BLOOD_HYENA_FASTWOLF	xxx	0	1	1	2	1	1	5000	3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	673	0	0	0	0	0	30	110	35	0	14	0	mob\arabia\blood_hyena_fastwolf.bsr	xxx	xxx	xxx	xxx	30124
1	46025	MOB_AR_BLOOD_HYENA_FASTWOLF_CLONE	??? ???	MOB_SD_BLOOD_HYENA	SN_MOB_AR_BLOOD_HYENA_FASTWOLF_CLONE	xxx	0	1	1	2	1	1	5000	3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	711	0	0	0	0	0	30	110	40	0	16	0	mob\arabia\blood_hyena_fastwolf.bsr	xxx	xxx	xxx	xxx	30125
1	46026	MOB_AR_SNAKE_CLONE1	??? ???	xxx	SN_MOB_AR_SNAKE_CLONE1	xxx	0	1	1	2	1	1	5000	3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	731	0	0	0	0	0	10	55	100	0	10	0	mob\arabia\snake.bsr	xxx	xxx	xxx	xxx	30126
1	46027	MOB_AR_SNAKEDEMON_WARAN	??	MOB_TQ_SNAKEDEMON	SN_MOB_AR_SNAKEDEMON_WARAN	xxx	0	1	1	2	1	1	5000	3	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	711	0	0	0	0	0	60	110	100	0	25	0	mob\arabia\snakedemon_waran.bsr	xxx	xxx	xxx	xxx	30127
1	46028	MOB_AR_SABRA_CACTUS	?? ??? ???	xxx	SN_MOB_AR_SABRA_CACTUS	xxx	0	1	1	2	1	1	5000	3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	711	0	0	0	0	0	10	30	200	0	16	0	mob\arabia\sabra.bsr	xxx	xxx	xxx	xxx	30128
1	46029	MOB_AR_KARMOS_CACTUS	?? ??? ????	MOB_AR_SABRA_CACTUS	SN_MOB_AR_KARMOS_CACTUS	xxx	0	1	1	2	1	1	5000	3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	731	0	0	0	0	0	10	30	200	0	16	0	mob\arabia\karmus.bsr	xxx	xxx	xxx	xxx	30129
1	46030	MOB_AR_THIEF_BOSS_TOOTH	???? ??	MOB_SD_SAND_HYENA	SN_MOB_AR_THIEF_BOSS_TOOTH	xxx	0	1	1	2	1	1	5000	3	6	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	731	0	0	0	0	0	10	120	50	0	23	0	mob\arabia\thief_boss_tooth.bsr	xxx	xxx	xxx	xxx	30130
1	46031	MOB_AR_BAST_2_ARMOR	???? ???	MOB_AM_ROGUE	SN_MOB_AR_BAST_2_ARMOR	xxx	0	1	1	2	1	1	5000	3	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	711	0	0	0	0	0	20	90	100	0	8	0	mob\arabia\bast_2_armor.bsr	xxx	xxx	xxx	xxx	30131
1	46032	MOB_AR_BLACKROBBERARCHER_ARMOR	???? ?? ??	MOB_EU_BAROI	SN_MOB_AR_BLACKROBBERARCHER_ARMOR	xxx	0	1	1	2	1	1	5000	3	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	692	0	0	0	0	0	17	55	100	0	10	0	mob\arabia\blackrobberarcher_armor.bsr	xxx	xxx	xxx	xxx	30132
1	46033	MOB_AR_BLACKROBBER_ARMOR	???? ???	MOB_EU_BARPOLLE	SN_MOB_AR_BLACKROBBER_ARMOR	xxx	0	1	1	2	1	1	5000	3	6	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	731	0	0	0	0	0	12	30	100	0	9	0	mob\arabia\blackrobber_armor.bsr	xxx	xxx	xxx	xxx	30133
1	46034	MOB_AR_TELBASTA_2_ARMOR	???? ???	MOB_CA_HUNLANCER	SN_MOB_AR_TELBASTA_2_ARMOR	xxx	0	1	1	2	1	1	5000	3	6	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	731	0	0	0	0	0	12	30	100	0	23	0	mob\arabia\telbasta_2_armor.bsr	xxx	xxx	xxx	xxx	30134
1	46035	MOB_ARABIA_THIEF_BOSS	?? ?? ???	xxx	SN_MOB_ARABIA_THIEF_BOSS	xxx	0	1	1	2	1	1	5000	3	3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	731	0	0	0	0	0	30	120	100	0	20	0	mob\arabia\thief_boss.bsr	xxx	xxx	xxx	xxx	30135
1	46036	MOB_ARABIA_MAD_GENERAL	???? ???	xxx	SN_MOB_ARABIA_MAD_GENERAL	xxx	0	1	1	2	1	1	5000	3	3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	731	0	0	0	0	0	30	75	100	0	12	0	mob\arabia\mad_general_1.bsr,mob\arabia\mad_general_2.bsr,mob\arabia\mad_general_3.bsr	xxx	xxx	xxx	xxx	30136
1	46037	MOB_ARABIA_MAD_GENERAL_CLONE	???? ?? ??	MOB_ARABIA_MAD_GENERAL	SN_MOB_ARABIA_MAD_GENERAL_CLONE	xxx	0	1	1	2	1	1	5000	3	3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	731	0	0	0	0	0	30	75	50	0	6	0	mob\arabia\mad_general_3_clone.bsr	xxx	xxx	xxx	xxx	30137
1	46038	MOB_ARABIA_GIANT_DEMON	?? ??	xxx	SN_MOB_ARABIA_GIANT_DEMON	xxx	0	1	1	2	1	1	5000	3	3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	731	0	0	0	0	0	20	55	100	0	12	0	mob\arabia\giant_demon.bsr	xxx	xxx	xxx	xxx	30138
1	46039	MOB_ARABIA_MUSTAFA	????	xxx	SN_MOB_ARABIA_MUSTAFA	xxx	0	1	1	2	1	1	5000	3	3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	731	0	0	0	0	0	30	75	100	0	10	0	mob\arabia\mustafa.bsr	xxx	xxx	xxx	xxx	30139
1	46040	MOB_ARABIA_KARKADANN	????	xxx	SN_MOB_ARABIA_KARKADANN	xxx	0	1	1	2	1	1	5000	3	3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	692	0	0	0	0	0	20	120	75	0	49	0	mob\arabia\karkadann.bsr	xxx	xxx	xxx	xxx	30140
1	46041	MOB_ARABIA_KIDEMONAS	?????	xxx	SN_MOB_ARABIA_KIDEMONAS	xxx	0	1	1	2	1	1	5000	3	3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	637	0	0	0	0	0	20	120	150	0	98	0	mob\arabia\kidemonas.bsr	xxx	xxx	xxx	xxx	30141

bdeniz · Jan 7, 2013

copy the codes and paste in sql table.

some rows can be buggy. so you cant insert all rows.

the rows shared in rage zone, are usually buggy. download with .txt and copy and paste

Welcome!

Help with how to insert alot off rows at same time

kotsh

Newbie Spellweaver

bdeniz

Newbie Spellweaver

RaGEZONE Sponsor

About RaGEZONE

Forum Statistics

RaGEZONE Partners