Answer the question
In order to leave comments, you need to log in
Why are the columns not being created?
Tell me the error in the code, creates a database, creates a table, but does not create columns in the table.
public static void createDB(String url,String nameDB ,String nameUser,String password){
DB db = new DB(url,"",nameUser,password);
try{
db.update("CREATE DATABASE " + nameDB);
db.update("USE " + nameDB);
db.update("CREATE TABLE users(id_user INT AUTO_INCREMENT,"
+ "fio VARCHAR(255) NOT NULL,"
+ "login VARCHAR(10) NOT NULL,"
+ "password VARCHAR(10) NOT NULL,"
+ "PRIMARY KEY (id_user))");
Answer the question
In order to leave comments, you need to log in
not columns, but fields take www.mysqlfront.de
or some kind of DB Forge, test the query, then divide it into your own rows for gluing
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question