Duvida criando tabela MySQL

[GabAlves]

06.09 11:28:55 [Server] WARN com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'keys (key VARCHAR(255) NOT NULL, grupo VARCHAR(255) NOT NULL, dia VARCHAR(255) N' at line 1
06.09 11:28:55 [Server] WARN at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
06.09 11:28:55 [Server] WARN at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
06.09 11:28:55 [Server] WARN at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
06.09 11:28:55 [Server] WARN at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
06.09 11:28:55 [Server] WARN at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
06.09 11:28:55 [Server] WARN at com.mysql.jdbc.Util.getInstance(Util.java:382)
06.09 11:28:55 [Server] WARN at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
06.09 11:28:55 [Server] WARN at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
06.09 11:28:55 [Server] WARN at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
06.09 11:28:55 [Server] WARN at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
06.09 11:28:55 [Server] WARN at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
06.09 11:28:55 [Server] WARN at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
06.09 11:28:55 [Server] WARN at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
06.09 11:28:55 [Server] WARN at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:779)
06.09 11:28:55 [Server] WARN at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:622)

            MySQL.statement.execute("CREATE TABLE IF NOT EXISTS keys (key VARCHAR(255) NOT NULL, grupo VARCHAR(255) NOT NULL, dia VARCHAR(255) NOT NULL)");

Aí a lida do erro '-'

 

Oque está errado pra min está tudo certo '-'

[BrunnoFdc]

Tente deixar assim:

CREATE TABLE IF NOT EXISTS `keys` (`key` VARCHAR(255) NOT NULL, `grupo` VARCHAR(255) NOT NULL, `dia` VARCHAR(255) NOT NULL)

Foi o que o phpMyAdmin apontou como errado aqui.

Att

[jeta]

Sua dúvida foi marcada como [Resolvido] e movido à área de dúvidas resolvidas.


Atenciosamente,
Gamer's Board