xxxxxxxxxx
Layout:
| Tables | Are | Cool |
|----------|:-------------:|------:|
| col 1 is | left-aligned | $1600 |
| col 2 is | centered | $12 |
| col 3 is | right-aligned | $1 |
An amazing website for building a table in markdown:
https://www.tablesgenerator.com/markdown_tables
xxxxxxxxxx
Colons can be used to align columns.
| Tables | Are | Cool |
| ------------- |:-------------:| -----:|
| col 3 is | right-aligned | $1600 |
| col 2 is | centered | $12 |
| zebra stripes | are neat | $1 |
Markdown | Less | Pretty
--- | --- | ---
*Still* | `renders` | **nicely**
1 | 2 | 3
xxxxxxxxxx
| Syntax | Description |
| ----------- | ----------- |
| Header | Title |
| Paragraph | Text |
xxxxxxxxxx
| Syntax | Description | Test Text |
| :--- | :----: | ---: |
| Header | Title | Here's this |
| Paragraph | Text | And more |
xxxxxxxxxx
<table>
<thead>
<tr>
<th>Header1</th>
<th>Header2</th>
<th>Header3</th>
</tr>
</thead>
<tbody>
<tr>
<td>data1</td>
<td>data2</td>
<td>data3</td>
</tr>
<tr>
<td>data11</td>
<td>data12</td>
<td>data13</td>
</tr>
</tbody>
</table>
xxxxxxxxxx
To convert a WYSIWYG (Word, Docs) to Markdown:
1. Copy your table in your clipboard.
2. Use this link to convert your table to HTML:
https://www.tablesgenerator.com/html_tables
3. Then use this one to convert the HTML result into Markdown:
https://www.tablesgenerator.com/markdown_tables#
xxxxxxxxxx
Function | MySQL / MariaDB | PostgreSQL | SQLite
:------------ | :-------------| :-------------| :-------------
substr | :heavy_check_mark: | :white_check_mark: | :heavy_check_mark: