How to export sql statement in navicat

1. Create the student table and insert 3 rows of data.

2. Enter the query statement:

SELECT studentName
FROM student

Related recommendations: "Navicat for mysql usage pictures and texts Tutorial》

3. Click Save As and enter the query name (name of the saved sql file).

#4. Click test on the left, right-click - [Open the included folder], and you can see the saved sql file.

The above is the detailed content of How to export sql statement in navicat. For more information, please follow other related articles on the PHP Chinese website!