mysqldump dbname.tablename filename.txt
Cheers, Andy
Raymond Lilleodegard [EMAIL PROTECTED] schrieb im Newsbeitrag
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Hi!
I would like to make a txt file our from some db output, is this possible?
Couldn't find anything about it in the function
May I use this dump method with a query too? Or is this only for making a
hole table into a txt file?
Because I'm trying to get a website into a txt file and save it into a
directory on the server to get a order sendt by fax. Or is this a long way
to go?
Regards Raymond
Andy [EMAIL PROTECTED]
Hi there,
I did just do a procedure anlyse to my table and figured out that the best
type would be enum.
I tryed:
ALTER TABLE `test` CHANGE `field` `field` ENUM
but I am getting an error: You have an error at your sql sytax at
Is this column type even possible, because I have over 2million
On Saturday 06 April 2002 19:34, Pedro M.S. Oliveira wrote:
Hi all ;)
usually i just use mysql with php, but this time i will need to access
an oracle database, knowing oracle is not a problem, but i'm searching
for a DB abstraction layer that is tested and working.
as i never used this
Hi All
I have a dynamic drop down list that work perfectly.
But what I would like to do is when a user selects where to got
That the selection is shown on the next page as the selected item.
And if they change this selection that it is then shown as the selected
item.
Any pointers of
mysql_error returns the resultant error (if any) of the most recent sql
call on a particular db connection. In other words, if 2 users are
querying the db at the same time, mysql_error returns the most recent
error generated in their _respective_ connections.
Carl
--
PHP Database Mailing
I recently posted a question regarding connecting to a TNS service from PHP.
I had been getting the error TNS operation timed out from PHP while
connecting via sqlplus worked perfectly fine.
If I was not using a TNS alias from PHP but a real connect string such as
It is. You can override it in the conf file however.
Later,
Bob
- Original Message -
From: Florian Clever [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, April 06, 2002 5:33 PM
Subject: [PHP-DB] tnsnames.ora + Apache symbolic links
I recently posted a question regarding
On 4/6/02 4:12 PM, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
From: Raymond Lilleodegard [EMAIL PROTECTED]
Date: Sat, 6 Apr 2002 17:18:07 +0200
To: [EMAIL PROTECTED]
Subject: Re: Making a txt file from db data, is it possible?
May I use this dump method with a query too? Or is this only
Hi All,
I'm just starting on a database to track IP addresses. I'm thinking about
how best to store the IP address - 4 tinyints, varchar or char; as one big
varchar or 4 chunks?
We will eventually want to look at things by net or subnet and being able to
search on the various parts of the
On Sunday 07 April 2002 12:01, Jennifer Downey wrote:
Hi all,
This code is working greate except for one minor bug.
If I have 2 or 3 items at different prices buy.php is updating the points
of the user at the last priced item.
In other words if
item 1 costs 1965
item 2 costs 564
item 3
I am trying to write a simple login script, and I am new to PHP. Here is
what I have so far:
?php
$stmt = $HTTP_POST_VARS['ssn'];
$oerr = OCIError();
$dbconn = OCILogon(user, pass, database);
$search = ociparse($dbconn, select GURMAIL_PIDM from GENERAL_GURMAIL
where GURMAIL_PIDM =
On Sunday 07 April 2002 13:41, Pusta wrote:
I am trying to write a simple login script, and I am new to PHP. Here is
what I have so far:
?php
$stmt = $HTTP_POST_VARS['ssn'];
$oerr = OCIError();
$dbconn = OCILogon(user, pass, database);
$search = ociparse($dbconn, select GURMAIL_PIDM
What is the syntax to input a field from a form into an oracle using PHP?
Can anyone help?
Pusta
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
I cannot check the ssn against the database. ociparse returns true if the
query was successful and ociexecute does the same. What do I have to check
the true value of I guess is my main question.
Pusta
Jason Wong [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]...
On Sunday 07 April
On Sunday 07 April 2002 15:20, Pusta wrote:
I cannot check the ssn against the database. ociparse returns true if the
query was successful and ociexecute does the same. What do I have to check
the true value of I guess is my main question.
I've never used the Oracle functions before but the
It's late and I'm getting groggy.
I have a table called mail_list. There are four possible list_names.
I want to be able to either delete an email associated with a particular
list or all matching email.
Deleting WHERE email AND list match works fine. The problem is when I want
to delete an
17 matches
Mail list logo