Devilzc0de Forum Follow @devilzc0de
  • Home
  • Hacking
  • Networking
  • Programming
  • O.S
  • Server
  • Tweets
  • Search
  • Member List
  • Calendar
Current time: 05-21-2013, 04:38 PM Hello There, Guest! (Login — Register)
Devilzc0de Forum › Information Technology › Database › Mysql v
« Previous 1 2 3 Next »

[Solved] Mysql (T_T)

Home General Computer Multimedia Business Lounge

Pages (2): « Previous 1 2
Post Reply 
Tweet
Threaded Mode | Linear Mode
Solved Mysql (T_T)
02-06-2012, 04:03 AM
Post: #11
aragon Offline
Banned
Posts: 7
Joined: Sep 2011
RE: Mysql (T_T)
buat view dulu aja om
Code:
CREATE VIEW vstaff AS
SELECT nama, thn_angkatan, id_jab4 FROM staff

trus buat nampilin datanya
Code:
SELECT * FROM vstaff WHERE thn_angkatan BETWEEN 2006 and 2010

ane taunya itu om, kalo querynya pakai kecuali ane gak tau om..
Find all posts by this user
Quote this message in a reply
02-06-2012, 10:29 AM
Post: #12
zulinvation Offline
./Devilz 1st Cadet
Posts: 6
Joined: Feb 2012
Reputation: 1
RE: Mysql (T_T)
Klo pke kata kecuali, tinggal di modifikasi Query dr agan-agan tadi, mungkin jadinya seperti ini...

Code:
SELECT * FROM nama_tabel WHERE (thn_angkatan < 2006) OR (thn_angkatan > 2010)

Jangan lupa field thn_angkatan harus NUMERIC/Integer soalnya kalo STRING querynya nggak bisa dieksekusi...

mungkin segitu dr saya, mo'on maap klo tdk sesuai keinginan.... hmm
Find all posts by this user
Quote this message in a reply
02-06-2012, 10:46 AM
Post: #13
Killu4 Away
./Devilz Advisor
Posts: 744
Joined: Nov 2011
Reputation: 16
RE: Mysql (T_T)
(02-06-2012 10:29 AM)zulinvation Wrote:  Klo pke kata kecuali, tinggal di modifikasi Query dr agan-agan tadi, mungkin jadinya seperti ini...

Code:
SELECT * FROM nama_tabel WHERE (thn_angkatan < 2006) OR (thn_angkatan > 2010)

Jangan lupa field thn_angkatan harus NUMERIC/Integer soalnya kalo STRING querynya nggak bisa dieksekusi...

mungkin segitu dr saya, mo'on maap klo tdk sesuai keinginan.... hmm

Kyanya udh terjawab sama om ini deh querynya ..
CMIIW ketawa
Find all posts by this user
Quote this message in a reply
02-06-2012, 10:55 AM
Post: #14
zulinvation Offline
./Devilz 1st Cadet
Posts: 6
Joined: Feb 2012
Reputation: 1
RE: Mysql (T_T)
(02-06-2012 10:46 AM)Killu4 Wrote:  Kyanya udh terjawab sama om ini deh querynya ..
CMIIW ketawa

gmn, udah jalan?
Find all posts by this user
Quote this message in a reply
« Next Oldest | Next Newest »
Pages (2): « Previous 1 2
Post Reply 


Topic Tools
Topic Link :
BBCode :
HTML Code :
View a Printable Version Send Thread to a Friend Subscribe to this thread
Submit Google Submit Face book Submit to Digg Submit to Reddit Submit to Furl Submit to Del.icio.us Submit to Jeqq

Possibly Related Threads...
Thread: Author Replies: Views: Last Post
  Buat Database di Mysql petimati 13 6,075 05-11-2013 12:12 PM
Last Post: 201081021-Dennis
  [Tutor] Tipe - Tipe Data yang didukung oleh MySQL RieqyNS13 5 334 05-11-2013 12:00 PM
Last Post: 201081021-Dennis
  [Tutor] Mysql Trigger function view dan stored Porcedure wenkhairu 7 153 05-08-2013 08:57 AM
Last Post: uzumady
  [Ask] Service mysql bikin Server Lemot mrcuex 11 208 03-07-2013 10:51 AM
Last Post: mrcuex
  Jenis - Jenis Problem Mysql anakbego 5 315 02-28-2013 10:47 PM
Last Post: mrcuex
  Pengin Belajar MySql ( mulai dari mana) G3lombang 15 3,634 09-25-2012 11:02 PM
Last Post: Clound_Ajah
  tutorial mysql qball006_error 13 2,685 06-30-2012 09:40 PM
Last Post: the_critical
  [Solved] perintah mysql tidak bisa jalan jinjun 3 367 06-22-2012 11:18 AM
Last Post: dzawa
  [Ask] ebook tutorial MYSQL Xamp lorenza 3 757 02-25-2012 12:21 AM
Last Post: Hartono susanto
  Tambah User MySQL petimati 7 3,735 02-03-2012 09:56 PM
Last Post: mas_an

Users Browsing
1 Guest(s)

  • Contact Us
  • devilzc0de
  • Return to Top
  • Mobile Version
  • RSS Syndication
  • Help
Current time: 05-21-2013, 04:38 PM Powered By MyBB, © 2002-2013 MyBB Group. Theme created by Justin S. | Mixed By Chaer.Newbie | Fixed By Aditya

USING THIS SITE INDICATES THAT YOU HAVE READ AND ACCEPT OUR TERMS. IF YOU DO NOT ACCEPT THESE TERMS, YOU ARE NOT AUTHORIZED TO USE THIS SITE