Are you trying to create a database for WordPress? If so, when you install WP, it will create the necessary tables. You do not need to (and should not) create tables yourself.
I found this code
Error
SQL query: Copy
CREATE TABLE bookladdermatch_form (
id INT(20) NOT NULL,
date_fld DATE NOT NULL,
time_fld TIME(20) NOT NULL,
challenger_fld VARCHAR(20) NOT NULL,
opponent_fld VARCHAR(20) NOT NULL
);
MySQL said: #1426 - Too big precision 20 specified for 'time_fld'. Maximum is 6
I believe from what I read this can be changed, can anyone advise how this can be carried out please?
Thanks
John H
The code described is not part of WordPress. What do you think it has to do with WordPress?
If you want to install WordPress, proceed as described by @sterndata. There are also instructions here: https://developer.wordpress.org/advanced-administration/before-install/howto-install/
I have already installed WordPress and was able to create several test databases including tables with no problems. Suddenly that has changed so that on a database creation no tables are created.
After searching for a solution I discovered the article and mistakenly thought the code I found may assist.
Any other suggestions please? Thank you
John H
You need only create a database; do not create the tables.
Hello Steven
Just checking!…..
As above no tables are created automatically and that’s OK? So for a listing site where/how does the information detail get stored please?
John H
Thanks Steven,
WHen you install WP and get to the screen where it asks for database credentials — that’s when and where it will create the tables.
