Re: Help needed in creating primary key ,foreign key on a varchar datatype colum

Dayakar, - Original Message - From: ""Dayakar"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Sunday, November 21, 2004 7:39 AM Subject: Help needed in creating primary key ,foreign key on a varchar datatype colum --=_NextPart_000_000B_01C4CFBA.91C9BA80 Content-Type:

Re: LOAD DATA INFILE question...

Somewhere about Sat, 20-Nov-2004 at 06:27PM +0100 (give or take), 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 to dump into the table. |> I would like to select only 4 fields which are the 1st, 5t

[solved] Re: LOAD DATA INFILE question...

Hi Patrick, I was doing that it was taking 20 seconds to chop the fields from the file. That was the problem. Meanwhile about my problem I have seen that the lines in data files end with "\r\n" not "\n" so it solved the problem. Now it takes 3 seconds to dump the file and chop the necassary fiel

Primary key error

Hi list, MySQL newbie here and am using Navicat to learn how to manage a database for a test OS shopping cart. I got the below error message after importing a table into the database. Can anyone tell me what I could do to correct the problem? Would I need to add an additional column to the tabl

row numbers, jumping rows

Hello list, I wonder if someone could help me to get the fastest result on my query. I need to classify one entity, according to a specific attribute (let's call it X), looking at a sample extracted from a database table. First I need to sort my sample ordered by a specific table field (X). Then

how to create views in mysql4.1

Hello friends, Can any one help me in creating view using mysql4.1. If we cannot then any other alternative. It would be great if anyone give me an example for that. regards dayakar SMILE ALL THE WHILE.. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubs

Re: SQL code sought to remove duplicates, using most recent date

On Sat, 20 Nov 2004 19:14:55 -0800 <[EMAIL PROTECTED]> wrote: > they have the same perid, program and startdate. I would very much like > to get a listing for each perid that shows their perid, program, startdate > and then the latest (only the latest) stopdate. This would give unique SELECT pe

Re: Help needed in creating primary key ,foreign key on a varchar datatype colum

I just checked the definition of CREATE TABLE in the MySQL manual and I didn't see anything that suggests that primary keys based on VARCHAR columns need to be treated differently than other column types in MySQL. However, when I tried to create

Re: Primary key error

- Original Message - From: "DBS" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, November 21, 2004 7:37 AM Subject: Primary key error > Hi list, > > MySQL newbie here and am using Navicat to learn how to manage a database for > a test OS shopping cart. I got the below error m

Re: how to create views in mysql4.1

- Original Message - From: "Dayakar" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, November 21, 2004 9:38 AM Subject: how to create views in mysql4.1 > Hello friends, > > Can any one help me in creating view using mysql4.1. If we cannot then any other alternative. It would b

Re: how to create views in mysql4.1

On Sunday 21 November 2004 08:38 am, Dayakar wrote: > Can any one help me in creating view using mysql4.1. If we cannot then any > other alternative. It would be great if anyone give me an example for that. Thats a 5.0 feature.. Your not gonna get to far with 4.1.. Jeff -- =

Re: InnoDB data files keep growing with innodb_file_per_table

Ivan, I have now analyzed your ibdata1 file. As I suspected, the 'history list' was corrupt. It was broken at about transaction 1 500 000. Current trx id was already 20 million. The history list length was 8.5 million! Breakpoint 12, trx_purge_rseg_get_next_history_log (rseg=0x402c5268) at tr

Re: SQL code sought to remove duplicates, using most recent date

[EMAIL PROTECTED] wrote: 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,

temporary tables, replication, and innodb tables

I'm working on a new series of queries that share a temporary table. I've tried using both "create temporary table select" and "create temp table" then "insert into t ... select from y". Both seem to create a lock that (if the select portion runs long enough) causes a deadlock with the replica

counting sequences

Hi! I need to use SQL to count some sequences. We have taken a short snapshot of 1 year for people registered in programs. So we have data in a table like so: ID m1 m2 m3 m4 m5 m6 m7m8 m9 m10 m11 m12 The "m1", "m2", "m3" refers to month 1, month2, month3, etc. The data for 1 person might loo

Re: temporary tables, replication, and innodb tables

Mike, - Original Message - From: "Mike Debnam" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Sunday, November 21, 2004 9:25 PM Subject: temporary tables, replication, and innodb tables I'm working on a new series of queries that share a temporary table. I've tried using b

Remote Connecting

Hi all, I have a Linux Fedora Core 3 machine which is supposed to act as database server and a Windows XP client. I had installed mysql server 4.1.5 before and I have defined remote user on my Linux machine as below: > GRANT ALL PRIVILEGES ON *.* TO 'RemoteUser'@'%' IDENTIFIED BY 'password' WIT

Re: Remote Connecting

Hello Danesh, what error do you get after the upgrade ? Peter Danesh Daroui wrote: Hi all, I have a Linux Fedora Core 3 machine which is supposed to act as database server and a Windows XP client. I had installed mysql server 4.1.5 before and I have defined remote user on my Linux machine as belo

very slow concurrent queries on HEAP table

Hi all, I've got a rather odd performance problem with concurrent queries here. My query regrettably always needs to do a full table scan - really can't be helped. So my idea was to cache the data in a HEAP table to get maximum performance out of it and it works really well, I'm down to 0.07 sec

loading data file causes errors

I am moving a table from a 3.23.56 db to a 4.1.7 db. I currently only testing to see if I can. So far, I have been able to create the receiving table, but not be able to insert the data. (The only difference I see when using phpMyAdmin is the collation column on the 4.1.7 server) When I try

Problems With 4.0 -> 4.1 Upgrade on FreeBSD 4.10

Hello I have upgraded from mySQL 4.0 to mySQL 4.1 on a FreeBSD 4.10 box. The upgrade went perfectly with no warning or error messages. However, after the mySQL server was running for a few hours, it crashed. It restarted itself thanks to mysqld_safe. However, it keeps crashing and restarting i

Ok now connector/J doesn't work.

Mark Matthews said: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > William R. Mussatto wrote: >> Keith Ivey said: >> >>>William R. Mussatto wrote: >>> >>> I've been googling for 1/2 hr w/o any answers. sorry if I've missed the obvious. Problem. Fresh install of mysql 4.7.1, AS

Re: loading data file causes errors

> I am moving a table from a 3.23.56 db to a 4.1.7 db. I currently only > testing to see if I can. So far, I have been able to create the receiving > table, but not be able to insert the data. (The only difference I see when > using phpMyAdmin is the collation column on the 4.1.7 server) > > Whe