I according to the quickstart instance case to do the train into the management system, use the username family keywords and index, and then in the View, Interactive SQL input SQL statement
Insert into password values (" admin ", "1") tip C0195: after the statement requires'; '
They add a 'at the back; 'Error: after C0195: SQLSTATE=s0002mm [sybase] [odbc driver] [the Adaptive Server Anywhere] column not found: the column' admin 'not found great god some instruction, I am just learning

CodePudding user response:

Insert into password values (" admin ", "1");
The statement said the password table insert a line, the lines of the first column has a value of admin, the second column has a value of 1

Feel the table name is wrong, not seen for the password separately set up a table:
Should build a user list, there are two columns (name, password), then insert statement is as follows:
Insert into users (name, password) values (" admin ", "1");

CodePudding user response:

Grammar wrong

INSERT INTO table (column, the column name) VALUES (VALUES, value)

Column names and values corresponding

CodePudding user response:

Pb embedded SQL to; A semicolon

CodePudding user response:

Instead of
Insert into password values (' admin ', '1')

Try the double quotes instead of single quotation marks