Yardım erorr SQL

  • Konuyu açan Konuyu açan M29
  • Açılış Tarihi Açılış Tarihi
  • Yanıt Yanıt 5
  • Gösterim Gösterim 53
Konu sahibi bu konuda soru soruyor. Sorusu ile ilgili bilgisi olanların yanıtlamasını bekliyor.

M29

MT Üye
MT Üye
Mesaj
309
Çözümler
7
Beğeni
179
Puan
749
Ticaret Puanı
0
Hi guys
I added the Yohara continent from the source and client and everything is fine but I have a problem with adding in SQL I don't know why this error always appears in some things it always appears

Screenshot_1.webp


Kod:
Genişlet Daralt Kopyala
ALTER TABLE `player`
ADD COLUMN `conquerorlevel`  tinyint(2) NOT NULL DEFAULT 0 AFTER `lkill_point`,
ADD COLUMN `conqueror_level_step`  tinyint(1) NOT NULL DEFAULT 0 AFTER `conquerorlevel`,
ADD COLUMN `sungma_str`  smallint(3) NOT NULL DEFAULT 0 AFTER `conqueror_level_step`,
ADD COLUMN `sungma_hp`  smallint(3) NOT NULL DEFAULT 0 AFTER `sungma_str`,
ADD COLUMN `sungma_move`  smallint(3) NOT NULL DEFAULT 0 AFTER `sungma_hp`,
ADD COLUMN `sungma_inmune`  smallint(3) NOT NULL DEFAULT 0 AFTER `sungma_move`,
ADD COLUMN `conqueror_exp`  bigint(255) NOT NULL DEFAULT 0 AFTER `sungma_inmune`;
ADD COLUMN `conqueror_point`  smallint(3) NOT NULL DEFAULT 0 AFTER `conqueror_exp`,
 
Çözüm
çözüm :

SQL:
Genişlet Daralt Kopyala
ALTER TABLE player
ADD COLUMN conquerorlevel  tinyint(2) NOT NULL DEFAULT 0,
ADD COLUMN conqueror_level_step  tinyint(1) NOT NULL DEFAULT 0,
ADD COLUMN sungma_str  smallint(3) NOT NULL DEFAULT 0,
ADD COLUMN sungma_hp  smallint(3) NOT NULL DEFAULT 0,
ADD COLUMN sungma_move  smallint(3) NOT NULL DEFAULT 0,
ADD COLUMN sungma_inmune  smallint(3) NOT NULL DEFAULT 0,
ADD COLUMN conqueror_exp  bigint(20) NOT NULL DEFAULT 0,
ADD COLUMN conqueror_point  smallint(3) NOT NULL DEFAULT 0;
If you want to add a SQL query file, here's how you can do it Open your MySQL application or database management tool. Go to the section where you want to apply the query — for example, the player or item table. Look for a section labeled “Query” at the bottom of the interface. Copy and paste the contents of your .sql file into this query section.Then, click on “New” or “Execute” (depending on what your interface shows) to run the query and apply the changes to your database Let me know if you need help with any specific SQL file or query.
 
çözüm :

SQL:
Genişlet Daralt Kopyala
ALTER TABLE player
ADD COLUMN conquerorlevel  tinyint(2) NOT NULL DEFAULT 0,
ADD COLUMN conqueror_level_step  tinyint(1) NOT NULL DEFAULT 0,
ADD COLUMN sungma_str  smallint(3) NOT NULL DEFAULT 0,
ADD COLUMN sungma_hp  smallint(3) NOT NULL DEFAULT 0,
ADD COLUMN sungma_move  smallint(3) NOT NULL DEFAULT 0,
ADD COLUMN sungma_inmune  smallint(3) NOT NULL DEFAULT 0,
ADD COLUMN conqueror_exp  bigint(20) NOT NULL DEFAULT 0,
ADD COLUMN conqueror_point  smallint(3) NOT NULL DEFAULT 0;
 
Çözüm
Geri
Üst