How To Write Php Code To Deal With Mysql Tbl ?

@NogDog,
@Sempervivum,
@DaveyErwin,

If this creates tbl:

““

$sql = “CREATE TABLE IF NOT EXISTS TestE (
page_url VARCHAR(255),
link_anchor_text VARCHAR(255),
page_description VARCHAR(255),
keyphrases VARCHAR(255),
keywords VARCHAR(255))”;
mysqli_query($conn, $sql);
““

Then how to write such text code to amend the tbl ?
Like add a new column ?
Delete a column ?
Rename a column ?
Switch a NULL column to NOT NULL and vice versa ?
How to switch col type ? Like from VARCHAR to TinyText ?
How to add a column for img ?
How to add a column for videos ?

Show us an example.

Thanks

Also in #PHP _↴