Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Development Tools Database Foundations SQL Calculating, Aggregating and Other Functions Numeric and Aggregate Functions

Bradley Johnson
Bradley Johnson
11,539 Points
Posted by Bradley Johnson
Bradley Johnson
11,539 Points

SQL script stalls out when run in Workbench. Wat do?

The SQL script attached to this video does not execute. It just stalls and requires a Force Quit for workbench.

2 Answers

Zone Tol
PLUS
Zone Tol
Courses Plus Student 407 Points
Zone Tol
Zone Tol
Courses Plus Student 407 Points

Same here on Fedora 21, Workbench 6.2. Edit: when you open Workbench again the database is there, so it looks like the script have worked.

Chris Underwood
seal-mask
.a{fill-rule:evenodd;}techdegree
Chris Underwood
Full Stack JavaScript Techdegree Student 19,916 Points
Chris Underwood
.a{fill-rule:evenodd;}techdegree
Chris Underwood
Full Stack JavaScript Techdegree Student 19,916 Points

I manually deleted the old database, removed the first line (drop database), and reran it just fine. I had an error that stated the first line would not work with my version (5.6-24).