Take our quiz to find out what your revision personality is! >>

computer science ocr

do we need to know how to do an sql statement I can learn it pretty easily but I watched a video covering all the topics and it wasn't mentioned have they taken it off the specification?

Reply 1

reltivq

yeah we do im pretty certain. just checked the spec now and we need to know select, where and from clauses

Reply 2

noorulhasan

if we want to make a query, that selects specific groups, do we do:

SELECT typeName, example, oriGami

OR do we do:

SELECT typeName AND example AND oriGami

Reply 3

reltivq

Original post by noorulhasan

if we want to make a query, that selects specific groups, do we do:

SELECT typeName, example, oriGami

OR do we do:

SELECT typeName AND example AND oriGami

1st one. SELECT fields are always separated by commas, and WHERE fields are always separated by AND

also if you need a cheat sheet (it's for software devs but still useful for us) then here you go https://www.pantz.org/software/mysql/mysqlcommands.html
read the commands from "Show all data in a table" to "Show all records starting with the letters 'bob' AND the phone number '3444444'". pretty certain ocr cs is only that section