Re: [Squirrel-sql-users] MySql
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
Menu
▾
▴
Re: [Squirrel-sql-users] MySql
|
From: Savoy, M. <Mel...@te...> - 2006-12-05 21:29:03
|
Colin,
Thanks for the reply and your time. =20
I will keep trying on my end and see if I can find what/where my problem
is.
Regards.
=20
-----Original Message-----
From: squ...@li...
[mailto:squ...@li...] On Behalf Of
Colin Bell
Sent: Tuesday, December 05, 2006 3:18 PM
To: squ...@li...
Subject: Re: [Squirrel-sql-users] MySql
On Tue, Dec 05, 2006 at 06:52:41AM -0600, Savoy, Melinda wrote:
> Robert,
>=20
> Thanks for the response. I tried what you suggested however, this is=20
> what is happening. I have a .sql script whereby I drop tables, create
> tables and then insert data into multiple schemas.
>=20
> It would appear that after I run the entire script the DROP tables=20
> runs successfully but I do not see that any of the tables have been=20
> 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 =20
------------------------------------------------------------------------
------------------------------------------------------------------------
----------------------------------------------
1 PHA xxxxxx A
VAR INV CAPLMT 9999999
=20
2 PHA xxxxxx A
VAR INV COMTYP ALL
=20
3 PHA xxxxxx A
VAR INV DEPT ALL
=20
4 PHA xxxxxx A
VAR INV NSKLMT 9999999
=20
5 PHA xxxxxx A
VAR INV PURCH 8681
=20
6 PHA xxxxxx A
VAR INV STKLMT 9999999
=20
7 PHA xxxxxx A
VAR INV REPORT ALL
=20
8 PHP xxxxxx A
VAR INV ACCT 12500020
=20
9 PHP xxxxxx A
VAR INV CAPLMT 9999999
=20
10 PHP xxxxxx A
VAR INV COMTYP ALL
=20
11 PHP xxxxxx A
VAR INV DEPT ALL
=20
12 PHP xxxxxx A
VAR INV NSKLMT 9999999
=20
13 PHP xxxxxx A
VAR INV PURCH 8681
=20
14 PHP xxxxxx A
VAR INV STKLMT 9999999
=20
15 PHP xxxxxx A
VAR INV REPORT ALL
=20
--
Colin Bell
The information contained in this message and any attachments is intended=
only for the use of the individual or entity to which it is addressed, a=
nd may contain information that is PRIVILEGED, CONFIDENTIAL, and exempt f=
rom disclosure under applicable law. If you are not the intended recipie=
nt, you are prohibited from copying, distributing, or using the informati=
on. Please contact the sender immediately by return e-mail and delete th=
e original message from your system.
|
