You are given a task to create a table named 'employees' from a JDBC connection to a MySQL database. The table should include columns 'id', 'name', and 'salary'. Write the Spark SQL command to achieve this.

Simulated

CREATE TABLE employees USING JDBC OPTIONS (url 'jdbc:mysql://localhost:3306/mydb', dbtable 'employees', user 'root', password 'password')

35.1%

CREATE TABLE employees USING JDBC OPTIONS (url 'jdbc:mysql://localhost:3306/mydb', dbtable 'employees', user 'root', password 'password', columns 'id', 'name', 'salary')

24.4%

CREATE TABLE employees USING JDBC OPTIONS (url 'jdbc:mysql://localhost:3306/mydb', dbtable 'employees', user 'root', password 'password', columns 'id, name, salary')

22.7%

CREATE TABLE employees USING JDBC OPTIONS (url 'jdbc:mysql://localhost:3306/mydb', dbtable 'employees', user 'root', password 'password', columns 'id name salary')

17.8%

Databricks Certified Data Engineer - Associate

Get started today

Comments

You are given a task to create a table named 'employees' from a JDBC connection to a MySQL database. The table should include columns 'id', 'name', and 'salary'. Write the Spark SQL command to achieve this.