View source for Comparison of database access

{{short description|None}}
<!-- Please do not remove or change this AfD message until the discussion has been closed. -->
{{Article for deletion/dated|page=Comparison of database access|timestamp=20221106153718|year=2022|month=November|day=6|substed=yes}}
<!-- Once discussion is closed, please place on talk page: {{Old AfD multi|page=Comparison of database access|date=6 November 2022|result='''keep'''}} -->
<!-- End of AfD message, feel free to edit beyond this point --> 
{{Multiple issues|
{{Orphan|date=September 2016}}
{{Confusing|date=February 2008}}
}}

{{ProgLangCompare}}

== Database input commands ==

=== Database and table management ===
{| class="wikitable"
!Database
!Create database
!Delete database
!List databases
!Use a db
!Create table
!Delete table
!List tables
!List table fields
|-
| [[MySQL]]
| {{mono|create database ''dbname'';}}
| {{mono|drop database ''dbname'';}}
| {{mono|show databases;}}
| {{mono|use ''dbname'';}}
| {{mono|create table ''tbname'';}}
| {{mono|drop table ''tbname'';}}
| {{mono|show tables;}}
| {{mono|describe ''tbname'';}}
|-
| [[PostgreSQL]]
| {{mono|create database ''dbname'';}}
| {{mono|drop database ''dbname'';}}
| {{mono|\l <small>(in psql)</small>}}
| {{mono|1=\c ''dbname'' (in psql)<br><small>For schemas (a similar feature):</small><br> set search_path = ''schema_name'';}}
| {{mono|create table ''tbname'' (''field1'' ''value_type1'', ''field2'' ''value_type2'', ... );}}
| {{mono|drop table ''tbname'';}}
| {{mono|\d <small>(in psql)</small>}}
| {{mono|\d ''tbname'' <small>(in psql)</small>}}
|-
| [[Sqlite]] ver 3
| {{mono|? }}
| {{mono|? }}
| {{mono|? }}
| {{mono|$ sqlite3 ''filename''}}
| {{mono|create table ''tbname'' (''field1'' ''value_type1'', ''field2'' ''value_type2'', ... )}}
| {{mono|drop table ''tbname''}}
| {{mono|.tables}}
| {{mono|.schema}}
|-
|}

== MySQL databases ==
{| class="wikitable"
![[Programming Language|Prog Language]]
!Access server
!Use database
!List databases
!List tables
|-
|raw MySQL access
|
|<syntaxhighlight lang=mysql inline>use db;</syntaxhighlight>
|<syntaxhighlight lang=mysql inline>show databases;</syntaxhighlight>
|<syntaxhighlight lang=mysql inline>show tables;</syntaxhighlight>
|-
|[[PHP]]
|{{code|lang=php|1=$link = mysql_connect(host, user, password);}}
or

{{code|lang=php|1=$db = new mysqli(host, user, password);}}

or

{{code|lang=php|1=$db = new PDO('mysql:host=hostname;dbname=dbname', 'username', 'password');}}
|{{code|lang=php|1=mysql_select_db(''name'', $link);}}
or

{{code|lang=php|1=$db = new mysqli(host, user, password, ''name'');}}

or

{{code|lang=php|1=$db->select_db(''name'');}}
|
|
|-
|[[Python (programming language)|Python]]
|{{sxhl|lang=python|1=db = MySQLdb.connect(
      host="hostname", 
      user="username", 
      passwd="password", 
      db="dbname", 
      connect_timeout=5)}}
|{{code|lang=python|import MySQLdb}}
|{{sxhl|lang=python|1=c = db.cursor()
c.execute("show databases")
c.fetchall()}}
|{{sxhl|lang=python|1=c = db.cursor()
c.execute("show tables")
c.fetchall()}}
|}

== See also ==
*[[ODBC]]
*[[JDBC]]
*MySQL
*PostgreSQL

{{DEFAULTSORT:Database access comparison}}
[[Category:Database APIs| ]]
[[Category:Free database management systems]]
[[Category:Database software comparisons]]
[[Category:SQL data access]]
{{⚠️🚨COPIED from EverybodyWiki ❗❕⚠️😡😤Please respect Licence CC-BY-SA ❗}}
{{Source Wikipedia}}