Visual Studio Magazine

Tricks for Processing SQL Scripts

SQL Server 2005's Management Studio offers lots of new functionality, but you can't always use a GUI. Sometimes you need to run a script from the command line, especially for an upgrade or install ...
TechRepublic

How to create tables and add data to MySQL database with MySQL Workbench

The MySQL Workbench main window. How to create tables and add data to MySQL database with MySQL Workbench Your email has been sent The MySQL Workbench GUI is cross-platform, open source, and ...
Ars Technica

MySQL script import fails... ugh... :(

c_sec_id INT( 6 ) , course_id INT( 6 ) CONSTRAINT course_section_courseid_nn NOT NULL , term_id INT( 6 ) CONSTRAINT course_section_termid_nn NOT NULL , sec_num INT( 2 ) CONSTRAINT ...
Ars Technica

Better to store in one big array or several smaller ones?

hi all, I'm trying to optimize a php/mysql script and was looking for some advice.<br><br>I've got a mysql result set that I need to offload to an array. There will be anywhere from 4000 to 50000 rows ...