Mysql table name with space in mysql

Published: 25 June 2017
on channel: Open Source Devops

1,000

#mysql #table #name #rename #space
Demo of Table :-
CREATE TABLE IF NOT EXISTS `TABLE 8` (
`title` varchar(56) DEFAULT NULL,
`platform` varchar(16) DEFAULT NULL,
`score` decimal(2,1) DEFAULT NULL,
`genre` varchar(17) DEFAULT NULL,
`editors_choice` varchar(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `TABLE 8`
--

INSERT INTO `TABLE 8` (`title`, `platform`, `score`, `genre`, `editors_choice`) VALUES
('LittleBigPlanet PS Vita', 'PlayStation Vita', 9.0, 'Platformer', 'Y'),
('LittleBigPlanet PS Vita -- Marvel Super Hero Edition', 'PlayStation Vita', 9.0, 'Platformer', 'Y'),
('Splice: Tree of Life', 'iPad', 8.5, 'Puzzle', 'N'),
('NHL 13', 'Xbox 360', 8.5, 'Sports', 'N'),
('NHL 13', 'PlayStation 3', 8.5, 'Sports', 'N'),
('Total War Battles: Shogun', 'Macintosh', 7.0, 'Strategy', 'N'),
('Double Dragon: Neon', 'Xbox 360', 3.0, 'Fighting', 'N'),
('Guild Wars 2', 'PC', 9.0, 'RPG', 'Y');

select Query :-
select * from `TABLE 8`;

~-~~-~~~-~~-~
Please watch: "create data dictionary using code"
• create data dictionary using code
~-~~-~~~-~~-~ buy a coffee for me on this URL https://opensourcedevops.web.app or PayPal donation https://www.paypal.com/paypalme/OpenS...

Watch video Mysql table name with space in mysql online, duration hours minute second in high quality that is uploaded to the channel Open Source Devops 25 June 2017. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 1,000 times and liked it 5 visitors.