Email SQL in rich text

April 23, 2020

So emailing something like this is gross. How to make it easy to read for the recipient?

Use Dbeaver sql editor >>  Copy-Shift-C as html >> save as query.html >> copy-paste from that into email client (or Word or Onenote or…). Might work with vscode too. Does not work with Notepad++ unfortunately.

Before

# PHP Version: 4.3.

# Database : `yfwmb`

# --------------------------------------------------------

#

# Table structure for table `action_item`

#

# Creation: Jul 31, 2003 at 02:26 PM

# Last update: Jul 05, 2004 at 09:51 AM

#

CREATE TABLE `action_item` (

  `action_item_id` int(10) unsigned NOT NULL auto_increment,

  `action_item_title` varchar(120) default NULL,

  `action_item_region_id` int(10) unsigned NOT NULL default '0',

  `action_item_responsibility_id` int(10) unsigned NOT NULL default '0',

  `action_item_cross_reference` varchar(50) default NULL,

  PRIMARY KEY  (`action_item_id`)

) TYPE=MyISAM AUTO_INCREMENT=105 ;

After

# PHP Version: 4.3.4
# Database : `yfwmb`
# --------------------------------------------------------
#
# Table structure for table `action_item`
#
# Creation: Jul 31, 2003 at 02:26 PM
# Last update: Jul 05, 2004 at 09:51 AM
#
CREATE TABLE `action_item` (
  `action_item_id` int(10) unsigned NOT NULL auto_increment,
  `action_item_title` varchar(120) default NULL,
  `action_item_region_id` int(10) unsigned NOT NULL default '0',
  `action_item_responsibility_id` int(10) unsigned NOT NULL default '0',
  `action_item_cross_reference` varchar(50) default NULL,
  PRIMARY KEY  (`action_item_id`)
) TYPE=MyISAM AUTO_INCREMENT=105 ;