#1046 - No database has been selected

franckod Posted messages 2 Status Member -  
franckod Posted messages 2 Status Member -
I have a problem with my database; I'm getting this error

 CREATE TABLE `ibit_assets` ( `id` int(10) UNSIGNED NOT NULL COMMENT 'Primary Key', `parent_id` int(11) NOT NULL DEFAULT '0'COMMENT ) 

MySQL responded: Documentation
#1046 - No database has been selected

Can you please help me

EDIT: Added code tags

2 answers

  1. jordane45 Posted messages 30427 Registration date   Status Moderator Last intervention   4 832
     
    Hello,

    And how do you proceed to create yours?
    Do you do it via command line, through code, or through an interface like PhpMyAdmin?
    Have you created the database (before attempting to create your table)?
    If so... have you selected it (as the error message indicates...)

    --
    Best regards,
    Jordane
    4