I write:
- :CREATE TABLE Person (
- :name CHAR(10),
- :
- :ssn INTEGER);
and save it to a file "a.sql" (colon represents beginning of line, is not in actual code.)
If I then run it by typing "@a" in the mysql command prompt, it will tell me that the line starting with "ssn" is not recognized as a command, and is ignored.
From what I gather, it seems that sqlplus terminates a command if it encounters multiple newline characters in a row. Is this an accurate statement? If so, does anyone know if this is necessary/ why it chooses to do this?