mysql show columns from users_profile -------------- -------------- --

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
mysql> show columns from users_profile;
+--------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| username | varchar(30) | NO | UNI | | |
| first_name | varchar(30) | NO | | | |
| last_name | varchar(30) | NO | | | |
| email | varchar(75) | NO | | | |
| password | varchar(128) | NO | | | |
| is_staff | tinyint(1) | NO | | | |
| is_active | tinyint(1) | NO | | | |
| is_superuser | tinyint(1) | NO | | | |
| last_login | datetime | NO | | | |
| date_joined | datetime | NO | | | |
+--------------+--------------+------+-----+---------+----------------+
11 rows in set (0.00 sec)
mysql> show columns from users_user;
ERROR 1146 (42S02): Table 'filmfeed.users_user' doesn't exist
mysql> show columns from auth_user;
+--------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| username | varchar(30) | NO | UNI | | |
| first_name | varchar(30) | NO | | | |
| last_name | varchar(30) | NO | | | |
| email | varchar(75) | NO | | | |
| password | varchar(128) | NO | | | |
| is_staff | tinyint(1) | NO | | | |
| is_active | tinyint(1) | NO | | | |
| is_superuser | tinyint(1) | NO | | | |
| last_login | datetime | NO | | | |
| date_joined | datetime | NO | | | |
+--------------+--------------+------+-----+---------+----------------+
11 rows in set (0.00 sec)
mysql>