CODEWITHSUNDEEP
mysql
Bisss123
Bisss123

Reputation: 1

Check the manual that corresponds to your MySQL version for the right syntax to use near 'Limit 100' at line 1

This is fairly a simple code that I am writing using PopSQL but every time I run SELECT the error shows up.

CREATE TABLE student (
     student_id INT PRIMARY KEY,    
     name1 VARCHAR(20),
     major VARCHAR(20)
);

DESCRIBE student;

SELECT * FROM student;

INSERT INTO student VALUES(3, 'John', 'Software');

Upvotes: 0

Views: 576

Answers (1)

Mark B
Mark B

Reputation: 682

I did a web search "popsql limit error" and the first result answered your question, uncheck the auto limit box.

https://popsql.com/docs/getting-started/writing-a-query

Upvotes: 1

Related Questions