Cloud Computing/Cloud Services/MySQL/SQL

From UEQ Wiki
Jump to: navigation, search

Data Manipulation Statements

INSERT

INSERT INTO `research`.`literary_content`
( `pub_year`, `citation`, `tags`, `cited_by`, `periodical_title`, `content_title`)
VALUES (
2017,
'Celesti, A., Celesti, F., Fazio, M., Bramanti, P., & Villari, M. (2017). Are next-generation sequencing tools ready for the cloud?. Trends in biotechnology, 35(6), 486-489.',
('iaas,cloud_services,platform_as_a_service'),
12,
'Trends in biotechnology',
'Are next-generation sequencing tools ready for the cloud?.');

SELECT with LIKE

SELECT `literary_content`.`id`,
`literary_content`.`created_ts`,
`literary_content`.`updated_ts`,
`literary_content`.`pub_year`,
`literary_content`.`citation`,
`literary_content`.`tags`,
`literary_content`.`cited_by`,
`literary_content`.`periodical_title`,
`literary_content`.`content_title`
FROM `research`.`literary_content`
where citation like '%disintegration%';