what about the file size.
My file size is 10 mb.
When I dump them all with LOAD DATA INFILE I only get first 9800 raws which
is size of 2.9 mb.
Is there a limit for file size? Where can I increase it?
Regards..
- Original Message -
From: "Victor Pendleton" <[EMAIL PROTECTED]>
To: "Fe
Hello,
I am converting my database from oracle to mysql4.1 and i want the same
structure as it is oracle like primary key and foreign key references etc..
In oracle i have created my primary key and foreign key references on a varchar
datatype column, so can any one help me in doing the same i
Hi!
I have a problem that may only be solvable using a programming approach, but
I'm wondering if there is an SQL method in MySQL.
The problem is that I have a table that looks like this:
CREATE TABLE `test` ( `uid` mediumint(6) NOT NULL auto_increment,
`perid` varchar(10) default NULL, `pro
You can load the file to an intermediate table and then complete your
process using
INSERT INTO targetTable
SELECT col_1, col_5, col_28, col_71
FROM intermediateTABLE
Ferhat BINGOL wrote:
Hi,
I have a 72 fields data txt file and I was inserting all data previously
but now I need only some of them
Hi,
I have a 72 fields data txt file and I was inserting all data previously but
now I need only some of them to dump into the table.
I would like to select only 4 fields which are the 1st, 5th,28th and 71st
fields.
Is there a statement to do that.
I have read http://dev.mysql.com/doc/mysql
GH wrote:
I have the following query:
SELECT A.`AttID` , S.`SessionDate` , P.LastName, P.FirstName, A.`Present`
FROM `Attendance` A, Sessions S, Participants P
WHERE S.SessionID = A.`Session` AND P.Part_ID = A.`Participant`
GROUP BY P.LastName, P.FirstName, A.Present, A.AttID
Selecting S.SessionDat
You *are* getting both; you just aren't getting them in the same
result set.
Assuming you are executing both queries in the context of a program
that has
variables, that should be sufficient for you to do just about anything
you
can imagine.
Yeah, thought about that before I went to sleep. And,
Hi,
Is it possible to modify parameters passed to prepared statements?
e.g.
select ...
where username like '%?%'
I'd like to put wildcard chars '%' on either end of a parameter. Is
this legal? or do I have to modify the parameter before passing it to
mysql.
thanks
Nathan
--
Nathan Coast
Ma
- Original Message -
From: "Kevin Cagle" <[EMAIL PROTECTED]>
To: "Rhino" <[EMAIL PROTECTED]>
Cc: "MySql List" <[EMAIL PROTECTED]>
Sent: Saturday, November 20, 2004 12:11 AM
Subject: Re: summing from multiple tables
> > The solution to your problem is simple: don't attempt to do the fina
