473,809 Members | 2,791 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

dump data outfile????

hi,

is there a way to dump just data to a file similar to the way "load data
infile" reads data?

tia,
peter

Jul 20 '05 #1
2 2195
hi

yes, there is:

select * from <file> into outfile "file.out";

picaza wrote:
hi,

is there a way to dump just data to a file similar to the way "load data
infile" reads data?

tia,
peter


--
pexi

Outoa, kaikki älykkäät ihmiset ovat samaa mieltä kanssani.

Jul 20 '05 #2


pekka wrote:
select * from <file> into outfile "file.out";


thanks,
i also found the "dump" function in the perl DBI mod.

peter

Jul 20 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
6819
by: Ravi Tallury | last post by:
Hi We are having issues with our application, certain portions of it stop responding while the rest of the application is fine. I am attaching the Java Core dump. If someone can let me know what the issue is. Thanks Ravi
4
13299
by: Hoang | last post by:
does anyone know how to dump the table structure and data from a mysql database? I am connected to the database externally so "SELECT * FROM database INTO OUTFILE file" doesn't work for me. However, external tools have been able to do it (Mascon). I presume this might be a common thing where people need to backup their databases programatically from MySQLdb. Hoang Do http://jotsite.com
1
4763
by: Joan | last post by:
I read RAW image data from a binary file stream. I have to read just bytes one by one and put them into a matrix of structs of unsigned chars. I have to use unsigned chars because their rangs go from 0 to 255. If I use chars then a value of 129 will be -128 :( The problem: infile.get(ImageDATA.R);
13
1338
by: Robert S | last post by:
hello, I am investigating a code,which has data struct deelacration as follow: typedef struct { char *infile; char inoptsbuf; char *outfile; } cmdoption_a; cmdoption_a *cmdoption;
1
1938
by: Mark Spruill | last post by:
This is probably a newbie question but here goes: We are using Postgres 7.3 on Red Hat 9. We are doing dumps with a script that does: pg_dump databasename > outfile 2>> logfile The resulting dump files occasionally have a \N at the end of a line of data following the copy command. This causes a problem when I try to load them back in bacause psql thinks the \N (a new line character?) is a psql command. So, how do I avoid the \N in...
0
1660
by: wuzertheloser | last post by:
Define the file-pointers *Infile and *Outfile and link them to a given input file Sale.dat (which is in the homework/directory) and the output file Comm.dat (which you will create in this assignment). Use while(fgets()!=NULL) to read all the lines in Sale.dat. For odd number lines (containing full names) sscanf name and surname, print the full name on the screen and in the output file Comm.dat. For even number lines (with amount of sale),...
7
1794
by: rhitz1218 | last post by:
All: I'm trying to create a log file. I now I can be able to do that by doing the following: FILE *outfile; outfile = fopen("log.txt", "w"); fprintf("This is the text");
14
3365
by: Sheldon | last post by:
Hi, I have a python script that uses a C extention. I keep getting a recurring problem that causes a core dump a few lines after the C extention return data back tp python. I tried using pbd and gdb but I have not succeeded in understanding what went wrong and where. I post the python script here is the error message and gdb output after reading the core file: ...... printout from with C extention.... Completed freeing 2D arrays.
1
1571
by: gator6688 | last post by:
I need to be able to save my additional data to my .dat file. The additional data is not part of the vector though. It is data I made after the vector. I have to save the finalGrade and letter grade to my file.Also, how can I save my letter grade to my file when I didn't actually name it that? #include "stdafx.h" #include <iostream> #include <fstream> #include <string> #include <cstdlib> #include <iomanip> #include <cmath> #include...
0
9721
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9601
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10376
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
7653
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6881
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5550
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5687
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4332
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3861
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.