mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| video              |
+--------------------+
3 rows in set (0.00 sec)

mysql> use video;
Database changed
mysql> show tables;
+-------------------------------+
| Tables_in_video               |
+-------------------------------+
| attori                        |
| dvd                           |
| qry_attori_da_cancellare      |
| qry_dvd_attori                |
| qry_dvd_marca_caratteristiche |
| qry_dvd_registi               |
| qry_registi_da_cancellare     |
| raccordo_attori               |
| raccordo_registi              |
| registi                       |
| supporti_caratteristiche      |
| supporti_costruttori          |
+-------------------------------+
12 rows in set (0.00 sec)

mysql> show fields from attori;
+--------+--------------+------+-----+---------+----------------+
| Field  | Type         | Null | Key | Default | Extra          |
+--------+--------------+------+-----+---------+----------------+
| id     | int(11)      | NO   | PRI | NULL    | auto_increment |
| Attore | varchar(255) | NO   | UNI | NULL    |                |
| foto   | longblob     | YES  |     | NULL    |                |
+--------+--------------+------+-----+---------+----------------+
3 rows in set (0.00 sec)

mysql> select id,Attore from attori order by Attore;
+-----+----------------------+
| id  | Attore               |
+-----+----------------------+
|  65 | Adrienne Corri       |
|   1 | Al Pacino            |
|   2 | Andy Garcia          |
|  55 | Anna Magnani         |
|  43 | Annette Bening       |
|  59 | Anthony Quinn        |
|   4 | Antonio Banderas     |
|   3 | Ariella Reggio       |
| 143 | Atossa Leoni         |
| 148 | Attore di prova      |
| 111 | Ben Kingsley         |
|   5 | Ben Stiller          |
|   6 | Beppe Fiorello       |
|  89 | Brenda Blethyn       |
| 120 | Bud Spencer          |
|  66 | Carl Duering         |
|   7 | Carlo Verdone        |
|  96 | Carrie-Anne Moss     |
| 122 | Charles Bronson      |
| 133 | Charlize Theron      |
| 137 | Cheryl Hines         |
|  87 | Chris Evans          |
|  72 | Christopher Walken   |
| 121 | Claudia Cardinale    |
|  76 | Clint Eastwood       |
|  68 | Clive Francis        |
|  90 | Daniel Day-Lewis     |
|  82 | Daniel Radcliffe     |
|  71 | Danny Glover         |
|  45 | Danny Michael DeVito |
| 129 | David Mattey         |
|   8 | Diane Keaton         |
|   9 | Diego Abatantuono    |
| 131 | Eddie Marsan         |
|  40 | Eddie Murphy         |
| 114 | Embeth Davidtz       |
|  83 | Emma Watson          |
| 109 | Emmy Rossum          |
|  93 | Eric Schweig         |
|  10 | Ernest Everest       |
| 123 | Fabio Testi          |
| 118 | Franco Graziosi      |
|  57 | Frank Sinatra        |
| 124 | Gabriele Ferzetti    |
|  81 | Gael Garcİa Bernal   |
| 102 | Gary Cooper          |
|  75 | Gene Hackman         |
|  42 | Glenn Close          |
|  99 | Grace Kelly          |
| 110 | Greg Kinnear         |
| 125 | Henry Fonda          |
| 144 | Homayoun Ershadi     |
|  85 | Ioan Gruffudd        |
| 127 | Jack Elam            |
|  41 | Jack Nicholson       |
| 130 | Jae Head             |
| 115 | James Coburn         |
| 132 | Jason Bateman        |
| 126 | Jason Robards        |
| 128 | Jean Peters          |
|  78 | Jean Reno            |
| 136 | Jeff Daniels         |
|  29 | Jenny Tamburi        |
|  74 | Jeremy Klein         |
|  86 | Jessica Alba         |
|  36 | Jessica Lange        |
| 139 | Joanna Levesque      |
|  73 | John Beckwith        |
|  64 | John Clive           |
|  80 | John Corbett         |
|  11 | Johnny Deep          |
| 140 | Josh Hutcherson      |
| 100 | Katy Jurado          |
|  94 | Keanu Reeves         |
|  48 | Keira Knightley      |
| 105 | Kevin Bacon          |
|  12 | Kevin Koster         |
| 145 | Khalid Abdalla       |
| 138 | Kristin Chenoweth    |
| 108 | Laura Linney         |
|  95 | Laurence Fishburne   |
| 101 | Lee Van Cleef        |
|  13 | Leonardo di Caprio   |
| 113 | Liam Neeson          |
|  91 | Madeleine Stowe      |
|  60 | Malcolm Mcdowell     |
| 107 | Marcia Gay Harden    |
| 117 | Maria Monti          |
|  14 | Marlon Brando        |
|  15 | Matt Dillon          |
|  16 | Maurice Ronet        |
|  17 | Mel Gibson           |
|  62 | Michael Bates        |
|  88 | Michael Chiklis      |
|  53 | Michael Douglas      |
|  69 | Michael Gover        |
|  52 | Micheal J. Fox       |
|  18 | Mickey Rourke        |
|  38 | Monica Bellucci      |
|  19 | Morgan Freeman       |
|  21 | Nicole Kidman        |
|  20 | Nicoletta Braschi    |
|  49 | Orlando Bloom        |
|  22 | Ornella Muti         |
|  23 | Paolo Villaggio      |
|  61 | Patrick Magee        |
|  67 | Paul Farrell         |
|  44 | Pierce Brosnan       |
|  39 | Pietro Valsecchi     |
| 112 | Ralph Fiennes        |
|  24 | Ricky Tognazzi       |
|  25 | Robert De Niro       |
|  54 | Robert Duvall        |
|  26 | Roberto Benigni      |
| 135 | Robin Williams       |
| 116 | Rod Steiger          |
|  84 | Rupert Grint         |
|  27 | Russell Crow         |
|  92 | Russell Means        |
| 146 | Sa´d Taghmaoui       |
|  98 | Sarah Jessica Parker |
|  28 | Sean Connery         |
| 103 | Sean Penn            |
| 147 | Shaun Toub           |
|  77 | Sigourney Weaver     |
|  50 | Sylvester Stallone   |
| 119 | Terence Hill         |
|  30 | Tim Robbins          |
|  31 | Tina Tuner           |
|  33 | Tom Hanks            |
|  32 | Ugo Tognazzi         |
|  97 | Veronica Cartwright  |
|  37 | Viggo Mortensen      |
|  58 | Vivien Leigh         |
|  63 | Warren Clarke        |
| 141 | Will Arnett          |
| 134 | Will Smith           |
+-----+----------------------+
137 rows in set (0.00 sec)

mysql>