mysqlimport and \ as data

Hi Group, Does anybody have any expierence with mysqlimport and a comma separated file with data wich contains field data with a: \. For example I have the data in de column path: C:\temp. When I import this I got something like : c:||emp ... Does anybody know how to solve this problem? This

Re: locking issues

it is not a database bug or a API bug I contact microolap for more support. hans At 19:38 8-3-04, you wrote: Hans van Dalen [EMAIL PROTECTED] wrote: A question about locking. In my code (delphi but that doesn't much matter) I fire ad-hoc queries (select). Before the query i fire a locking

Re: Query with IF acting wierd.

SELECT distinct main.id, etc. etc. At 14:37 11-3-04, you wrote: I have 3 tables: main(id int, type tinyint(1)) categories(id int, name varchar) items(id int, name varchar) I want to select the id and name. If type is 1 then I want to select the name from categories, if type is 0 I want to select

Re: Query with IF acting wierd.

to apply my second solution, I'm looking for a more efficient solution (and if someone can than for an explanation - why are the results getting duplicated?) -Amir. On Thursday 11 March 2004 15:40, Hans van Dalen wrote: SELECT distinct main.id, etc. etc. At 14:37 11-3-04, you wrote: I have 3

locking issues

Hi Group, A question about locking. In my code (delphi but that doesn't much matter) I fire ad-hoc queries (select). Before the query i fire a locking query (read) for that particular tables. Something like this: lock tables tab1 a read, tab2 b read (execute) select * from tab1 a, tab2 b

Re: Sql control centre - How to view all the records for a table?

MySQL CC is a beta version, I can't find an option to set this max value. Maybe its an option for you to use the command line functions? There is no maximum of the viewed records. Hans At 09:02 10-2-2004, you wrote: Hi, Can anyone help me that i want to view all the record from a table,

Fwd: Re: Sql control centre - How to view all the records for a table?

Date: Tue, 10 Feb 2004 09:13:02 +0100 To: florence florence [EMAIL PROTECTED] From: Hans van Dalen [EMAIL PROTECTED] Subject: Re: Sql control centre - How to view all the records for a table? If you right click the table then you can choose: Return limit. At that moment you can give your own

table without primary key

Hi group, I had created a table without a primary key (for some reasons). This give some strange errors. When I edit a field trough ODBC he said: no transactions supported. If I edit trough direct access components (DAC for MySQL = native access) nothing is editted at all. With the mysql

Re: table without primary key

Hello Martijn, And the ODBC driver?? He cannot construct an UPDATE either? Updating the table is done in code only.. its temporary data wich is collected in this tables before serieus update..\ hans At 14:40 15-1-2004, you wrote: Hi Hans, I had created a table without a primary key (for

Re: table without primary key

wrote: it cannot b related with primary key. i do not hav any idea how u update it, but it's supported to update any dat in any table with or without PK - Original Message - From: Hans van Dalen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 15, 2004 6:20 PM Subject: table

Re: table without primary key

Hi Martijn, Yes your right, thanks a lot for ANY help! Monitoring component is a good Idea Hans At 15:09 15-1-2004, you wrote: Hi Hans, And the ODBC driver?? He cannot construct an UPDATE either? I'm not saying this is the problem, but it might give you a direction where to look.

Re: blacklist

After posting a message you get some more messages of mailservers around the world which are not accepting your message (send to the list). So there a lot of people who aren't receiving this mail because there server is checking spamcop. I don't know you can contact spamcop to ask to delete the

Column name: CHECK

Hi Group, I use the column name CHECK (smallint), but when I insert into the table I get an error : Check the manual for: Check) values ( etc.etc. When I try to change the column name (alter table tablename change check blabla smallint) I get an error too, check your manual.. Does anybody

Re: Column name: CHECK

Yes, I have used ` I don't think check is reserverd because I can CREATE the column name! From the mysql prompt its possible to insert a record, but not from my Delphi Code. After that i try to alter / delete the column but thats impossible. Other columns in the same table where altered

Re: Problem with LIKE/REGEXP

Hi, What db type do u use? If I'm right InnoDB doesn't support Free text search... bye Hans At 14:29 5-11-03, you wrote: Hello everyone! I have a table with a MEDIUMBLOB column: CREATE TABLE mytab ( oid INTEGER ... odata MEDIUMBLOB ); in the mediumblob field i store an encoded

Re: Creating backups

Read the manual at the section: Disaster Prevention and Recovery Database Backups with mysqldump you can dump a whole database. hans At 09:03 29-10-03 -0500, you wrote: Hi there, Does anyone have some tips or advice for creating backups of all the tables and

Re: get rows not present using join _AND_ where clause

+0200, you wrote: 2003-10-15 kl. 15.57 skrev Hans van Dalen: If I'm right you want to do a left join. For example: Table1: Id value 1 100 2 200 3 300 Table2: Id RefId OtherValue 1 1 9000 2 1

Re: union the rows from select 1 not in select 2?

). bye hans van dalen At 15:37 15-10-03 +0200, you wrote: Need to find out which rows from select 1 are not present in select 2, but is it possible to make som kind of union that only returns the overlapping rows from the two selects? Sincerely Victor -- MySQL General Mailing List For list

Re: get rows not present using join _AND_ where clause

Table1.Value, Table2.OtherValue from Table1 left join Table2 on Table2.RefId = Table1.Id then the result is: Value OtherValue 100 9000 100 1 200 8000 300 NULL Kind regards Hans van Dalen At 15:37 15-10-03 +0200, you wrote: I need

Re: union the rows from select 1 not in select 2?

Of course, But you still can see the table structure??? Hans At 16:05 15-10-03 +0200, you wrote: 2003-10-15 kl. 15.51 skrev Hans van Dalen: Table1 contains: A and B and C Table2 contains: B and C and D all varchars The query: select A, B, C, '' as D from Table1 UNION select '' as A, B

Somebody tried MySQL version 5 / Stored Procedures

, but just a little and in version 5 I write my transactions to stored procedures... In anticipation much thanks!! Kind Regards Hans van Dalen/ NL -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Somebody tried MySQL version 5 / Stored Procedures

Excuse me, I get an automatic reply from the mailinglist that my message wasn't send so I send it again. regards hans At 23:50 28-9-03 -0700, you wrote: On Mon, Sep 29, 2003 at 08:45:39AM +0200, Hans van Dalen wrote: Hi all, We want to migrate to MySQL, and because of its speed, we want

Re: UNDOing query operations

Hi, Read the manual about transactions. Hans At 11:56 29-9-03 +0200, you wrote: Hi group? Suppose I run a query by mistake that for example deletes my records. Is there a way to go back to a previous state? Thanks, __ NZEYIMANA Emery Fabrice NEFA Computing

Somebody tried MySQL version 5 / Stored Procedures

, but just a little and in version 5 I write my transactions to stored procedures... In anticipation much thanks!! Kind Regards Hans van Dalen/ NL -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]