Arsip: declare mysql

 
user image
more 17 years ago

muktaf

saya mau buat declare dimysql seperti di bawah ini create or replace function berikutnya(p_nama text) returns int declare i int; begin select nilai into i from urutan where nama = p_nama; update urutan set nilai = i where nama = p_nama; return i; end; salah di mana yaa kok tidak bisa?
user image
more 17 years ago

mas_kofa

declare i int;
kalo di interbase :

declare variable i integer;
user image
more 17 years ago

deLogic

sepertinya di sini :

create or replace function berikutnya(p_nama text) returns int 
harusnya

create function berikutnya(p_nama text) returns int 
user image
more 17 years ago

yayaretina

create or replace function berikutnya(p_nama text) returns int 
mungkin pingin ngecek function dah ada pa blom kalee.. mungkin gini dulu
DROP FUNCTION IF EXISTS f_fungsi;
bethul begithu...
user image
more 17 years ago

muktaf

create function berikutnya(p_nama text) returns int declare i integer; begin select nilai into i from urutan where nama = p_nama; update urutan set nilai = i where nama = p_nama; return i; end; masih tidak bisa ... apa versi mysqlnya kurang high
user image
more 17 years ago

deLogic

nah, makanya, jika mengajukan pertanyaan, sertakan juga data yang lengkap, misal versi MySQL, pesan kesalahan yang muncul, dsb..
user image
more 17 years ago

Manz

:mrgreen: ... mau pake MySQL veri 2000 juga gak bakalan bisa ... coba :

create function ...
declare i integer;
begin
...
end;
dibuat:

create function ...
begin
declare i integer;
...
end;
declare didalam BEGIN .. END; :mrgreen:
more ...
  • Pages:
  • 1
Share to

AI Forward

🚀 We're thrilled to partner with Alibaba Cloud for "AI Forward - Alibaba Cloud Global Developer Summit 2025" in Jakarta! Join us and explore the future of AI. Register now: https://int.alibabacloud.com/m/1000400772/
#AlibabaCloud #DeveloperSummit #Jakarta #AIFORWARD

Random Topic

Local Business Directory, Search Engine Submission & SEO Tools FreeWebSubmission.com SonicRun.com