Arsip: declare mysql
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?
more 17 years ago
deLogic
sepertinya di sini :
create or replace function berikutnya(p_nama text) returns int
create function berikutnya(p_nama text) returns int
more 17 years ago
yayaretina
create or replace function berikutnya(p_nama text) returns int DROP FUNCTION IF EXISTS f_fungsi;
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
more 17 years ago
deLogic
nah, makanya, jika mengajukan pertanyaan, sertakan juga data yang lengkap, misal versi MySQL, pesan kesalahan yang muncul, dsb..
more 17 years ago
Manz
:mrgreen: ... mau pake MySQL veri 2000 juga gak bakalan bisa ...
coba :
create function ...
declare i integer;
begin
...
end;
create function ...
begin
declare i integer;
...
end;
more ...
- Pages:
- 1
reply |
Report Obsolete
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
Last Articles
Last Topic
- PascalTalk #6: (Podcast) Kuliah IT di luar negeri, susah gak sih?
by LuriDarmawan in Tutorial & Community Project more 5 years ago - PascalTalk #5: UX: Research, Design and Engineer
by LuriDarmawan in Tutorial & Community Project more 5 years ago - PascalTalk #4: Obrolan Ringan Seputar IT
by LuriDarmawan in Tutorial & Community Project more 5 years ago - PascalTalk #2: Membuat Sendiri SMART HOME
by LuriDarmawan in Tutorial & Community Project more 5 years ago - PascalTalk #3: RADically Fast and Easy Mobile Apps Development with Delphi
by LuriDarmawan in Tutorial & Community Project more 5 years ago - PascalTalk #1: Pemanfaatan Artificial Intelligence di Masa Covid-19
by LuriDarmawan in Tutorial & Community Project more 5 years ago - Tempat Latihan Posting
by LuriDarmawan in OOT more 5 years ago - Archive
- Looping lagi...
by idhiel in Hal umum tentang Pascal Indonesia more 13 years ago - [ask] koneksi ke ODBC user Dsn saat runtime dengan ado
by halimanh in FireBird more 13 years ago - Validasi menggunakan data tanggal
by mas_kofa in Hal umum tentang Pascal Indonesia more 13 years ago
Random Topic
- Tanya Harga dan Agen Penjualan Delphi Family
by masdi2t in Hal umum tentang Pascal Indonesia more 19 years ago - Delete Record AdoTabel
by kakaManiez in Reporting more 18 years ago - Upgred YIntai biar bisa log in lagi
by mandoh in Network, Files, I/O & System more 16 years ago - query...
by heri15_com in Games more 16 years ago - mo tanya fungsi return
by NggotMan in Hal umum tentang Pascal Indonesia more 18 years ago - TComport (Data Serial Ada New Line)
by exeption_e77or in Tutorial & Community Project more 13 years ago - Borland Delphi 7 in Windows Vista
by BorlandMania in Hal umum tentang Pascal Indonesia more 17 years ago - menampilkan tanggal dengan periode tertentu dari 2 tabel
by don2103 in Lain-lain more 15 years ago - konversi database dari mssql ke mysql
by rofans in MySQL more 16 years ago - about TLCDLabel.....
by ImanD in Tip n Trik Pemrograman more 18 years ago