Tietovarasto

Search
Skip to content
  • Tietovarasto opinto

Monthly Archives: January 2022

SHOW databases

January 31, 2022 mesala Leave a comment

SHOW DATABASES lists the databases on the MariaDB server host.
The syntax of the MySQL:
SHOW DATABASES;

show tables

January 31, 2022 mesala Leave a comment

List Tables In a MySQL Database.
The syntax of the MySQL
SHOW TABLES;

Tietokanta opiskelua

  • Linux komennot
    • Alias
    • Cat
    • CD
    • DF
    • CP
    • ID
    • ifconfig
    • last
    • lastlog
    • ls
    • Mkdir
    • MV
    • passwd
    • ping
    • pwd
    • rm
    • rmdir
    • shutdown
    • Tar Paketti
    • Useradd
    • userdel
    • uptime
  • Apache2
    • Apachen asennus
    • Apache konfiguraatio
    • Apache2 dir.conf
    • Htaccess tiedoston tekeminen
    • htpasswd tiedoston tekeminen
  • Proftpd
    • Proftpd-basic asennus
    • Proftpd-basic konfiguraatio
  • PHP
  • Mariadb-server
    • Mysql- Tietokannan tekeminen
    • Käyttäjätunnuksen tekeminen tietokantaan
    • Salasanan asettaminen Käyttäjätunnukseen
    • Käyttäjätunnuksen liittäminen tietokantaan
    • db listaus
    • MySql dump
    • MySQL tietokannan poistaminen
  • SSH
    • SSH asennus
    • SSH konfiguraatio
    • SSH Config
  • Putty
  • PHPBB3
  • WordPress
  • PHP-OPERATORS
    • Operators
    • Comparison operators
    • Logical operators
  • MYSQL-Database
    • MySQL Commands
      • MYSQL terms
      • Creating a database
      • Creating users to database
      • Creating a table
      • The AUTO_INCREMENT attribute
      • DESCRIBE table info
      • Adding data to a table
      • Renaming a table
      • Changing the data type of a column
      • Renaming a column
      • Removing a column
      • Deleting a table
      • show tables
      • SHOW databases
    • Data Types
      • BINARY data type
      • The TEXT data types
      • The BLOB data types
      • DATE and TIME types
    • Indexes
      • Creating an Index
      • Using CREATE INDEX
      • Adding indexes when creating tables
      • Primary keys
    • Creating a FULLTEXT index
      • Querying a MySQL Database
      • SELECT COUNT
      • SELECT DISTINCT
      • DELETE
      • WHERE
      • LIMIT
      • MATCH…AGAINST
      • MATCH…AGAINST in Boolean mode
      • GROUP BY
      • ORDER BY
      • UPDATE…SET
    • Combine tables
      • Making new table for combining
      • NATURAL JOIN
      • JOIN…ON
      • Using AS
      • Using Logical Operators
    • Backing Up and Restoring
      • Basics of Using mysqldump
      • Creating a SQL Backup File
      • Backing up a single table
      • Backing up all tables
      • Restoring from a Backup File
      • Dumping Data in CSV Format
      • Planning Your Backups
  • PHP-MYSQL
    • Querying a MySQL Database with PHP
    • Creating a Login File
    • Connecting to a MySQL Database
    • Building and executing a query
    • Fetching a result
    • Fetching a row
    • inserting data in and deleting it
      • The $_POST Array
      • Deleting a Record
      • Querying the Database
    • practical techniques for MySql
      • Creating a Table
      • Describing a Table
      • Dropping a Table
      • Adding Data information
      • Retrieving Data
      • Updating Data
      • Deleting Data
      • AUTO_INCREMENT
      • Using insert ID
  • Projektityö
  • Videot
  • Harjoitus tehtävä
  • Sanastoa

Recent Posts

  • Sanastoa
  • Harjoitus tehtävä
  • Videot
  • Projektityö
  • PHP-OPERATORS

Recent Comments

No comments to show.

Archives

  • September 2024
  • April 2024
  • November 2023
  • December 2022
  • March 2022
  • January 2022
  • December 2021
  • November 2021
  • October 2021
  • September 2021

Categories

  • Uncategorized
Proudly powered by WordPress