Build examples/mysql/getting_started_step_1 failed with rustc 1.18.0

[ohmountain]

Hi there, I got a problem when i run the mysql example.

Setup

[dependencies]
diesel = { version = "0.13.0", features = ["mysql"] }
diesel_codegen = { version = "0.13.0", features = ["mysql"] }
dotenv = "0.9.0"

Versions

• Rust:
  rustc 1.18.0 (03fc9d622 2017-06-06)
• Diesel:
  0.13.0
• Database:
  mysql Ver 14.14 Distrib 5.7.18, for Linux (x86_64) using EditLine wrapper
• Operating System
  Ubuntu 16.04 4.4.0-83-generic

Feature Flags

• diesel:
  mysql
• diesel_codegen:
  mysql

Error message

error: expected identifier, found keyword `type`
 --> src/schema.rs:1:1
  |
1 | infer_schema!("dotenv:DATABASE_URL");
  | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  |
  = note: this error originates in a macro outside of the current crate

error: expected identifier, found keyword `type`
 --> src/schema.rs:1:1
  |
1 | infer_schema!("dotenv:DATABASE_URL");
  | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  |
  = note: this error originates in a macro outside of the current crate

error: aborting due to 2 previous errors

error: Could not compile `diesel_demo_step_1_mysql`.

How to resolve this ?
Thanks!

[sgrif]

We don't support columns which have the same name as keywords in Rust (type being the most common case). You'll need to rename the column, or use the table! macro manually (you can generate it with diesel infer-schema) and omit that column.

[ohmountain]

@sgrif 😹😹😹😹😹，thank you !