Tuesday, July 29, 2014

Table involved for the recording tracking

mysql> describe recording_track;
+-------------+--------------+------+-----+---------+----------------+
| Field       | Type         | Null | Key | Default | Extra          |
+-------------+--------------+------+-----+---------+----------------+
| id          | int(11)      | NO   | PRI | NULL    | auto_increment |
| primary_ext | varchar(20)  | YES  |     | NULL    |                |
| httplink    | varchar(100) | YES  |     | NULL    |                |
| filesize    | int(20)      | YES  |     | NULL    |                |
+-------------+--------------+------+-----+---------+----------------+
4 rows in set (0.00 sec)

mysql> insert into recording_track values ("","3101","https://drive.google.com/folderview?id=0Bzw96Nl15-yLQlZYR0h2V1dxWmc&usp=sharing&invite=CKjF-ssJ",1250,"201406TnL");
Query OK, 1 row affected, 1 warning (0.00 sec)

mysql> select * from recording_track;
+----+-------------+--------------------------------------------------------------------------------------------------+----------+-----------+
| id | primary_ext | httplink                                                                                         | filesize | name      |
+----+-------------+--------------------------------------------------------------------------------------------------+----------+-----------+
|  1 | 2801        |
https://drive.google.com/folderview?id=0Bzw96Nl15-yLbnJFd2Q1UkhtY1k&usp=sharing&invite=CPWiouII |      948 | 201406LS  |
|  2 | 2801        | https://drive.google.com/folderview?id=0Bzw96Nl15-yLbmh5THoxa1RNU0k&usp=sharing&invite=CImO6sYN  |      225 | 201405LS  |
|  3 | 3101        | https://drive.google.com/folderview?id=0Bzw96Nl15-yLQlZYR0h2V1dxWmc&usp=sharing&invite=CKjF-ssJ  |     1250 | 201406TnL |
+----+-------------+--------------------------------------------------------------------------------------------------+----------+-----------+



No comments:

Post a Comment