Re: MySql: msg#00012 db.squirrel-sql.users

On Tue, Dec 05, 2006 at 06:52:41AM -0600, Savoy, Melinda wrote:
> Robert,
>
> Thanks for the response. I tried what you suggested however, this is
> what is happening. I have a .sql script whereby I drop tables, create
> tables and then insert data into multiple schemas.
>
> It would appear that after I run the entire script the DROP tables runs
> successfully but I do not see that any of the tables have been created
> and consequently no data has been inserted. I have to run the CREATE
> and INSERT separately.

The attached script works for me:

0 Row(s) Updated
Query 1 of 28 elapsed time (seconds) - Total: 0.001, SQL query: 0.001,
Building output: 0
0 Row(s) Updated
Query 2 of 28 elapsed time (seconds) - Total: 0.001, SQL query: 0.001,
Building output: 0
0 Row(s) Updated
Query 3 of 28 elapsed time (seconds) - Total: 0.001, SQL query: 0.001,
Building output: 0
0 Row(s) Updated
Query 4 of 28 elapsed time (seconds) - Total: 0.001, SQL query: 0.001,
Building output: 0
0 Row(s) Updated
Query 5 of 28 elapsed time (seconds) - Total: 0.001, SQL query: 0.001,
Building output: 0
0 Row(s) Updated
Query 6 of 28 elapsed time (seconds) - Total: 0.003, SQL query: 0.003,
Building output: 0
0 Row(s) Updated
Query 7 of 28 elapsed time (seconds) - Total: 0.034, SQL query: 0.034,
Building output: 0
0 Row(s) Updated
Query 8 of 28 elapsed time (seconds) - Total: 0.002, SQL query: 0.002,
Building output: 0
0 Row(s) Updated
Query 9 of 28 elapsed time (seconds) - Total: 0.049, SQL query: 0.049,
Building output: 0
1 Row(s) Updated
Query 10 of 28 elapsed time (seconds) - Total: 0.001, SQL query:
0.001, Building output: 0
1 Row(s) Updated
Query 11 of 28 elapsed time (seconds) - Total: 0.002, SQL query:
0.002, Building output: 0
1 Row(s) Updated
Query 12 of 28 elapsed time (seconds) - Total: 0.001, SQL query:
0.001, Building output: 0
1 Row(s) Updated
Query 13 of 28 elapsed time (seconds) - Total: 0.002, SQL query:
0.002, Building output: 0
1 Row(s) Updated
Query 14 of 28 elapsed time (seconds) - Total: 0.001, SQL query:
0.001, Building output: 0
1 Row(s) Updated
Query 15 of 28 elapsed time (seconds) - Total: 0.001, SQL query:
0.001, Building output: 0
1 Row(s) Updated
Query 16 of 28 elapsed time (seconds) - Total: 0.001, SQL query:
0.001, Building output: 0
1 Row(s) Updated
Query 17 of 28 elapsed time (seconds) - Total: 0, SQL query: 0,
Building output: 0
1 Row(s) Inserted
Query 18 of 28 elapsed time (seconds) - Total: 0.001, SQL query:
0.001, Building output: 0
1 Row(s) Inserted
Query 19 of 28 elapsed time (seconds) - Total: 0.001, SQL query:
0.001, Building output: 0
1 Row(s) Inserted
Query 20 of 28 elapsed time (seconds) - Total: 0, SQL query: 0,
Building output: 0
1 Row(s) Inserted
Query 21 of 28 elapsed time (seconds) - Total: 0.001, SQL query:
0.001, Building output: 0
1 Row(s) Inserted
Query 22 of 28 elapsed time (seconds) - Total: 0.001, SQL query:
0.001, Building output: 0
1 Row(s) Inserted
Query 23 of 28 elapsed time (seconds) - Total: 0.001, SQL query:
0.001, Building output: 0
1 Row(s) Inserted
Query 24 of 28 elapsed time (seconds) - Total: 0.001, SQL query:
0.001, Building output: 0
1 Row(s) Inserted
Query 25 of 28 elapsed time (seconds) - Total: 0.001, SQL query:
0.001, Building output: 0
1 Row(s) Inserted
Query 26 of 28 elapsed time (seconds) - Total: 0.001, SQL query:
0.001, Building output: 0
1 Row(s) Inserted
Query 27 of 28 elapsed time (seconds) - Total: 0.001, SQL query:
0.001, Building output: 0
Query 28 of 28 elapsed time (seconds) - Total: 0.103, SQL query:
0.002, Building output: 0.101

PKEY ENTITYCODE OPERTRID RECRDSTATUSCODE RECRDSTATUSDATE
RECRDTYPE SUBSYSTMNAME VALADDCODE VALADDDESCR
VALADDKEY
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
1 PHA xxxxxx A
VAR INV CAPLMT 9999999

2 PHA xxxxxx A
VAR INV COMTYP ALL

3 PHA xxxxxx A
VAR INV DEPT ALL

4 PHA xxxxxx A
VAR INV NSKLMT 9999999

5 PHA xxxxxx A
VAR INV PURCH 8681

6 PHA xxxxxx A
VAR INV STKLMT 9999999

7 PHA xxxxxx A
VAR INV REPORT ALL

8 PHP xxxxxx A
VAR INV ACCT 12500020

9 PHP xxxxxx A
VAR INV CAPLMT 9999999

10 PHP xxxxxx A
VAR INV COMTYP ALL

11 PHP xxxxxx A
VAR INV DEPT ALL

12 PHP xxxxxx A
VAR INV NSKLMT 9999999

13 PHP xxxxxx A
VAR INV PURCH 8681

14 PHP xxxxxx A
VAR INV STKLMT 9999999

15 PHP xxxxxx A
VAR INV REPORT ALL

--
Colin Bell

a.sql
Description: Text document

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users@xxxxxxxxxxxxxxxxxxxxx
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

Previous by Date:	Re: 2. Re: Clipboard problem (Colin Bell), dhenderson
Next by Date:	Re: MySql, Savoy, Melinda
Previous by Thread:	Re: MySql, Savoy, Melinda
Next by Thread:	Re: MySql, Robert Manning
Indexes:	[Date] [Thread] [Top] [All Lists]

Re: MySql: msg#00012

db.squirrel-sql.users

Free Magazines