9638 - Thursday - repairing internet connection on the eee

[scottobear]

See entry comments for mysql code snips in use. Saving on j:/uiia/qmysql/

--
"modem wont work, on msn it says DNS and key ports with an '!' but the internet in general wont' work"

TCP/IP stack repair options for use with Windows XP with SP2.

For these commands, Start, Run, CMD to open a command prompt.

Reset WINSOCK entries to installation defaults: netsh winsock reset catalog

Reset TCP/IP stack to installation defaults. netsh int ip reset reset.log

Also try -

No?
ok, go to your start menu, click run, in the box type:
ipconfig /release

hopefully that fixes it.. it worked for me!

--
Tonight in brief - - Last Restaurant Standing (I think the Cheerful Soul is going to win LRS. ),

BHK picked me up from work, Frozen pizza for dinner, hysteria at bedtime..laughing turned to crying, and lots of itching - allergy meds?

--

1 year ago - awesome taco salad, Doc Savage 75, Clinton still in it, more things I've done (5), airborne faked clinical trials

2 years ago - interviewed at calvert, flew kites

3 years ago - animated newtcam archive, bhk chat, bat-folk, Friday 5, tmbg

4 years ago - scottobear.com renew, trip to deerfield, free fonts, chat crash w/bhk,gp puts me on to spidey bible, what? WhaT?, H2GT2G, Chimp attack, giantsteps

5 years ago - blogspam treatment, work, serial adder, 7-eared kitty, clown sweater, Ephemera, visited bro

6 years ago - book meme, palm doodles, picture issues

7 years ago - mopey, bro helping out, Dick Hymen - Master of Jazz Piano, super tugboat, Newton's name, pet name poll, magic ingredients

8 years ago - Perseus tools, loved ones sick, flying monkeys, The 30 Least-Quoted Lines from Shakespeare, nosepilot, 5k comp

Comments

CODE EXAMPLE: DBA_OBJECTS view for MySQL 5.0

[scottobear.livejournal.com]

-- as per Roland Boumann's suggestions, a new version
-- TODO: add triggers, procedures

CREATE DATABASE IF NOT EXISTS dba;
USE dba;

DROP VIEW IF EXISTS `dba`.`dba_objects`;
CREATE VIEW `dba`.`dba_objects` AS
SELECT SCHEMA_NAME AS `OBJECT_NAME`, 'system' AS `SUPER_OBJECT`, 'schema' AS `OBJECT_TYPE`, 'system' AS `SUPER_OBJECT_TYPE`, SCHEMA_NAME as `SCHEMA_NAME` FROM information_schema.schemata
UNION
SELECT TABLE_NAME, TABLE_SCHEMA, 'table', 'schema', TABLE_SCHEMA AS s1 FROM information_schema.tables
UNION
SELECT TABLE_NAME, TABLE_SCHEMA, 'view', 'schema', TABLE_SCHEMA AS s1 FROM information_schema.VIEWS
UNION
SELECT COLUMN_NAME, TABLE_NAME, 'column', 'table', TABLE_SCHEMA FROM information_schema.COLUMNS
UNION
SELECT CONSTRAINT_NAME, TABLE_NAME, 'index', 'table', TABLE_SCHEMA FROM information_schema.KEY_COLUMN_USAGE;

SELECT * FROM dba.dba_objects;

When using Oracle, the data dictionary provides us with tons of tables and views, allowing us to fetch information about pretty much anything within the database. Well, we do have information like that on MySQL 5.0 (and up) thru the information_schema database, but it’s scattered thru several different tables. This 'view' allow us to quickly locate any objects within a MySQL database. It's actually a stored procedure, but after the table gets populated, you can query it as any other table.