The fields of the table editor change depending on the table type. Some fields are common to all types.
The table name is just for your reference. It is not displayed with the table generated.
Plotalot, Responsive, or Google.
Whether to include a row number column as the first column of the table.
To use a database other than the current Joomla site you must first create it using the "Databases" menu. You will then be able to select it here.
You may want to limit the number of rows shown on your web page. If you want the first 10 rows you can use the SQL LIMIT function that we introduced in the SQL section. But what if you need to show a representative sample of a large dataset? You can't easily do that in SQL, but that's exactly what Max Rows does. You specify how many rows you want, and Plotalot samples the data set to display the number of rows you asked for. Leave Max Rows blank to show all rows.
See Table Totals below.
The query can be any valid select query. The table will include the relevant number of rows and columns.