date_of_youngest_le" and the VALUE of that
variable is shown only as "1990", NOT the correct value, which is
"1990-05-11". The danger is that it is not obvious that the value
of the variable has been truncated. When I first encountered this,
I thought I'd written the
e information is
truncated. For example the value shown for the second variable name
is shown as "birthdate_of_youngest_le" and the VALUE of that
variable is shown only as "1990", NOT the correct value, which is
"1990-05-11". The danger is that it is not obvious tha
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
_of_youngest_le" and the
VALUE of that variable is shown only as "1990", NOT the correct
value, which is "1990-05-11". The danger is that it is not obvious
that the value of the variable has been truncated. When I first
encountered this, I thought I'd written t
e shown for the
second variable name is shown as "birthdate_of_youngest_le" and the
VALUE of that variable is shown only as "1990", NOT the correct
value, which is "1990-05-11". The danger is that it is not obvious
that the value of the variable has been truncated.
. The danger is that it is not obvious that the value of the
variable has been truncated. When I first encountered this, I thought
I'd written the date_sub() function incorrectly and messed around with
it for awhile before I discovered the truncation problem. Therefore, my
technique is to al
that
variable is shown only as "1990", NOT the correct value, which is
"1990-05-11". The danger is that it is not obvious that the value of the
variable has been truncated. When I first encountered this, I thought I'd
written the date_sub() function incorrectly and messed ar
s a string. Can include concatenated literal values
and variables. The message string can be up to 8,000 characters long; any
characters after 8,000 are truncated.
-Original Message-
From: Rhino [mailto:[EMAIL PROTECTED]
Sent: Thursday, 11 May 2006 3:51 p.m.
To: Stephen Cook
Cc: MySQL
lternative.
--
Rhino
- Original Message -
From: "Stephen Cook" <[EMAIL PROTECTED]>
To: "Rhino" <[EMAIL PROTECTED]>
Cc: "MySQL List"
Sent: Wednesday, May 10, 2006 8:09 PM
Subject: Re: PRINT statement?
I've started using the SELECT with no
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:53 AM
Subject: PRINT statement?
Is
- 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.
If you're talking about a scr
mysql db -e "select * from test3;" | lpr
Assuming Linux / UNIX, you have a line printer defined and db is the database to
connect to.
Van
--
=
Linux rocks!!! http://www.dedserius.com/
==
At 11:58 -0500 9/19/02, Robert Fox wrote:
>Hello-
>
>I've just started using MySQL so this is absolutely a 'newbie'
>question. I'm used to working with Oracle's SQL*Plus which is a very
>different tool. In SQL*Plus, I could type 'l' or 'list' at the
>SQL*Plus prompt and see a printout to STDOUT
Hi Jule,
You need to sort your records with "ORDER BY" clause . I don't know what
your table looks like and obviously don't know if you have suitable columd
for it.. Say you have a newsid field defined with int datatype with
auto_increment property, then you can issue your statement as "SELECT ..
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
Sorry, I forget the column name for the ORDER BY
> $Query = "SELECT * from $TableName ORDER BY column_name DESC";
Mike
- Original Message -
From: "Mike" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; "Jule Slootbeek" <[EMAIL PROTECTED]>
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: print on top
> Hey guys and gals,
> I'm writing
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...
You didn't
Christo:
Write a query that does what you want to a text file called
virtusertable.sql:
USE databasename;
SELECT name FROM tablename;
Then run the query from the command line (mysql -uusername -p
databasenamevirtusertable.txt)
Gerald Jensen
- Original Message -
From: "Christo Rademeyer"
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 Syntax)
Regards,
=dn
---
Christo:
Write a query that does what you want to a text file called
virtusertable.sql:
USE databasename;
SELECT name FROM tablename;
Then run the query from the command line (mysql -uusername -p
databasenamevirtusertable.txt)
Gerald Jensen
- Original Message -
From: "Christo Rademeyer"
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 Syntax)
Regards,
=dn
---
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
You can run mysqldump from the command line, if you only want the schema you
can do:
mysqldump -u username databasename -d -p > my.dump
man mysqldump to see more options.
or if you want you can try phpmyadmin at
http://www.phpwizard.net/projects/phpMyAdmin/ it is a web based admin tool
for mysq
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 though i hate to admit I have used it :)
would just be
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 ?
>
>cheers!
>
>Regards,
>
>
Peter,
You can create a link to M$ Access or M$ Excel via ODBC and then use this in
your M$ Word as a MailMerge data source.
There is no option in Word to use an ODBC data source.
HTH
Norman
-Original Message-
From: Peter Reck [mailto:[EMAIL PROTECTED]]
Sent: 29 December 2001 09:56
To:
Peter
I suggest getting hold of the MyODBC drivers (you'll find reference to it in
the mysql manual)
Once installed you can attached to mysql tables in MS Access, then use the
report wizard in there to create your labels or if you are more confortable
in word you can open the access mdb file wit
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't print.
>
>Anyone?
Define what you mean by "print".
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, and issue the statement interacti
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
--
=
Linux rocks
This is a question for PERL group but anyhow, read again the chapter in MySQL
on printing results from MySQL using PERL. It prints continentA because
that's what you have asked for.
On Sunday 11 February 2001 15:36, Andreas Antes wrote:
=>I have created 2 columns:
=>col1 varchar(20)
=>co
32 matches
Mail list logo
