-
Kevin Yili Hong commented on the post, Happy Birthday SNL // the typists from the Carol Burnett show, on the site Course Blog on Data Analytics 12 years, 4 months ago
This is actually try to get the average price of all products.
-
Kevin Yili Hong commented on the post, Happy Birthday SNL // the typists from the Carol Burnett show, on the site Course Blog on Data Analytics 12 years, 4 months ago
Yes Uriel you are correct. In many versions of workbench, putting “use database_name” will simplify future queries, but it may not work in some cases.
Yes double quotes work same as single quotes for string values in MySQL. -
Kevin Yili Hong commented on the post, Happy Birthday SNL // the typists from the Carol Burnett show, on the site Course Blog on Data Analytics 12 years, 4 months ago
the correct way to write this query is:
Select * From ’moviedb’.’actor’ Where state=’PA’;
first, the table is ACTOR, so it needs to be immediately after the “from” keyword, second, “PA” is a string value, so […]
-
Kevin Yili Hong commented on the post, Happy Birthday SNL // the typists from the Carol Burnett show, on the site Course Blog on Data Analytics 12 years, 4 months ago
right, this not only selects all customers, it selects all the columns as well.
-
Kevin Yili Hong commented on the post, Happy Birthday SNL // the typists from the Carol Burnett show, on the site Course Blog on Data Analytics 12 years, 4 months ago
right, a better way to phrase the objective may be: find the price of the most expensive product.
-
Kevin Yili Hong commented on the post, Happy Birthday SNL // the typists from the Carol Burnett show, on the site Course Blog on Data Analytics 12 years, 4 months ago
does it work now?
-
Kevin Yili Hong wrote a new post on the site Course Blog on Data Analytics 12 years, 4 months ago
Hi All,
Exams are important (especially if you want to get a high score), please make an effort to come tomorrow (May 31), we will have a review session, and continue in class exercise for MySQL queries.
-
Kevin Yili Hong wrote a new post on the site Course Blog on Data Analytics 12 years, 4 months ago
The IP address of the server: 129.32.124.177
mis26 – MLZIS0
mis27 – QE10KH
mis28 – 6F048I
mis29 – 2L5C8Z
mis30 – 53P847
mis31 – FTE044
<td […]
-
Kevin Yili Hong wrote a new post on the site Course Blog on Data Analytics 12 years, 4 months ago
Please see assignment 2: MySQL #1 here.
-
Kevin Yili Hong commented on the post, Happy Birthday SNL // the typists from the Carol Burnett show, on the site Course Blog on Data Analytics 12 years, 4 months ago
good!
-
Kevin Yili Hong commented on the post, Happy Birthday SNL // the typists from the Carol Burnett show, on the site Course Blog on Data Analytics 12 years, 4 months ago
good query!
-
Kevin Yili Hong commented on the post, Happy Birthday SNL // the typists from the Carol Burnett show, on the site Course Blog on Data Analytics 12 years, 4 months ago
nice with no issue!
-
Kevin Yili Hong commented on the post, Happy Birthday SNL // the typists from the Carol Burnett show, on the site Course Blog on Data Analytics 12 years, 4 months ago
Lists unique first names of actors in “alphabetical order”, then it should be “order by”!
-
Kevin Yili Hong wrote a new post on the site Course Blog on Data Analytics 12 years, 4 months ago
Please see class capture here.
-
Kevin Yili Hong commented on the post, Before Class Question: May 30 (MySQL Query), on the site Course Blog on Data Analytics 12 years, 4 months ago
good query, don’t forget the “;” which ends the command!
-
Kevin Yili Hong commented on the post, Happy Birthday SNL // the typists from the Carol Burnett show, on the site Course Blog on Data Analytics 12 years, 4 months ago
don’t forget the “;” which ends the command!
-
Kevin Yili Hong wrote a new post on the site Course Blog on Data Analytics 12 years, 4 months ago
spend 1-2 minute and write a MySQL query that comes into your mind.
-
Kevin Yili Hong wrote a new post on the site Course Blog on Data Analytics 12 years, 4 months ago
-
Kevin Yili Hong wrote a new post on the site Course Blog on Data Analytics 12 years, 4 months ago
Hello all,
Assignment 1 is due today, please make an effort to print the answers out with your name and TUid on the answer sheet. If you are hand writing the diagram/schema(schema is for extra 2 points), please […]
-
Kevin Yili Hong wrote a new post on the site Course Blog on Data Analytics 12 years, 4 months ago
Hello all,
Please find here the first MySQL exercise we are going to do in class. If we go over time, we will continue next class. It is extremely important for you!
Download here.
- Load More