Database: Difference between revisions

From nuBuilderForte
Jump to navigation Jump to search
No edit summary
Tag: Reverted
mNo edit summary
Tag: Manual revert
 
(5 intermediate revisions by 2 users not shown)
Line 15: Line 15:
*users
*users
*permissions
*permissions
=== zzzzsys_table ===
* In nubuilder v4, there is a system table called <tt>zzzzsys_table</tt> that gets populated with all table and view names.
* In v4.5 a new view was introduced (<tt>zzzzsys_object_list</tt>) to get this data from the information_schema db directly.
* In v4, the <tt>nuapi.php</tt> kept on purging and [[Media:nuapi_re-creates_tables.png|re-creating]] the said table.

Latest revision as of 11:06, 21 May 2024

phpMyAdmin will give nuBuilder developers direct access to the database.

It is a free software tool written in PHP, intended to handle the administration of MySQL over the Web.

phpMyAdmin supports a wide range of operations on MySQL and MariaDB.

Frequently used operations can be performed via the user interface, while you still have the ability to directly execute any SQL statement.

Those operations are..

  • managing databases
  • tables
  • columns
  • relations
  • indexes
  • users
  • permissions