{"id":18,"date":"2019-05-20T16:54:13","date_gmt":"2019-05-20T16:54:13","guid":{"rendered":"https:\/\/howto.ciscoar.com\/?page_id=18"},"modified":"2025-02-15T16:11:50","modified_gmt":"2025-02-15T16:11:50","slug":"mariadb-create-table","status":"publish","type":"page","link":"https:\/\/lamp.ciscoar.com\/?page_id=18","title":{"rendered":"MariaDB CREATE TABLE"},"content":{"rendered":"\n\n\n

MariaDB database login<\/h2>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
mysql<\/span> <\/span>-<\/span>u<\/span> <\/span>root<\/span> <\/span>-<\/span>p<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
<\/div>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
[<\/span>juan<\/span>@<\/span>pc<\/span> <\/span>~<\/span>]<\/span>$<\/span> <\/span>mysql<\/span> <\/span>-<\/span>u<\/span> <\/span>root<\/span> <\/span>-<\/span>p<\/span><\/span>\nEnter<\/span> password<\/span>:<\/span> <\/span><\/span>\nWelcome<\/span> <\/span>to<\/span> <\/span>the<\/span> <\/span>MariaDB<\/span> <\/span>monitor<\/span>.<\/span>  <\/span>Commands<\/span> <\/span>end<\/span> <\/span>with<\/span> <\/span>;<\/span> <\/span>or<\/span> \\<\/span>g<\/span>.<\/span><\/span>\nYour<\/span> <\/span>MariaDB<\/span> <\/span>connection<\/span> <\/span>id<\/span> <\/span>is<\/span> <\/span>2<\/span><\/span>\nServer<\/span> version<\/span>:<\/span> <\/span>5.5<\/span>.<\/span>60<\/span>-<\/span>MariaDB<\/span> <\/span>MariaDB<\/span> <\/span>Server<\/span><\/span>\n<\/span>\nCopyright<\/span> (<\/span>c<\/span>) <\/span>2000<\/span>,<\/span> <\/span>2018<\/span>,<\/span> <\/span>Oracle<\/span>,<\/span> <\/span>MariaDB<\/span> <\/span>Corporation<\/span> <\/span>Ab<\/span> <\/span>and<\/span> <\/span>others<\/span>.<\/span><\/span>\n<\/span>\nType<\/span> <\/span>'<\/span>help;<\/span>'<\/span> <\/span>or<\/span> <\/span>'<\/span>\\h<\/span>'<\/span> <\/span>for<\/span> <\/span>help<\/span>.<\/span> <\/span>Type<\/span> <\/span>'<\/span>\\c<\/span>'<\/span> <\/span>to<\/span> <\/span>clear<\/span> <\/span>the<\/span> <\/span>current<\/span> <\/span>input<\/span> <\/span>statement<\/span>.<\/span><\/span>\n<\/span>\nMariaDB<\/span> [(<\/span>none<\/span>)]<\/span>><\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
SHOW DATABASES<\/h2>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
SHOW<\/span> <\/span>TABLES<\/span>;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
<\/div>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
MariaDB<\/span> [(<\/span>none<\/span>)]<\/span>><\/span> <\/span>SHOW<\/span> <\/span>DATABASES<\/span>;<\/span><\/span>\n+--------------------+<\/span><\/span>\n|<\/span> <\/span>Database<\/span>           <\/span>|<\/span><\/span>\n+--------------------+<\/span><\/span>\n|<\/span> <\/span>information_schema<\/span> <\/span>|<\/span><\/span>\n|<\/span> <\/span>dbtest<\/span>             <\/span>|<\/span><\/span>\n|<\/span> <\/span>mysql<\/span>              <\/span>|<\/span><\/span>\n|<\/span> <\/span>performance_schema<\/span> <\/span>|<\/span><\/span>\n+--------------------+<\/span><\/span>\n4<\/span> <\/span>rows<\/span> <\/span>in<\/span> <\/span>set<\/span> (<\/span>0.01<\/span> <\/span>sec<\/span>)<\/span><\/span>\n<\/span>\nMariaDB<\/span> [(<\/span>none<\/span>)]<\/span>><\/span> <\/span><\/span>\n<\/span><\/code><\/pre><\/div>\n\n\n\n
USE<\/h2>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
USE<\/span> <\/span>dbtest<\/span>;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
<\/div>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
MariaDB<\/span> [(<\/span>none<\/span>)]<\/span>><\/span> <\/span>USE<\/span> <\/span>dbtest<\/span>;<\/span><\/span>\nReading<\/span> <\/span>table<\/span> <\/span>information<\/span> <\/span>for<\/span> <\/span>completion<\/span> <\/span>of<\/span> <\/span>table<\/span> <\/span>and<\/span> <\/span>column<\/span> <\/span>names<\/span><\/span>\nYou<\/span> <\/span>can<\/span> <\/span>turn<\/span> <\/span>off<\/span> <\/span>this<\/span> <\/span>feature<\/span> <\/span>to<\/span> <\/span>get<\/span> <\/span>a<\/span> <\/span>quicker<\/span> <\/span>startup<\/span> <\/span>with<\/span> <\/span>-<\/span>A<\/span><\/span>\n<\/span>\nDatabase<\/span> <\/span>changed<\/span><\/span>\nMariaDB<\/span> [<\/span>dbtest<\/span>]<\/span>><\/span> <\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
QUIT<\/h2>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
\\<\/span>q<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
<\/div>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
MariaDB<\/span> [<\/span>dbtest<\/span>]<\/span>><\/span> <\/span>QUIT<\/span><\/span>\nBye<\/span><\/span>\n[<\/span>juan<\/span>@<\/span>pc<\/span> <\/span>~<\/span>]<\/span>$<\/span> <\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
CREATE TABLE<\/h2>\n\n\n\n
Create a table separating columns manually<\/h3>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
MariaDB<\/span> [<\/span>dbtest<\/span>]<\/span>><\/span> <\/span>CREATE<\/span> <\/span>TABLE<\/span> <\/span>tabletest<\/span> (<\/span><\/span>\n    <\/span>-><\/span> <\/span>user_id<\/span> <\/span>int<\/span>,<\/span><\/span>\n    <\/span>-><\/span> <\/span>first_name<\/span> <\/span>varchar<\/span>(<\/span>20<\/span>)<\/span>,<\/span><\/span>\n    <\/span>-><\/span> <\/span>last_name<\/span> <\/span>varchar<\/span>(<\/span>30<\/span>)<\/span>,<\/span><\/span>\n    <\/span>-><\/span> <\/span>email<\/span> <\/span>varchar<\/span>(<\/span>50<\/span>)<\/span>,<\/span><\/span>\n    <\/span>-><\/span> <\/span>facebook_url<\/span> <\/span>varchar<\/span>(<\/span>90<\/span>)<\/span>,<\/span><\/span>\n    <\/span>-><\/span> <\/span>twitter_handle<\/span> <\/span>varchar<\/span>(<\/span>20<\/span>)<\/span><\/span>\n    <\/span>-><\/span> )<\/span>;<\/span><\/span>\nQuery<\/span> <\/span>OK<\/span>,<\/span> <\/span>0<\/span> <\/span>rows<\/span> <\/span>affected<\/span> (<\/span>0.01<\/span> <\/span>sec<\/span>)<\/span><\/span>\n<\/span>\nMariaDB<\/span> [<\/span>dbtest<\/span>]<\/span>><\/span> <\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
Create a table using one long command<\/h3>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
MariaDB<\/span> [<\/span>dbtest<\/span>]<\/span>><\/span> <\/span>CREATE<\/span> <\/span>TABLE<\/span> <\/span>tabletest<\/span> ( <\/span>user_id<\/span> <\/span>int<\/span>,<\/span> <\/span>first_name<\/span> <\/span>varchar<\/span>(<\/span>20<\/span>)<\/span>,<\/span> <\/span>last_name<\/span> <\/span>varchar<\/span>(<\/span>30<\/span>)<\/span>,<\/span> <\/span>email<\/span> <\/span>varchar<\/span>(<\/span>50<\/span>)<\/span>,<\/span> <\/span>facebook_url<\/span> <\/span>varchar<\/span>(<\/span>100<\/span>)<\/span>,<\/span> <\/span>twitter_handle<\/span> <\/span>varchar<\/span>(<\/span>20<\/span>) )<\/span>;<\/span> <\/span><\/span>\nQuery<\/span> <\/span>OK<\/span>,<\/span> <\/span>0<\/span> <\/span>rows<\/span> <\/span>affected<\/span> (<\/span>0.02<\/span> <\/span>sec<\/span>)<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
<\/div>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
CREATE<\/span> <\/span>TABLE<\/span> <\/span>tabletest<\/span> ( <\/span>user_id<\/span> <\/span>int<\/span>,<\/span> <\/span>first_name<\/span> <\/span>varchar<\/span>(<\/span>20<\/span>)<\/span>,<\/span> <\/span>last_name<\/span> <\/span>varchar<\/span>(<\/span>30<\/span>)<\/span>,<\/span> <\/span>email<\/span> <\/span>varchar<\/span>(<\/span>50<\/span>)<\/span>,<\/span> <\/span>facebook_url<\/span> <\/span>varchar<\/span>(<\/span>100<\/span>)<\/span>,<\/span> <\/span>twitter_handle<\/span> <\/span>varchar<\/span>(<\/span>20<\/span>) )<\/span>;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
SHOW TABLES<\/h2>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
SHOW<\/span> <\/span>TABLES<\/span>;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
<\/div>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
MariaDB<\/span> [<\/span>dbtest<\/span>]<\/span>><\/span> <\/span>SHOW<\/span> <\/span>TABLES<\/span>;<\/span><\/span>\n+------------------+<\/span><\/span>\n|<\/span> <\/span>Tables_in_dbtest<\/span> <\/span>|<\/span><\/span>\n+------------------+<\/span><\/span>\n|<\/span> <\/span>tabletest<\/span>        <\/span>|<\/span><\/span>\n+------------------+<\/span><\/span>\n1<\/span> <\/span>row<\/span> <\/span>in<\/span> <\/span>set<\/span> (<\/span>0.00<\/span> <\/span>sec<\/span>)<\/span><\/span>\n<\/span>\nMariaDB<\/span> [<\/span>dbtest<\/span>]<\/span>><\/span> <\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
 DESCRIBE TABLE <\/h2>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
DESCRIBE<\/span> <\/span>tabletest<\/span>;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
<\/div>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
]<\/span>><\/span> <\/span>DESCRIBE<\/span> <\/span>tabletest<\/span>;<\/span><\/span>\n+----------------+--------------+------+-----+---------+-------+<\/span><\/span>\n|<\/span> <\/span>Field<\/span>          <\/span>|<\/span> <\/span>Type<\/span>         <\/span>|<\/span> <\/span>Null<\/span> <\/span>|<\/span> <\/span>Key<\/span> <\/span>|<\/span> <\/span>Default<\/span> <\/span>|<\/span> <\/span>Extra<\/span> <\/span>|<\/span><\/span>\n+----------------+--------------+------+-----+---------+-------+<\/span><\/span>\n|<\/span> <\/span>user_id<\/span>        <\/span>|<\/span> <\/span>int<\/span>(<\/span>11<\/span>)      <\/span>|<\/span> <\/span>YES<\/span>  <\/span>|<\/span>     <\/span>|<\/span> <\/span>NULL<\/span>    <\/span>|<\/span>       <\/span>|<\/span><\/span>\n|<\/span> <\/span>first_name<\/span>     <\/span>|<\/span> <\/span>varchar<\/span>(<\/span>20<\/span>)  <\/span>|<\/span> <\/span>YES<\/span>  <\/span>|<\/span>     <\/span>|<\/span> <\/span>NULL<\/span>    <\/span>|<\/span>       <\/span>|<\/span><\/span>\n|<\/span> <\/span>last_name<\/span>      <\/span>|<\/span> <\/span>varchar<\/span>(<\/span>30<\/span>)  <\/span>|<\/span> <\/span>YES<\/span>  <\/span>|<\/span>     <\/span>|<\/span> <\/span>NULL<\/span>    <\/span>|<\/span>       <\/span>|<\/span><\/span>\n|<\/span> <\/span>email<\/span>          <\/span>|<\/span> <\/span>varchar<\/span>(<\/span>50<\/span>)  <\/span>|<\/span> <\/span>YES<\/span>  <\/span>|<\/span>     <\/span>|<\/span> <\/span>NULL<\/span>    <\/span>|<\/span>       <\/span>|<\/span><\/span>\n|<\/span> <\/span>facebook_url<\/span>   <\/span>|<\/span> <\/span>varchar<\/span>(<\/span>100<\/span>) <\/span>|<\/span> <\/span>YES<\/span>  <\/span>|<\/span>     <\/span>|<\/span> <\/span>NULL<\/span>    <\/span>|<\/span>       <\/span>|<\/span><\/span>\n|<\/span> <\/span>twitter_handle<\/span> <\/span>|<\/span> <\/span>varchar<\/span>(<\/span>20<\/span>)  <\/span>|<\/span> <\/span>YES<\/span>  <\/span>|<\/span>     <\/span>|<\/span> <\/span>NULL<\/span>    <\/span>|<\/span>       <\/span>|<\/span><\/span>\n+----------------+--------------+------+-----+---------+-------+<\/span><\/span>\n6<\/span> <\/span>rows<\/span> <\/span>in<\/span> <\/span>set<\/span> (<\/span>0.00<\/span> <\/span>sec<\/span>)<\/span><\/span>\n<\/span>\nMariaDB<\/span> [<\/span>dbtest<\/span>]<\/span>><\/span> <\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
INSERT INTO<\/h2>\n\n\n\n
Insert data separating columns manually<\/h3>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
MariaDB<\/span> [<\/span>dbtest<\/span>]<\/span>><\/span> <\/span>INSERT<\/span> <\/span>INTO<\/span> <\/span>tabletest<\/span> <\/span>VALUES<\/span> (<\/span>1<\/span>,<\/span><\/span>\n    <\/span>-><\/span> <\/span>"<\/span>Pepe<\/span>"<\/span>,<\/span><\/span>\n    <\/span>-><\/span> <\/span>"<\/span>Argento<\/span>"<\/span>,<\/span><\/span>\n    <\/span>-><\/span> <\/span>"<\/span>pepe@argento.com<\/span>"<\/span>,<\/span><\/span>\n    <\/span>-><\/span> <\/span>"<\/span>fb.com\/pepearg<\/span>"<\/span>,<\/span><\/span>\n    <\/span>-><\/span> <\/span>"<\/span>@pepearg<\/span>"<\/span>)<\/span>;<\/span><\/span>\nQuery<\/span> <\/span>OK<\/span>,<\/span> <\/span>1<\/span> <\/span>row<\/span> <\/span>affected<\/span> (<\/span>0.00<\/span> <\/span>sec<\/span>)<\/span><\/span>\n<\/span>\nMariaDB<\/span> [<\/span>dbtest<\/span>]<\/span>><\/span> <\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
<\/div>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
INSERT<\/span> <\/span>INTO<\/span> <\/span>tabletest<\/span> <\/span>VALUES<\/span> (<\/span>1<\/span>,<\/span>"<\/span>Pepe<\/span>"<\/span>,<\/span>"<\/span>Argento<\/span>"<\/span>,<\/span>"<\/span>pepe@argento.com<\/span>"<\/span>,<\/span>"<\/span>fb.com\/pepearg<\/span>"<\/span>,<\/span>"<\/span>@pepearg<\/span>"<\/span>)<\/span>;<\/span><\/span>\n<\/span><\/code><\/pre><\/div>\n\n\n\n
<\/div>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
INSERT<\/span> <\/span>INTO<\/span> <\/span>tabletest<\/span> <\/span>VALUES<\/span> (<\/span>2<\/span>,<\/span>"<\/span>John<\/span>"<\/span>,<\/span>"<\/span>Doe<\/span>"<\/span>,<\/span>"<\/span>john@example.com<\/span>"<\/span>,<\/span>"<\/span>fb.com\/john<\/span>"<\/span>,<\/span>"<\/span>@johndoe<\/span>"<\/span>)<\/span>;<\/span><\/span>\n<\/span><\/code><\/pre><\/div>\n\n\n\n
<\/div>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
INSERT<\/span> <\/span>INTO<\/span> <\/span>tabletest<\/span> <\/span>VALUES<\/span> (<\/span>3<\/span>,<\/span>"<\/span>Alice<\/span>"<\/span>,<\/span>"<\/span>Smith<\/span>"<\/span>,<\/span>"<\/span>alice@example.com<\/span>"<\/span>,<\/span>"<\/span>fb.com\/alice<\/span>"<\/span>,<\/span>"<\/span>@alice_s<\/span>"<\/span>)<\/span>;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
 Insert data using one long command<\/h3>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
MariaDB<\/span> [<\/span>dbtest<\/span>]<\/span>><\/span> <\/span>INSERT<\/span> <\/span>INTO<\/span> <\/span>tabletest<\/span> <\/span>VALUES<\/span> (<\/span>1<\/span>,<\/span>"<\/span>Pepe<\/span>"<\/span>,<\/span>"<\/span>Argento<\/span>"<\/span>,<\/span>"<\/span>pepe@argento.com<\/span>"<\/span>,<\/span>"<\/span>facebook.com\/pepearg<\/span>"<\/span>,<\/span>"<\/span>@pepearg<\/span>"<\/span>)<\/span>;<\/span><\/span>\nQuery<\/span> <\/span>OK<\/span>,<\/span> <\/span>1<\/span> <\/span>row<\/span> <\/span>affected<\/span> (<\/span>0.01<\/span> <\/span>sec<\/span>)<\/span><\/span>\n<\/span>\nMariaDB<\/span> [<\/span>dbtest<\/span>]<\/span>><\/span> <\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
SELECT<\/h2>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
SELECT<\/span> <\/span>first_name<\/span>,<\/span> <\/span>last_name<\/span>,<\/span> <\/span>email<\/span> <\/span>FROM<\/span> <\/span>tabletest<\/span>;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
<\/div>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
MariaDB<\/span> [<\/span>dbtest<\/span>]<\/span>><\/span> <\/span>SELECT<\/span> <\/span>first_name<\/span>,<\/span> <\/span>last_name<\/span>,<\/span> <\/span>email<\/span> <\/span>FROM<\/span> <\/span>tabletest<\/span>;<\/span><\/span>\n+------------+-----------+------------------+<\/span><\/span>\n|<\/span> <\/span>first_name<\/span> <\/span>|<\/span> <\/span>last_name<\/span> <\/span>|<\/span> <\/span>email<\/span>            <\/span>|<\/span><\/span>\n+------------+-----------+------------------+<\/span><\/span>\n|<\/span> <\/span>Pepe<\/span>       <\/span>|<\/span> <\/span>Argento<\/span>   <\/span>|<\/span> <\/span>pepe<\/span>@<\/span>argento<\/span>.<\/span>com<\/span> <\/span>|<\/span><\/span>\n+------------+-----------+------------------+<\/span><\/span>\n1<\/span> <\/span>row<\/span> <\/span>in<\/span> <\/span>set<\/span> (<\/span>0.00<\/span> <\/span>sec<\/span>)<\/span><\/span>\n<\/span>\nMariaDB<\/span> [<\/span>dbtest<\/span>]<\/span>><\/span> <\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
DROP TABLE<\/h2>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
DROP<\/span> <\/span>TABLE<\/span> <\/span>tabletest<\/span>;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
<\/div>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
MariaDB<\/span> [<\/span>dbtest<\/span>]<\/span>><\/span> <\/span>DROP<\/span> <\/span>TABLE<\/span> <\/span>tabletest<\/span>;<\/span><\/span>\nQuery<\/span> <\/span>OK<\/span>,<\/span> <\/span>0<\/span> <\/span>rows<\/span> <\/span>affected<\/span> (<\/span>0.00<\/span> <\/span>sec<\/span>)<\/span><\/span>\n<\/span>\nMariaDB<\/span> [<\/span>dbtest<\/span>]<\/span>><\/span> <\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
SHOW TABLES (empty)<\/h2>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
MariaDB<\/span> [<\/span>dbtest<\/span>]<\/span>><\/span> <\/span>SHOW<\/span> <\/span>TABLES<\/span>;<\/span><\/span>\nEmpty<\/span> <\/span>set<\/span> (<\/span>0.00<\/span> <\/span>sec<\/span>)<\/span><\/span>\n<\/span>\nMariaDB<\/span> [<\/span>dbtest<\/span>]<\/span>><\/span> <\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
Custom Query example<\/h2>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
SELECT<\/span> <\/span>facebook_url<\/span> <\/span>FROM<\/span> <\/span>tabletest<\/span> <\/span>WHERE<\/span> <\/span>first_name<\/span> <\/span>=<\/span> <\/span>'<\/span>Pepe<\/span>'<\/span>;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
<\/div>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
MariaDB<\/span> [<\/span>dbtest<\/span>]<\/span>><\/span> <\/span>SELECT<\/span> <\/span>facebook_url<\/span><\/span>\n    <\/span>-><\/span> <\/span>FROM<\/span> <\/span>tabletest<\/span><\/span>\n    <\/span>-><\/span> <\/span>WHERE<\/span> <\/span>first_name<\/span> <\/span>=<\/span> <\/span>'<\/span>Pepe<\/span>'<\/span>;<\/span><\/span>\n+----------------------+<\/span><\/span>\n|<\/span> <\/span>facebook_url<\/span>         <\/span>|<\/span><\/span>\n+----------------------+<\/span><\/span>\n|<\/span> <\/span>facebook<\/span>.<\/span>com<\/span>\/<\/span>pepearg<\/span> <\/span>|<\/span><\/span>\n+----------------------+<\/span><\/span>\n1<\/span> <\/span>row<\/span> <\/span>in<\/span> <\/span>set<\/span> (<\/span>0.00<\/span> <\/span>sec<\/span>)<\/span><\/span>\n<\/span>\nMariaDB<\/span> [<\/span>dbtest<\/span>]<\/span>><\/span> <\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
SELECT ALL<\/h2>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
SELECT<\/span> <\/span>*<\/span> <\/span>FROM<\/span> <\/span>tabletest<\/span>;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Where to go next?<\/h2>\n\n\n\n
We’ve just scratched the surface when it comes to working with MySQL, our intention was never to go deep, in fact we’re going to use the GUI (Graphical User Interface) provided by the tool called phpMyAdmin.<\/p>\n\n\n\n