Back to Mindsdb

Create a Table

docs/sdks/python/create_table.mdx

26.1.0643 B
Original Source

Description

The get_table() and create_table() functions let you save either an existing table or a newly created table into a variable.

Syntax

Use the get_table() method to fetch a table from the mysql_demo_db database:

python
my_table = mysql_demo_db.get_table('my_table')

Or, the create_table() method to create a new table:

python
# option 1
my_table = mysql_demo_db.create_table('my_table', 'SELECT * FROM some_table WHERE key=value')

# option 2
my_table = mysql_demo_db.create_table('my_table', base_table)

# option 3
my_table = mysql_demo_db.create_table('my_table', base_table.filter(key='value'))