User Information from MySQL

Picture of Mertech Mertech : Feb 25, 2008 3:50:00 PM

Databases

This example returns user information from MySQL:

// Begin of Example

Use Mertech.inc

String sID sUser sHost sDB sCommand sTime sState sInfo

Login "localhost" "root" "mertech" "MDSMYSQL"

SQL_SET_STMT TO "show processlist" SQL_PREPARE_STMT SQL_EXECUTE_STMT

Repeat

  SQL_FETCH_NEXT_ROW into sID sUser sHost sDB sCommand sTime sState sInfo

  [ Found ] Begin

     Showln "ID     : "sID

     Showln "User   : "sUser

     Showln "Host   : "sHost

     Showln "DB     : "sDB

     Showln "Command: "sCommand

     Showln "Time   : "sTime

     Showln "State  : "sState

     Showln "Info   : "sInfo

     Showln

     Showln "Presse any key ..."

     Showln

     Inkey Pageend

  End

Until [ Not Found ]

Showln Showln "Ok ...." Inkey Pageend

// End of Example

 

 
Data Security with Flex2SQL and BTR2SQL Connectivity Products

Data Security with Flex2SQL and BTR2SQL Connectivity Products

Mertech Support: Oct 1, 2025 12:45:52 PM

The most common reason for Enterprises looking to migrate from legacy Btrieve or DataFlex databases is the urgent need to address security and...

Btrieve BTR2SQL Flex2SQL MS SQL Server Oracle MySQL MariaDB
Read More
Why Migrate from Btrieve to PostgreSQL and other Relational Databases?

Why Migrate from Btrieve to PostgreSQL and other Relational Databases?

Picture of Riaz Merchant Riaz Merchant: Oct 28, 2024 6:12:41 AM

Introduction Many independent software vendors (ISV) and corporate users still rely on applications that use a category of database collective called...

Btrieve BTR2SQL PostgreSQL Modernization ISAM
Read More
Four Challenges in Converting COBOL Applications from ISAM Databases to Relational Databases

Four Challenges in Converting COBOL Applications from ISAM Databases to Relational Databases

Picture of Riaz Merchant Riaz Merchant: Oct 18, 2024 9:21:56 AM

COBOL applications are the foundation of numerous essential business functions, especially within the banking, insurance, and government sectors....

Btrieve MS SQL Server Oracle PostgreSQL COBOL
Read More