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 438]

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 438]

LEVEL_UP tabloda sil baştan ekle

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

[KODevelopers 438]

Örnek vereyim. Renkleri Dikkatli veriyorum..

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

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

[KODevelopers 438]

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

[IMOTEB 9]

teşekkürler

[KODevelopers 438]

@ IMOTEB rica ederim..