BCS Browse MySQL Tables


There are those time when it is necessary to manage a MySQL database management system.
bt01
Create a database and import the alias table associated with this application.  When the application sees an empty table it dynamically populates the table with every table in the MySQL database.  You added or deleted tables from the database?  No problem.  Truncate the table in its entirety and start the application.  Those modifications are instantly reflected.

When the user positions the database via the popup a dialog appears that contains unique alias for the entire database.

bt02
Double click on the alias you would like begin with and the application positions the database to the first entry for that alias.

When the Browse Table option is invoked via the pop up menu the following dialog appears.
bt03
This process should be completed until all desired data tables have been viewed.  This application is just a initial example of how to manage MySQL relational database management system.

-- phpMyAdmin SQL Dump
-- version 4.3.7
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Sep 23, 2015 at 05:50 PM
-- Server version: 5.6.17
-- PHP Version: 5.5.12
 
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
 
 
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
 
--
-- Database: `mydb`
--
 
-- --------------------------------------------------------
 
--
-- Table structure for table `ail`
--
 
CREATE TABLE IF NOT EXISTS `ail` (
  `id` int(11) NOT NULL,
  `ail` varchar(125) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=345 DEFAULT CHARSET=latin1;
 
--
-- Indexes for dumped tables
--
 
--
-- Indexes for table `ail`
--
ALTER TABLE `ail`
  ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `ail` (`ail`);
 
--
-- AUTO_INCREMENT for dumped tables
--
 
--
-- AUTO_INCREMENT for table `ail`
--
ALTER TABLE `ail`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=345;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

A 32 bit executable program may be downloaded by clicking here.
A 64 bit executable program may be downloaded by clicking here.
The component documentation can be found by clicking here.
The source code may be found by clicking here.

Mr. Arch Brooks, Software Engineer, Brooks Computing Systems, LLC authored this article.

Leave a Reply