After you create tables in DLA, you can execute standard SQL statements to manage data in these tables. The DLA console provides an SQL runtime environment. This topic describes how to execute SQL statements in the DLA console.
Log on to the Data Lake Analytics console.
In the left-side navigation pane, click Execute. On the Execute page that appears, write an SQL statement, and then click Sync Execute(F8) or Async Execute(F9).
You can log on to the Data Lake Analytics console, and click Log on in DMS to execute SQL statements for managing data in tables.
Alternatively, you can use code, MySQL CLI tools, or MySQL clients to connect to DLA, and then execute SQL statements to manage data in tables. For more information about how to connect to DLA, see Connect to DLA.