Archive for April 24, 2008

sql Asisten

localhost: sistem_penjadwalan_praktikum.asisten (5 Records)

NIM Nama Asisten_Mata_Kuliah
  Purwoko  Essay_Writing 
0301060060  Moh_Fahrurrozi  Algoritma_Matlab 
0402030015  Syaeful_Anwar  Sistem_Basis_Data 
0402030016  Didi_Suprayogi  Sistem_Basis_Data 
0402030025  Iif_Miftahudin  Sistem_Basis_Data 

generated 4/24/2008 10:43:33 AM by MySQL-Front 2.2

Leave a comment »

sql Jadwal Praktikum

# Server: 4.1.11
# Client: 3.23.39
# Protocol-Version: 10
# Uptime: 2053
# Threads: 2
# Questions: 140
# Slow queries: 0
# Opens: 37
# Flush tables: 1
# Open tables: 20
# Queries per second avg: 0.068
SELECT VERSION()
SHOW VARIABLES
SHOW STATUS
SHOW PROCESSLIST
SHOW DATABASES
SHOW TABLES FROM `akademik`
SHOW TABLES FROM `mysql`
SHOW TABLES FROM `sistem_penjadwalan_praktikum`
SHOW TABLES FROM `test`
SHOW TABLE STATUS
SHOW FIELDS FROM `asisten`
SHOW KEYS FROM `asisten`
SELECT COUNT(*) FROM `asisten`
SELECT * FROM asisten LIMIT 0, 50
SHOW FIELDS FROM `asisten`
SHOW KEYS FROM `asisten`
SHOW KEYS FROM `asisten`
SELECT COUNT(*) FROM `asisten`
SELECT * FROM asisten LIMIT 0, 50
SHOW FIELDS FROM `asisten`
SHOW KEYS FROM `asisten`
SHOW KEYS FROM `asisten`
SHOW KEYS FROM `asisten`
SELECT COUNT(*) FROM `asisten`
SELECT * FROM asisten LIMIT 0, 50
SHOW FIELDS FROM `asisten`
SHOW KEYS FROM `asisten`
SHOW KEYS FROM `asisten`
SELECT COUNT(*) FROM `asisten`
SELECT * FROM asisten LIMIT 0, 50
SHOW FIELDS FROM `asisten`
SHOW KEYS FROM `asisten`
SELECT COUNT(*) FROM `asisten`
SELECT * FROM asisten LIMIT 0, 50

Leave a comment »