Hello,
mysqli_debug will help you, I think.
See: http://php.chinaunix.net/manual/zh/function.mysqli-debug.php
Joeri
On Tue, Oct 20, 2009 at 5:26 PM, Chris W <4rfv...@cox.net> wrote:
>
> I know this is more a PHP question but no one on the list at news.php.net is
> responding. So I was hoping s
I know this is more a PHP question but no one on the list at
news.php.net is responding. So I was hoping someone here might know.
If I am using the mysqli extension and prepared statements, after I
execute bind_param, is there a away to print the actual query that gets
sent to the server? I h
On Wed, May 9, 2007 04:06, Stephen Cook wrote:
> I think that offering some sort of feedback other than result sets would
> be nice for debugging.
And it makes perfect sence to get this debug information in
postscript format :D
>
> Peter Brawley wrote:
>> >I hope this isn't a silly question, or
I think that offering some sort of feedback other than result sets would
be nice for debugging.
Peter Brawley wrote:
>I hope this isn't a silly question, or something covered in a FAQ. . .
>but is there any reason to not have at least some primitive print
>formatting commands in MySQL? Or a
>I hope this isn't a silly question, or something covered in a FAQ. . .
>but is there any reason to not have at least some primitive print
>formatting commands in MySQL? Or am I missing something
>blindingly obvious?
I think the idea is that RDBMS ought to stick to what is necessary for
RDBMS m
I hope this isn't a silly question, or something covered in a FAQ. .
.but is there any reason to not have at least some primitive print
formatting commands in MySQL? Or am I missing something blindingly obvious?
Barry
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/
Hello.
It is not clear for what does it mean without printing the result. Could
you provide an example. If you don't want the variable to be in the
column listing you can use such a technique:
select * from ab where @variable:=1 and (other conditions).
Do not forget about SET syntax (it do
Hi,
Can someone tell me how to assign result to a variable
inside SELECT without printing the result?
Thanks,
Jacek
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> About Access I can only say that it's very useful tool for a lot of
> people and there is a lot of places where it makes perfect sense to
> use Access. I don't claim it's a perfect reporting tool for all kind
> of reports, but depending on the requirements it may be the right tool
> for a specif
Hi!
> "Haydies" == Haydies <[EMAIL PROTECTED]> writes:
Haydies> Access is not a Database, its a kiddies toy.
Haydies> You can just as easlily make your reports using crystal reports or any thing
Haydies> else like that if you really want to, or PHP/ASP
Haydies> Now, please, for sug
ful (if this helps you, please let me know)
Thanks
Emery
- Original Message -
From: "Wang Feng" <[EMAIL PROTECTED]>
To: "Director General: NEFACOMP" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Wednesday, October 08, 2003 1
uch.
- Original Message -
From: "Andy Eastham" <[EMAIL PROTECTED]>
To: "Mysql List" <[EMAIL PROTECTED]>
Sent: Wednesday, October 08, 2003 12:29 PM
Subject: RE: printing reports
: Please take this flame war off list.
:
--
MySQL General Mailin
Sent: Wednesday, October 08, 2003 9:42 PM
Subject: Re[2]: printing reports
> >> 1.) If you want to have an "easy way tool" for creating your reports -
> >> use MS Access
> Yep if you know Access
>
> WF> -- Tools are for dummy users, Clever users create
>> 1.) If you want to have an "easy way tool" for creating your reports -
>> use MS Access
Yep if you know Access
WF> -- Tools are for dummy users, Clever users create tools. --
Clever users select the best way they can do things for themselves
What is best depends on user knowledge and objective
t: Wednesday, October 08, 2003 9:29 PM
Subject: RE: printing reports
> Please take this flame war off list.
> > -Original Message-
> > From: Wang Feng [mailto:[EMAIL PROTECTED]
> > Sent: 08 October 2003 11:31
> > To: Michael Haunzwickl; 'Dire
Please take this flame war off list.
> -Original Message-
> From: Wang Feng [mailto:[EMAIL PROTECTED]
> Sent: 08 October 2003 11:31
> To: Michael Haunzwickl; 'Director General: NEFACOMP';
> [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: printing reports
CTED]>;
<[EMAIL PROTECTED]>
Sent: Wednesday, October 08, 2003 11:32 AM
Subject: Re: printing reports
: > So listen guy, this is a big miss understanding:
:
: NO
:
:
: > 1.) If you want to have an "easy way tool" for creating your reports -
: > use MS Access
:
: He
i maybe see
> later as a little bit to "unfriendly" ... I will stop this email now.
I was just joking, no worries. :-)
> My tip for you: TAKE MS ACCESS TO CREATE YOUR REPORTS ... Or ... IF YOU
> WANT TO HAVE A REAL GOOD REPORTING TOOL ... TAKE CRYSTAL REPORT.
Now seriously, thank
i maybe see
> later as a little bit to "unfriendly" ... I will stop this email now.
I was just joking, no worries. :-)
> My tip for you: TAKE MS ACCESS TO CREATE YOUR REPORTS ... Or ... IF YOU
> WANT TO HAVE A REAL GOOD REPORTING TOOL ... TAKE CRYSTAL REPORT.
Now seriously, th
CESS TO CREATE YOUR REPORTS ... Or ... IF YOU
WANT TO HAVE A REAL GOOD REPORTING TOOL ... TAKE CRYSTAL REPORT.
Michael
-Ursprüngliche Nachricht-
Von: Wang Feng [mailto:[EMAIL PROTECTED]
Gesendet: Mittwoch, 8. Oktober 2003 11:52
An: Michael Haunzwickl; 'Director General: NEFACOMP
chael Haunzwickl" <[EMAIL PROTECTED]>
To: "'Director General: NEFACOMP'" <[EMAIL PROTECTED]>; "'Wang Feng'"
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, October 08, 2003 6:03 PM
Subject: AW: pr
gt;; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, October 08, 2003 6:03 PM
Subject: AW: printing reports
> Well, it seems to me, that he is looking for some replacement of "oracle
> reports" ... Which is ... As far as i know ... Something like "MS
>
> Unfortunately, they have not implemented a reporting tool in that client.
that's the problem, as I was trying to find some sql commands to edit the
report, such as report titles.
>Do you know some programming language? Like Visual Basic, C, C++, Java,
PHP,
i know them, but as I mentioned ear
ber 2003 09:52
An: Wang Feng; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Betreff: Re: printing reports
Some are free, others are commercial.
But, note that most of these are mainly for administration purposes. For
example phpMyAdmin is a free PHP based client.
Do you know some programming language? Like Visu
: "Director General: NEFACOMP" <[EMAIL PROTECTED]>
Sent: Tuesday, October 07, 2003 22:38
Subject: Re: printing reports
> Hi, Emery
>
> What do you mean client software? I just downloaded the MySQL server and I
> can insert data to the database and select the data from d
ot;Wang Feng" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, October 08, 2003 1:10 AM
Subject: RE: printing reports
> You can, via ODBC, connect to MySQL using OpenOffice or Star Office which
> would give you a no-cost, or low-cost, option for producing repor
eat!!!
cheers,
feng
- Original Message -
From: "Rudy Metzger" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, October 08, 2003 1:00 AM
Subject: RE: printing reports
>
> You can use the mysql command client, it that is what you mean. You can
>
ve [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 07, 2003 11:11 AM
To: Wang Feng; [EMAIL PROTECTED]
Subject: RE: printing reports
You can, via ODBC, connect to MySQL using OpenOffice or Star Office which
would give you a no-cost, or low-cost, option for producing reports from
MySQL. There are a
-
From: Director General: NEFACOMP [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 07, 2003 9:49 AM
To: Wang Feng; [EMAIL PROTECTED]
Subject: Re: printing reports
To get data from/into MySQL, you will always need a client software. So, the
reporting thing should be implemented in your client
ou can
always hack the DB :)
cheers
/rudy
-Original Message-
From: Director General: NEFACOMP [mailto:[EMAIL PROTECTED]
Sent: dinsdag 7 oktober 2003 16:49
To: Wang Feng; [EMAIL PROTECTED]
Subject: Re: printing reports
To get data from/into MySQL, you will always need a client software.
S
ROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, October 07, 2003 12:22
Subject: Re: printing reports
> > In MySQL, how can I create and print reports without the help of neither
a
> > scripting language(e.g. php) nor a thrid party software tool?
>
> bad gra
> In MySQL, how can I create and print reports without the help of neither a
> scripting language(e.g. php) nor a thrid party software tool?
bad grammar :-( but you guys understand what i'm saying, right? :-)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To uns
Greetings,
In MySQL, how can I create and print reports without the help of neither a
scripting language(e.g. php) nor a thrid party software tool?
I just couldn't find any commands for the printing function in MySQL.
Please advise. And please let me know how you print reports.
cheers,
Hi Vince,
I assume you want to print to your printer from the mysql client (command
line) here is what I do:
0) set up a lp queue (line printer) and make sure it works then proceed to 1)
1a) mysql> pager /usr/bin/less
mysql> \P lp;
PAGER set to lp;
mysql> SHOW INNO
I am new to SQL and was wondering if there was a query that would allow
me to print to my printer. I have tried the TO PRINTER, TO FILE, |lpr,
and others, but get the syntax error. I am running MySQL on a WIndows XP
Home system. My company has asked me to transfer a clients file to forms
for pr
he description of all tables in my database. The problem
> > is, there are about 200 of them, and the only way I know to do this is
> > send each of the screens to a file, an then print the file. Isn't there
> > any easier way, like printing directly from mysql or at least sav
Hi Gerald,
How about like this ?
mysql> \P lp;
PAGER set to lp;
mysql> SHOW INNODB STATUS ;
lp is the printer queue which you have probably setup. Exchange lp with your
printer spooler name. I am not sure about printing several tables. How about
making a script or batch file (in ca
7;t there any easier way, like printing
> directly from mysql or at least saving all descriptions to the file at once??
>
Hi,
Try:
mysqldump -d -u user -p database-name
regards,
Martin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:htt
Hi!
I need to print the description of all tables in my database. The problem is, there
are about 200 of them, and the only way I know to do this is send each of the screens
to a file, an then print the file. Isn't there any easier way, like printing directly
from mysql or at least savin
set to lpr -P _192_168_0_11
mysql> select * from phone;
6 row in set (0.08 sec)
mysql \n
It sends output to the screen again. Use it when you want to stop
sending
all of that output to the printer.
--
Happy printing,
Richard-
I am just starting to use mysql and I need some help on probably some
simple items
I have created a database and now I want to just do a simple query and
display the results on the screen and that is where I am having the
trouble. How do I get it to print the variables on the webpage.
Thanks
Rya
s and everything you see in the screen.
> See:
> http://www.mysql.com/doc/m/y/mysql.html
>
> Gurhan
>
> -Original Message-
> From: colin o [mailto:[EMAIL PROTECTED]]
> Sent: Friday, April 05, 2002 4:14 PM
> To: mysql
> Subject: printing the database
>
>
: mysql
Subject: printing the database
Hi,
Is it possible to print a table from the database in
the same format as you can see it. I tried to export a
table to an outfile, but i dont get the column names.
I am using Linux so i don't have a print screen
option,
I think you can do using a sof
Hi,
Is it possible to print a table from the database in
the same format as you can see it. I tried to export a
table to an outfile, but i dont get the column names.
I am using Linux so i don't have a print screen
option,
I think you can do using a software package called
EMS MySQL Manager, but
Hello all.
I am running mysql 3.x on Redhat Linux, and Solaris 2.6 and 8
Most of the development work is done on these servers.
I do have a couple of windows developers using tools like mysqlfront
Is there way with mysql to print out table structure in a useable text format or maybe
even a gr
On Mon, 28 Jan 2002, David S. Jackson wrote:
> I'm just starting my first MySQL db, and I'm going to want to
> print out reports from it and produce a camera-ready document.
> Has anyone done this before, using, say, Star Office or AbiWord
> or something?
David,
I go this way for high quality o
On Mon, 28 Jan 2002, David S. Jackson wrote:
> I'm just starting my first MySQL db, and I'm going to want to
> print out reports from it and produce a camera-ready document.
> Has anyone done this before, using, say, Star Office or AbiWord
> or something?
David,
I go this way for high quality o
A "camera-ready document" is what is sent to a printing service. The
print-out may have crop marks or color information.
bb
-Original Message-
From: Andrew Gould [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 28, 2002 12:35 PM
To: David S. Jackson; [EMAIL PROTECTED];
[EMAIL
Camera ready means the a commercial printer cn go direct from the
provided document(s) to negatives/plates or direct to plate without
having to modify the originals in any way.
Save a lot of money in make up and AA charges.
Jack
Andrew Gould wrote:
>
> Please forgive my ignorance; but what is
Andrew Gould writes:
> Please forgive my ignorance; but what is a
> "camera-ready document"?
>
> Andrew
>
That is easy :
A document that looks so nice that you can spare one shot on it.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROT
Please forgive my ignorance; but what is a
"camera-ready document"?
Andrew
--- "David S. Jackson" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I'm just starting my first MySQL db, and I'm going
> to want to
> print out reports from it and produce a camera-ready
> document.
> Has anyone done this before
Hi,
I'm just starting my first MySQL db, and I'm going to want to
print out reports from it and produce a camera-ready document.
Has anyone done this before, using, say, Star Office or AbiWord
or something?
TIA.
--
David S. Jackson[EMAIL PROTECTED]
=-=-=-=-=-=-=-=-=-=
i am creating a database in linux redhat 7.2. i cannot figure out how to
print my tables..or anything in mysql for that matter...i did not find
anything in the documentation..have i overlooked something..
-
Before posting, plea
"Wix,Christian XCW" wrote:
> Hi!
>
> How print the result from a query on my printer? I'm using the command line
> on linux.
> Lets say that I want to print everything from the table "Mercedes" in the
> database "Cars".
Pipes.
> How do I adjust the lenght of the lines?
man nenscript
Basically
Hi!
How print the result from a query on my printer? I'm using the command line
on linux.
Lets say that I want to print everything from the table "Mercedes" in the
database "Cars".
How do I adjust the lenght of the lines?
// Christian
---
Hi,
how can I print the results of my database querys?
MySQl is running local on my Linux System.
regards
Frank Steffen
e-Mail: [EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manu
56 matches
Mail list logo
