# General commands

### Logging into remote db

```bash
mysql -h HOST -P PORT -u USERNAME -p
```

### Creating a table

---

#### Syntax 

```sql
CREATE TABLE table_name (
    column1 datatype contraint,
    column2 datatype,
    column3 datatype,
);
```

#### Example

```sql
CREATE TABLE products (
    id INT AUTO_INCREMENT PRIMARY KEY,
    product_name VARCHAR(32),
    company_id INT,
    FOREIGN KEY (company_id) REFERENCES companies(id)
) ENGINE=InnoDB;
```

### View table creation code

```sql
SHOW CREATE TABLE `table_name`;
```

### Adding a new foreign key

```sql
ALTER TABLE table_name ADD CONSTRAINT fk_foreign_key_name FOREIGN KEY (column_name) REFERENCES table_name(table_column);
```