Microsoft did not invent the concept of outputting a user-defined line
of text; I'm not going to research this but I doubt if they invented
using the word "PRINT" for it either. Also, EVERY vendor includes
extensions to the standard (I just happen to know the keywords for the
T
--silent option, thanks!
Peter Brawley wrote:
Stephen Cook wrote:
I appreciate it but SELECT isn't quite what I want. It adds an
extra 4 to 6 lines to the output (drawing the table, headers, row
counts, etc). PRINT simply outputs whatever comes after it:
PRINT is not a SQL command. The
Stephen Cook wrote:
There are such things as extensions to the standard, and many
languages besides BASIC that have the ability to output a character
string. No need to be snippy.
I will look into the --silent option, thanks!
I also tend to use -BN with these kind of scripts:
mysql -u use
what I want. It adds an extra
4 to 6 lines to the output (drawing the table, headers, row counts,
etc). PRINT simply outputs whatever comes after it:
PRINT is not a SQL command. The mysql client (fortunately) does not
speak Basic.
To minimise output in the mysql client, have a look at t
Stephen Cook wrote:
I appreciate it but SELECT isn't quite what I want. It adds an extra
4 to 6 lines to the output (drawing the table, headers, row counts,
etc). PRINT simply outputs whatever comes after it:
PRINT is not a SQL command. The mysql client (fortunately) does not
speak
I appreciate it but SELECT isn't quite what I want. It adds an extra 4
to 6 lines to the output (drawing the table, headers, row counts, etc).
PRINT simply outputs whatever comes after it:
PRINT 'hey you!'
would show:
hey you!
Not a big deal I suppose but it makes
e to expect from the PRINT statement in MS SQL Server.
I've just put together an SQL Script that I think demonstrates that SELECT
can do mostl of the same things as the PRINT statement.
Here is the script, which works
>From Transact-SQL Help file:
PRINT
Returns a user-defined message to the client.
Syntax
PRINT 'any ASCII text' | @local_variable | @@FUNCTION | string_expr
Arguments
'any ASCII text'
Is a string of text.
@local_variable
Is a variable of any valid character data typ
I am not familiar with the PRINT command so I don't know what it does. I
played with MS SQL Server once for a couple of days a few years back and
that is the only contact I've ever had with SQL Server.
If you can tell me what PRINT does, in detail, maybe I can suggest another
a
I've started using the SELECT with no other clauses but I am still
curious about a PRINT-like command. It is for SQL scripts.
Rhino wrote:
- Original Message - From: "Stephen Cook" <[EMAIL PROTECTED]>
To: "MySQL List"
Sent: Sunday, May 07, 2006 3
- Original Message -
From: "Stephen Cook" <[EMAIL PROTECTED]>
To: "MySQL List"
Sent: Sunday, May 07, 2006 3:53 AM
Subject: PRINT statement?
Is there a statement similar to PRINT in T-SQL (MicroSoft SQL Server)?
It would be handy to debug some scripts.
Is there a statement similar to PRINT in T-SQL (MicroSoft SQL Server)?
It would be handy to debug some scripts.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[snip]
While writing a Script file for Batch execution, Suppose I just wanna
print
a comment on screen how should I do that.. ?
( I want and output Comment on Screen )
Can any one suggest rather than using a SELECT statement to print an out
put
on screen for the same purpose..
[/snip]
Depending
I was wondering about a simple solution.
While writing a Script file for Batch execution, Suppose I just wanna print
a comment on screen how should I do that.. ?
( I want and output Comment on Screen )
Can any one suggest rather than using a SELECT statement to print an out put
on screen for
Hi Guys,
I have been searching for the answer to this question for a while. The
answer is so obvious, yet there was no useful source of documentation
that showed it. I am using the load data infile syntax rather than the
command line utility. To get the warnings the "show warnings" command
is s
Hello.
Are you sure that you have compiled in debugging
support? You have an old version of MySQL, and there
was a bug when MySQL programs were showing that they have
debugging, but really they were without it.
Bomb Diggy <[EMAIL PROTECTED]> wrote:
> I can't seem to get ahold of the
I can't seem to get ahold of the 6 warnings being
generated when I import a csv file.
My ~/.my.cnf file says this:
[client]
fields-terminated-by=,
fields-enclosed-by=\"
#debug=log.txt
#debug=d,info,error,query,general,where:1,load.trace
debug=warning,load.trace
Nothing I do in the 'debug' para
The print string you show is:
"prepare: $insert_sql: $DBI::errstr"
but your error message is
Unable to execute query: DBI::db=HASH(0x8647df0)->errstr
I think your problem is with a print line like:
print "Unable to execute query: $dbh->errstr"
and Perl
Hi!
Am Do, den 10.03.2005 schrieb sam um 14:55:
> Hi,
>
> The perl DBI does not prints error message:
> $sth = $dbh->prepare($insert_sql)
> || print ERRFILE_OUT "prepare: $insert_sql: $DBI::errstr";
>
> The out of this error only does not prin
Hi,
The perl DBI does not prints error message:
$sth = $dbh->prepare($insert_sql)
|| print ERRFILE_OUT "prepare: $insert_sql: $DBI::errstr";
The out of this error only does not print why the error was occurred.
eg.
Unable to execute query: DBI::db=HASH(0x8647df0)->er
Hi list
environment:
host:/ # uname -a
Linux host 2.4.19-4GB #1 Fri Sep 13 13:14:56 UTC 2002 i686 unknown
host:/ #
host:/ # /usr/local/mysql/bin/mysqld -v
/usr/local/mysql/bin/mysqld Ver 4.0.12-max for pc-linux on i686
host:/ #
an php application of ours prepares customer data on the screen in a
On Fri, 26 Mar 2004, Seena Blace wrote:
> Select group,hostname,details from table1 order by group;
>
> I want the output should be like
> Group hostname details
> aa abababa
> abababababab
>zzz
Seena Blace <[EMAIL PROTECTED]> wrote:Hello,
I want to show outpur like this?
Group hostname details
aa abababa
aa abababababab
aa anannanananna
bb llololololool
bb ssjjsjsjsjjsjsj
Select group,hostname,details from table1 order by group;
I want the
This may sound a little bit off, but what programming language are you using
to "print" this. It might be easier to simply use a language like perl to
print out the output that you are suggesting.
From: Seena Blace <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: ORDER BY WI
Hello,
I want to show outpur like this?
Group hostname details
aa abababa
aa abababababab
aa anannanananna
bbllololololool
bbssjj
l: NEFACOMP" <[EMAIL PROTECTED]>
To: "Emilio Ruben Estevez" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Thursday, October 02, 2003 22:16
Subject: Re: How can i make mysql to print date and time automatically?
> INSERT INTO your_table (field1, field2, field3) VAL
ober 01, 2003 17:09
Subject: How can i make mysql to print date and time automatically?
> Hi, im develping an application, and was wondering how can i make mysql
get
> time and date from pc and print it automatically in the time field and
date
> field so the user dont have to worry about
On Wed, 2003-10-01 at 10:09, Emilio Ruben Estevez wrote:
> Hi, im develping an application, and was wondering how can i make mysql get
> time and date from pc and print it automatically in the time field and date
> field so the user dont have to worry about entering the coorect time an
Hi, im develping an application, and was wondering how can i make mysql get
time and date from pc and print it automatically in the time field and date
field so the user dont have to worry about entering the coorect time and
date. Is this posible, ive created a databse with fields hour(time
http://www.mysql.com/doc/en/SELECT.html
Look at INTO OUTFILE for what you need.
Simon
-Original Message-
From: Wang Feng [mailto:[EMAIL PROTECTED]
Sent: 29 September 2003 08:54
To: [EMAIL PROTECTED]
Subject: Newbie Q: how to send the records of a table to a file and then
print them out
Greetings,
I use WinXP and MySQL.
I have a customer table, which contains about 200 records.
Now I want to print all the records of the table out. How can I achieve
that?
Can I send them to a .doc OR .txt file before printing?
cheers,
feng
--
MySQL General Mailing List
For list archives
serius.com/
=
Richard Nagle wrote:
>
> What would be the command in mysql
> for print out this:
>
> select * from test3;
> this prints out the table and show the records on screen
> now if I wanted to a hard copy..
>
> how
What would be the command in mysql
for print out this:
select * from test3;
this prints out the table and show the records on screen
now if I wanted to a hard copy..
how would I do this.
Thanks-
Rick
-
Before posting, please
Hi!
How can I print the results to the printer in
Windows2000 environment? Is there any MySQL command
for this purpose? How about the MySQL Control Center?
I have tried to search for an answer, but mostly for
the unix system. Is there any simple solution since I
am not a programmer?
Terence
I set up two-way replication with two servers, A and B.
Since all queries go to only one server, it seems not to matter.
Anyway.
When A starts it registers itself to B, and vice versa.
I thought query "SHOW SLAVE HOSTS" to A should shows only about
B and B should do about A, but both show the sa
Hi there,
Does any of you know of a utility to pretty print mysql table
structures? I have a pretty big and messy DB I need to work on, and I
would like to be able to print the table structures with nice tables.
Any pointers
* tmb
> I'm Running RedHat Linux 7.3 - Apache - MySQL &
> scripting with PHP on an Intel box...
>
> Question 1:
> I want to print a specified field or fields, in
> specified records of an mysql db to the line printer
> several times a day...
OK, let's see if
Sorry for the resubmission but I thought I would try
again to get a tip on how to do this. I am a newbie,
so thanks for any help.
I'm Running RedHat Linux 7.3 - Apache - MySQL &
scripting with PHP on an Intel box...
Question 1:
I want to print a specified field or fields, in
specifie
I'm a newbie, so thanks for any help.
Running RedHat Linux 7.3 - Apache - MySQL & scripting
with PHP on an Intel box...
Question 1:
I want to print a specified field or fields, in
specified records to the line printer several times a
day...
Can anyone get me started on the PHP scr
27;list' at the
>SQL*Plus prompt and see a printout to STDOUT (the screen) of the
>current command in the buffer. Apparently, mysql duplicates this
>functionality via the 'print' and/or '\p' function. However, even if
>I have an SQL statement in memory, when I
UT (the screen) of the current command in the buffer.
Apparently, mysql duplicates this functionality via the 'print' and/or '\p'
function. However, even if I have an SQL statement in memory, when I type
in this command at the mysql prompt, it simply prints the following:
mysql&g
print them to a log file, and
tail -f logfile
from another window.
Fei Chen wrote:
>Dear all,
>
>I'm trying to write some UDFs and it will help a lot if I can print
>debugging information out directly to the screen so I can see what's going
>on. But printf() etc do
Dear all,
I'm trying to write some UDFs and it will help a lot if I can print
debugging information out directly to the screen so I can see what's going
on. But printf() etc does not print to the mysql client screen. Is there
an easy work around?
Thanks for any
Hello all,
I'm rather new with MySQL. I'm running Linux SuSE 7.1 and try to convert
from MSAccess to MySQL. In MSA I have created a query to select persons
who have to get a bill. I connected this query to a report and
automatically a bill is printed on my Epson printer. Doing this saves me
a
Jule Slootbeek [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 6:39 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: print on top
Hey guys and gals,
I'm writing this script for my new webpage, and i'm using MySQL to read and
add news articles to a page, but everytime
In the last episode (Apr 17), Mike said:
> use ORDER BY ASC or DESC
>
> $Query = "SELECT * from $TableName ORDER BY DESC";
"ORDER BY postdate DESC", you mean? :)
--
Dan Nelson
[EMAIL PROTECTED]
-
Before postin
Sent: Wednesday, April 17, 2002 6:45 PM
Subject: Re: print on top
> use ORDER BY ASC or DESC
>
> $Query = "SELECT * from $TableName ORDER BY DESC";
>
> Mike
> - Original Message -
> From: "Jule Slootbeek" <[EMAIL PROTECTED]>
> To: <[
use ORDER BY ASC or DESC
$Query = "SELECT * from $TableName ORDER BY DESC";
Mike
- Original Message -
From: "Jule Slootbeek" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, April 17, 2002 6:38 PM
Subject: pri
= "SELECT * from $TableName";
$Result = mysql_db_query ($DBName, $Query, $Link);
while ($Array = mysql_fetch_array ($Result)) {
print ("");
print ("\n");
print ("$Array[header]\n");
print ("\n");
print (&q
Hi.
On Thu, Feb 28, 2002 at 07:39:04PM -0500, [EMAIL PROTECTED] wrote:
> Is there any way to print (to a printer) an ORDERed SElECT directly from
No. MySQL is an RDBMS, not an printing tool.
> MySQL without the use of scripting or programming?
Well depends on how you define this..
Is there any way to print (to a printer) an ORDERed SElECT directly from
MySQL without the use of scripting or programming?
Rich
--
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the
Theo,
Wednesday, February 20, 2002, 6:37:15 PM, you wrote:
TVS> Hello,
TVS> I am new with MySQL and have it running on Windws 2000 server and
TVS> programming with VC++ 6.0
TVS> Now converting from SQL 7.0 to MySQL
TVS> I wonder if there is a way to print out the data struct
Hello,
I am new with MySQL and have it running on Windws 2000 server and
programming with VC++ 6.0
Now converting from SQL 7.0 to MySQL
I wonder if there is a way to print out the data structure of the table in
MySQL?
Regards
Theo van Stratum
Albanet Ltd
(Technical Manager, Senior Programmer
from php
>application) that the icon has link to mysql and the result directly print
>the out put to printer (share or local printer) by coulomb.
>
>there's anyone knows about this, please help me.
>
>Rgds,
>
>Franky Aniversarius
>
>
>
>
meyer" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 07, 2002 3:52 AM
Subject: Fw: Print file
Hi all
How can I take info from one table and print it into a txt file.
the table is (NAME)
and all the names in it I want to print out to a file name
Hi Christo,
> How can I take info from one table and print it into a txt file.
> the table is (NAME)
> and all the names in it I want to print out to a file name virtusertable.
Would SELECT ... INTO OUTFILE 'file_name' suit you?
(MySQL manual: 6.4.1 SELECT Sy
Christo,
Thursday, February 07, 2002, 11:52:06 AM, you wrote:
CR> Hi all
CR> How can I take info from one table and print it into a txt file.
CR> the table is (NAME)
CR> and all the names in it I want to print out to a file name virtusertable.
See info about mysqldump: http://w
when i click the icon client1(in end client, it's show up from php
application) that the icon has link to mysql and the result directly print
the out put to printer (share or local printer) by coulomb.
there's anyone knows about this, please help me.
Rgds,
Franky An
Hi all
How can I take info from one table and print it into a txt file.
the table is (NAME)
and all the names in it I want to print out to a file name virtusertable.
Thanx
Christo
sql,query
-
Before posting, please
Christo,
Thursday, February 07, 2002, 11:52:06 AM, you wrote:
CR> Hi all
CR> How can I take info from one table and print it into a txt file.
CR> the table is (NAME)
CR> and all the names in it I want to print out to a file name virtusertable.
See info about mysqldump: http://w
meyer" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 07, 2002 3:52 AM
Subject: Fw: Print file
Hi all
How can I take info from one table and print it into a txt file.
the table is (NAME)
and all the names in it I want to print out to a file name
Hi Christo,
> How can I take info from one table and print it into a txt file.
> the table is (NAME)
> and all the names in it I want to print out to a file name virtusertable.
Would SELECT ... INTO OUTFILE 'file_name' suit you?
(MySQL manual: 6.4.1 SELECT Sy
Hi all
How can I take info from one table and print it into a txt file.
the table is (NAME)
and all the names in it I want to print out to a file name virtusertable.
Thanx
Christo
sql,query
-
Before posting, please
when i click the icon client1(in end client, it's show up from php
application) that the icon has link to mysql and the result directly print
the out put to printer (share or local printer) by coulomb.
there's anyone knows about this, please help me.
Rgds,
Franky An
TED]
Subject: Re: print database schema
Hello
more of a visual tool. The program I did see had views of all the tables
as if you had done a "describe table_name" for each table, then had lines
linking the relationships between tables (similar to what you can view in
Access , even th
Fax: (632) 634-5139
- Original Message -
From: "Steven Wren" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, January 29, 2002 12:42 PM
Subject: print database schema
> Hello
>
> I was wondering if anyone knew of a program that would allow you to print
y stranger than we suppose,
it is stranger than we can suppose.
-J.B.S. Haldane
On Tue, 29 Jan 2002, Paul DuBois wrote:
> At 14:42 +1000 1/29/02, Steven Wren wrote:
> >Hello
> >
> >I was wondering if anyone knew of a program that would allow you to print
>
At 14:42 +1000 1/29/02, Steven Wren wrote:
>Hello
>
>I was wondering if anyone knew of a program that would allow you to print
>out a complete database. I have seen it on a PostGre DB, so I am sure
>MySQL should have something...
You mean mysqldump --no-data db_name ?
>
&
Hello
I was wondering if anyone knew of a program that would allow you to print
out a complete database. I have seen it on a PostGre DB, so I am sure
MySQL should have something...
cheers!
Regards,
___
Steven Wren
[EMAIL PROTECTED]
http://www.server101.com
Webhosting and E-commerce
: [EMAIL PROTECTED]
Subject: print LABELS or ENVELOPES with DATA from MySQL
Dear List,
As I don't seem to get MySQL data from my server to my local drive into
word, where I would be printing envelopes for a mailing, I wonder what
other options are out there?
I can easily get the data into
ef=96
-Original Message-
From: Peter Reck [mailto:[EMAIL PROTECTED]]
Sent: 29 December 2001 09:56
To: [EMAIL PROTECTED]
Subject: print LABELS or ENVELOPES with DATA from MySQL
Dear List,
As I don't seem to get MySQL data from my server to my local drive into
word, where I would b
Dear List,
As I don't seem to get MySQL data from my server to my local drive into
word, where I would be printing envelopes for a mailing, I wonder what
other options are out there?
I can easily get the data into EXCELbut I haven't figured out if
EXCEL prints envelopes or labels? Wh
At 2:14 PM -0400 9/12/01, Jeremy Morano wrote:
>I am having a hard time printing
>
>Select * from table_1 \p;
>
>
>the result is:
>
>--
>Select * from table_1
>--
>
>.
>.
>.
>
>But it doesn'
I am having a hard time printing
Select * from table_1 \p;
the result is:
--
Select * from table_1
--
.
.
.
But it doesn't print.
Anyone?
-
Before posting, p
At 3:18 PM -0400 9/10/01, Jeremy Morano wrote:
>Hi,
>
>very simple question.
>
>I would like to save and print the contents of myDESCRIBE table_1;
>
>How would I do this?
Use the --tee option to mysql to create a tee file that serves as a log of
your session, an
Jeremy Morano wrote:
>
> Hi,
>
> very simple question.
>
> I would like to save and print the contents of myDESCRIBE table_1;
>
> How would I do this?
Jeremy:
mysql -e 'DESCRIBE table_1;' | lp
Regards,
Van
--
=
Hi,
very simple question.
I would like to save and print the contents of myDESCRIBE table_1;
How would I do this?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
varchar(20)
=>col2 varchar(20)
=>when I add content to the columns it looks like
=>this for example:
=>col1
=>
=>contentA
=>NULL
=>contentB
=>
=>Now when I try to print out the content in Perl
=>using this code:
=>
=>while($dirty_words =
I have created 2 columns:
col1 varchar(20)
col2 varchar(20)
when I add content to the columns it looks like
this for example:
col1
contentA
NULL
contentB
Now when I try to print out the content in Perl
using this code:
while($dirty_words = $sth->fetchrow_array) {
print "$dirty
79 matches
Mail list logo
