db ye levelup ekeme kodu

[IMOTEB 9]

arkadaşlar db ye levelup eklemek istiyorum fakat yapamadım her yerde böyle örnekler var onuda denedim olmadı yardımcı olurmusunuz böyle bişey ekleyeerk olması gerekmiyormuydu
insert into bunun gibi birşey ama heryerde bu var

update LEVEL_UP set Exp = '50' where Level = '1'
update LEVEL_UP set Exp = '100' where Level = '2'
update LEVEL_UP set Exp = '190' where Level = '3'
update LEVEL_UP set Exp = '342' where Level = '4'
update LEVEL_UP set Exp = '581' where Level = '5'
update LEVEL_UP set Exp = '929' where Level = '6'
update LEVEL_UP set Exp = '1393' where Level = '7'
update LEVEL_UP set Exp = '1950' where Level = '8'
update LEVEL_UP set Exp = '2535' where Level = '9'
update LEVEL_UP set Exp = '5070' where Level = '10'
update LEVEL_UP set Exp = '6084' where Level = '11'
update LEVEL_UP set Exp = '7300' where Level = '12'
update LEVEL_UP set Exp = '8760' where Level = '13'

bi el atarmısınız acaba umarım anlatabilmisimdir sorunumu

[KODevelopers 443]

INSERT INTO LEVEL_UP VALUES('1','2')
INSERT INTO LEVEL_UP VALUES('2','6')
INSERT INTO LEVEL_UP VALUES('3','10')
INSERT INTO LEVEL_UP VALUES('4','20')
INSERT INTO LEVEL_UP VALUES('5','36')
INSERT INTO LEVEL_UP VALUES('6','58')
INSERT INTO LEVEL_UP VALUES('7','86')
INSERT INTO LEVEL_UP VALUES('8','120')
INSERT INTO LEVEL_UP VALUES('9','158')
INSERT INTO LEVEL_UP VALUES('10','316')
INSERT INTO LEVEL_UP VALUES('11','2300')
INSERT INTO LEVEL_UP VALUES('12','2560')
INSERT INTO LEVEL_UP VALUES('13','4474')
INSERT INTO LEVEL_UP VALUES('14','4570')
INSERT INTO LEVEL_UP VALUES('15','5380')
INSERT INTO LEVEL_UP VALUES('16','5960')
INSERT INTO LEVEL_UP VALUES('17','6350')
INSERT INTO LEVEL_UP VALUES('18','6620')
INSERT INTO LEVEL_UP VALUES('19','8344')
INSERT INTO LEVEL_UP VALUES('20','16190')
INSERT INTO LEVEL_UP VALUES('21','18094')
INSERT INTO LEVEL_UP VALUES('22','21734')
INSERT INTO LEVEL_UP VALUES('23','24220')
INSERT INTO LEVEL_UP VALUES('24','27674')
INSERT INTO LEVEL_UP VALUES('25','32750')
INSERT INTO LEVEL_UP VALUES('26','37614')
INSERT INTO LEVEL_UP VALUES('27','42960')
INSERT INTO LEVEL_UP VALUES('28','50000')
INSERT INTO LEVEL_UP VALUES('29','57500')
INSERT INTO LEVEL_UP VALUES('30','115004')
INSERT INTO LEVEL_UP VALUES('31','258003')
INSERT INTO LEVEL_UP VALUES('32','263305')
INSERT INTO LEVEL_UP VALUES('33','286137')
INSERT INTO LEVEL_UP VALUES('34','271750')
INSERT INTO LEVEL_UP VALUES('35','290124')
INSERT INTO LEVEL_UP VALUES('36','395640')
INSERT INTO LEVEL_UP VALUES('37','401204')
INSERT INTO LEVEL_UP VALUES('38','532324')
INSERT INTO LEVEL_UP VALUES('39','679554')
INSERT INTO LEVEL_UP VALUES('40','1729114')
INSERT INTO LEVEL_UP VALUES('41','1827024')
INSERT INTO LEVEL_UP VALUES('42','1904730')
INSERT INTO LEVEL_UP VALUES('43','2683700')
INSERT INTO LEVEL_UP VALUES('44','2880570')
INSERT INTO LEVEL_UP VALUES('45','2883354')
INSERT INTO LEVEL_UP VALUES('46','3933190')
INSERT INTO LEVEL_UP VALUES('47','3980510')
INSERT INTO LEVEL_UP VALUES('48','4158564')
INSERT INTO LEVEL_UP VALUES('49','5425920')
INSERT INTO LEVEL_UP VALUES('50','6261840')
INSERT INTO LEVEL_UP VALUES('51','8463024')
INSERT INTO LEVEL_UP VALUES('52','9509324')
INSERT INTO LEVEL_UP VALUES('53','9660260')
INSERT INTO LEVEL_UP VALUES('54','11926284')
INSERT INTO LEVEL_UP VALUES('55','12889430')
INSERT INTO LEVEL_UP VALUES('56','13478370')
INSERT INTO LEVEL_UP VALUES('57','14776204')
INSERT INTO LEVEL_UP VALUES('58','16303830')
INSERT INTO LEVEL_UP VALUES('59','22584210')
INSERT INTO LEVEL_UP VALUES('60','45876314')
INSERT INTO LEVEL_UP VALUES('61','62577370')
INSERT INTO LEVEL_UP VALUES('62','75835110')
INSERT INTO LEVEL_UP VALUES('63','95918620')
INSERT INTO LEVEL_UP VALUES('64','110910480')
INSERT INTO LEVEL_UP VALUES('65','120901530')
INSERT INTO LEVEL_UP VALUES('66','150991680')
INSERT INTO LEVEL_UP VALUES('67','200290850')
INSERT INTO LEVEL_UP VALUES('68','210919934')
INSERT INTO LEVEL_UP VALUES('69','240011930')
INSERT INTO LEVEL_UP VALUES('70','259713120')
INSERT INTO LEVEL_UP VALUES('71','358655744')
INSERT INTO LEVEL_UP VALUES('72','403658074')
INSERT INTO LEVEL_UP VALUES('73','584360904')
INSERT INTO LEVEL_UP VALUES('74','698054020')
INSERT INTO LEVEL_UP VALUES('75','777517724')
INSERT INTO LEVEL_UP VALUES('76','831126520')
INSERT INTO LEVEL_UP VALUES('77','844797758')
INSERT INTO LEVEL_UP VALUES('78','890866980')
INSERT INTO LEVEL_UP VALUES('79','952366390')
INSERT INTO LEVEL_UP VALUES('80','1186691640')
INSERT INTO LEVEL_UP VALUES('81','1887367430')
INSERT INTO LEVEL_UP VALUES('82','2919106342')
INSERT INTO LEVEL_UP VALUES('83','3480006664')

Böyle yapabilirsin.

[KODevelopers 443]

LEVEL_UP tabloda sil baştan ekle

CREATE TABLE [dbo].[LEVEL_UP](
	[level] [tinyint] NOT NULL,
	[Exp] [bigint] NULL
) ON [PRIMARY]
GO

[KODevelopers 443]

Örnek vereyim. Renkleri Dikkatli veriyorum..

update LEVEL_UP set Exp = '50' where Level = '1'

INSERT INTO LEVEL_UP VALUES('1','50')

[KODevelopers 443]

@ IMOTEB sorunu çözdün mü cevap verir misin ?

[IMOTEB 9]

teşekkürler

[KODevelopers 443]

@ IMOTEB rica ederim..