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 \ occurs to much to do the job manually ;-) Thanks a lot. Hans -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: locking issues
Excuse me for late response. When I do it from the mysql prompt it works fine but trough the API (I use DAC for MySQL from microolap, maybe the bug is in there software!!) it doesn't work fine. I have try it on several versions: 4.1.1, 5.0.0 and 4.0.0. Thank you for your help. If you think 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 query (read) for that particular tables. Something like this: lock tables tab1 a read, tab2 b read (execute) select * from tab1 a, tab2 b where. (execute) In this case I get an error: tab1 is not locked using LOCK TABLES. Works fine for me: mysql lock tables tab1 a read, tab2 b read; Query OK, 0 rows affected (0.00 sec) mysql select * from tab1 a, tab2 b where a.id=b.id; +--+--+ | id | id | +--+--+ |2 |2 | +--+--+ 1 row in set (0.00 sec) What exactly versions do you use? If I change the locking query to: lock tables tab1 read, tab2 b read The first times I didn't get any error. But after some times of running my app the error: a is not locked using LOCK TABLES occur!?!? Ok finally I use the statement: lock tables tab1 read, tab1 a read, tab2 b read en everything works fine. The strangest thing about this is that sometimes it doesn't go wrong (locking using the lock statement with only the table aliases), other times it goes. When I execute the locking and the select query from my SQL explorer (borland) nothing is going wrong (makes no sense whatever you lock). It makes no difference I use version 4.0/4.1/5.0 (on suse linux). Anybody who has seen this before? Okay the workaround is simple: don't use table aliases or use the above showed locking statement, but it makes me angry something like this errors are raised on unexpected moments in my production environment,. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 the name from items, here is the query I'm trying to use: SELECT main.id, IF(main.type,categories.name,items.name), IF(main.type,cat,item) AS type FROM main,items,categories WHERE IF(main.type,categories.id,items.id)=main.id; This query gives me each row couple of times, can anyone tell me why? or can any one give me a better solution? My solution which I guess is not good is adding GROUP BY: SELECT main.id, IF(main.type,categories.name,items.name), IF(main.type,cat,item) AS type FROM main,items,categories WHERE IF(main.type,categories.id,items.id)=main.id GROUP BY id, type; Thanks, -Amir. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Query with IF acting wierd.
Amir, I don't know your table content but if you join two tables eg : table1(id, desc) and table2(id, refid, desc) wich containts: table1: 1 test1 2 test2 table2: 1 1 testbla 2 1 testbla and you select: select id from table1 where table1.id = table2.refid you got two rows (because if you show * it would be: 1 test1 1 1 testbla and 1 test1 2 1 testbla So distinct is the keyword for getting only the unique records. Distinct is in MYSQL very effective (see the user manual for : How MySQL Optimizes `DISTINCT'). regards At 15:02 11-3-04, you wrote: Thanks, but this is just a nicer way 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 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 the name from items, here is the query I'm trying to use: SELECT main.id, IF(main.type,categories.name,items.name), IF(main.type,cat,item) AS type FROM main,items,categories WHERE IF(main.type,categories.id,items.id)=main.id; This query gives me each row couple of times, can anyone tell me why? or can any one give me a better solution? My solution which I guess is not good is adding GROUP BY: SELECT main.id, IF(main.type,categories.name,items.name), IF(main.type,cat,item) AS type FROM main,items,categories WHERE IF(main.type,categories.id,items.id)=main.id GROUP BY id, type; Thanks, -Amir. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 where. (execute) In this case I get an error: tab1 is not locked using LOCK TABLES. If I change the locking query to: lock tables tab1 read, tab2 b read The first times I didn't get any error. But after some times of running my app the error: a is not locked using LOCK TABLES occur!?!? Ok finally I use the statement: lock tables tab1 read, tab1 a read, tab2 b read en everything works fine. The strangest thing about this is that sometimes it doesn't go wrong (locking using the lock statement with only the table aliases), other times it goes. When I execute the locking and the select query from my SQL explorer (borland) nothing is going wrong (makes no sense whatever you lock). It makes no difference I use version 4.0/4.1/5.0 (on suse linux). Anybody who has seen this before? Okay the workaround is simple: don't use table aliases or use the above showed locking statement, but it makes me angry something like this errors are raised on unexpected moments in my production environment,. Thanks for help Hans -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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, but in mysql control centre, i only can view the first 1000 records, can anybody teach me how to make it can view for all the rest of the records? Thank u. regards, florence Thank you very much. regards, florence Y! Asia presents Lavalife - Get clicking with thousands of local singles today! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 limit... Give a big number and wait for a long time ;-)) At 09:02 10-2-2004, you wrote: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 shell updating trough a Query is no problem. In DAC for MySQL I use a TTable. Does somebody know about problems with tables without primary index? Thanks Hans -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 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 shell updating trough a Query is no problem. In DAC for MySQL I use a TTable. My bet is that the component cannot construct an UPDATE statement. Does somebody know about problems with tables without primary index? Well, how would you be updating a row without an unique identifier :-) With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: table without primary key
I use it as a temporary file. Putting data in it sequential and after that reading it out sequential. I don't want a auto increment field or whatsoever because I want the date in sequential order of the data... the data itself cannot (always) be used as a primary key At 14:46 15-1-2004, you 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 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 shell updating trough a Query is no problem. In DAC for MySQL I use a TTable. Does somebody know about problems with tables without primary index? Thanks Hans -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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. Updating the table is done in code only.. its temporary data wich is collected in this tables before serieus update..\ Instead of trying a TmyTable, why not use a query component and create an UPDATE statement yourself to update the table. That would avoid all this. And have a look at the MyMonitor component to see what SQL get's executed when you're doing what you're trying to do. That might help as well. hans At 14:40 15-1-2004, you wrote: Hi Hans, 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 shell updating trough a Query is no problem. In DAC for MySQL I use a TTable. My bet is that the component cannot construct an UPDATE statement. Does somebody know about problems with tables without primary index? Well, how would you be updating a row without an unique identifier :-) With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 ip of the maillist in there listings... Spend some surfing on it... hans At 15:02 15-1-2004, you wrote: Stefaan Van Dooren wrote: Since some days I don't get any mail from this list anymore. After some investigation, I found that it's blacklisted and our mailserver refuses any mail from it. DNSBL/WARNING: bl.spamcop.net/213.136.52.31: IP is listed Can this be fixed ? Yes. Ask your mail admin. Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 know what's happening? Thanks for help. Regards, Hans -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 without any problems. Maybe its a bug I can create the column name check?? Regards hans At 18:10 24-12-2003, you wrote: Have tried to use back sticks? Like `check` Thanks Emery - Original Message - From: Martijn Tonies [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, December 24, 2003 16:41 Subject: Re: Column name: CHECK 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 know what's happening? Reserved word? With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 string (bytes). I would like to perform regular expression searches on this field here is an example that works (produces matches): SELECT oid FROM mytab WHERE odata LIKE [EMAIL PROTECTED]\ngmosx%; here is an example that doesnt work (no matches returned): SELECT oid FROM mytab WHERE odata LIKE [EMAIL PROTECTED]\017athens1234%; the \017 character seems to be the problem since the following produces matches: SELECT oid FROM mytab WHERE odata LIKE [EMAIL PROTECTED]_athens1234%; I tried using a MEDIUMTEXT and/or REGEXP but without success! Any idea how to do string matches on string-encoded binary data? Thanks in advance for any info! George Moschovitis -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 data contained therein? Do you use custom solutions or perhaps open-source projects? -Erich- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: get rows not present using join _AND_ where clause
Okay, Now I understand what you want. (For people who try to unsub me from this list: Sorry I only try to help, if you are not intressted in it pleasee dont read) If you start using MySQL 4.1 (Only ALPHA) then you can use subqueries like this: select * from table1 where id not in ( select refid from table2 where thirdvalue = 'de') problem solved. But if you use an older version the only solution is to use a temporary table or make it in code. First you select al the values from table2 with thirdvalue 'de', walk trough this dataset while looking in table1 if theres a corresponding value. I think there are no other options. I have tried to rewrite the subquery to a left join, but i think it isn't possible, because he thirdvalue = 'de' makes a problem. It is no problem to get all rows from table1 who have no corresponding record in table2 with a left join: select table1.id from table1 left join table2 on table1.id = table2.refid where table2.refid IS NULL But you have the problem that there is a corresponding record in table2. I''ve tried to solve this with a union who returns a NULL value . But I can't get the right results. regards, Hans At 16:13 15-10-03 +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 1 3 2 8000 If you do this: select 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 Almost, but I would like to do it from a subselect of Table2 that also has the column thirdvalue: Table2: Id RefId OtherValue ThirdValue 1 1 9000dk 2 1 1 de 3 2 8000dk This table is unfinished as is in my application. What I'ld like to do is to find out that there is no OtherValue in table2 for Table1.id = 2 where table2.Thirdvalue _SHOULD_ be 'de'. That is, for each id in Table1, _force_ join on table2 where ThirdValue = 'de' but since I actually need the id's in Table1 for which there is no corresponding Thirdvalue = 'de' I get a big problemÂ… Sincerely Victor -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: union the rows from select 1 not in select 2?
for example: 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, C, D from Table2 if the values are no varchar but for example smallints then you replace the '' with 0 or whatever wich value (eg NULL). 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 archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: get rows not present using join _AND_ where clause
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 1 3 2 8000 If you do this: select 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 to find out, using a join, which corresponding rows in a union that is missing. But it is among a certain subselect I want to do this, that is, among the rows where the column lang = 'uk' for example. The two tables looks like following: +---++---+ | id | betegnelse | enhed | +---++---+ | 00046 | 838718001064311911 | 5 | | 00120 | 641725001064311948 | 5 | | 01310 | 532898001064317190 | 5 | | 01320 | 535436001064317190 | 5 | | 01330 | 537895001064317190 | 5 | +---++---+ den andra ser ut som +--++--+--+ | id | relid | lang | text | +--++--+--+ | 5513 | 838718001064311911 | dk | m | | 5514 | 838718001064311911 | de | m | | 5515 | 838718001064311911 | uk | m | | 5517 | 641725001064311948 | dk | Stk. | | 5518 | 641725001064311948 | de | Stk. | +--++--+--+ As you can see, the second one holds the language-strings for the first table. But as you also can see I'm missing the last row in table two which should read: +--++--+--+ | id | relid | lang | text | +--++--+--+ | 5519 | 641725001064311948 | uk | Stk. | +--++--+--+ What I would like to do is to list all rows, with null values, where lang != 'dk' or 'de', for example, or rather where lang = 'uk' to find out which that are missing. (What I'm gonna do then is to list the missing texts for translation under a translation page in the admin-area. But thats at a later point - now I just have to select them) Best regards and lots of thanks in advance! Sincerely Victor // Malmoe and Copenhagen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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, C, D from Table2 if the values are no varchar but for example smallints then you replace the '' with 0 or whatever wich value (eg NULL). Might be me beeing tired since its late afternoon, but doesnt the SQL above require that I know which rows are missing in the two tables? What I want to do is to union the result +---++---+ | id | betegnelse | enhed | +---++---+ | 00046 | 838718001064311911 | 5 | | 01330 | 537895001064317190 | 5 | +---++---+ with +---++---+ | id | betegnelse | enhed | +---++---+ | 00046 | 838718001064311911 | 5 | | 00120 | 641725001064311948 | 5 | | 01330 | 537895001064317190 | 5 | +---++---+ and have the new result +---++---+ | id | betegnelse | enhed | +---++---+ | 00120 | 641725001064311948 | 5 | +---++---+ which is the row from select 1 thats not present in select 2Â… Sincerely Victor -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Somebody tried MySQL version 5 / Stored Procedures
Hi all, We want to migrate to MySQL, and because of its speed, we want to use MyISAM db. I plan to write code as an alternate transaction mechanism. But I have read that MySQL version 5 supports Stored Procedures (PL/SQL like). In PL/SQL it is possible to use in your stored procedures transactions (at the end (eg) of a stored procedure you can do a commit and in an exception handler (eg) you can do a rollback). My question to somebody who has tried version 5 (or the development team), is this possible in MySQL stored procedures too? So it is not nessecery for me to write much code, 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 to use MyISAM db. I plan to write code as an alternate transaction mechanism. But I have read that MySQL version 5 supports Stored Procedures (PL/SQL like). In PL/SQL it is possible to use in your stored procedures transactions (at the end (eg) of a stored procedure you can do a commit and in an exception handler (eg) you can do a rollback). My question to somebody who has tried version 5 (or the development team), is this possible in MySQL stored procedures too? So it is not nessecery for me to write much code, but just a little and in version 5 I write my transactions to stored procedures... In anticipation much thanks!! Didn't you ask this roughly 3 days ago? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 15 days, processed 538,364,636 queries (407/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 Services, Inc. P.O. Box 5078 Kigali Office Phone: +250-51 11 06 Office Fax: +250-50 15 19 Mobile: +250-08517768 Email: [EMAIL PROTECTED] http://www.nefacomp.net/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Somebody tried MySQL version 5 / Stored Procedures
Hi all, We want to migrate to MySQL, and because of its speed, we want to use MyISAM db. I plan to write code as an alternate transaction mechanism. But I have read that MySQL version 5 supports Stored Procedures (PL/SQL like). In PL/SQL it is possible to use in your stored procedures transactions (at the end (eg) of a stored procedure you can do a commit and in an exception handler (eg) you can do a rollback). My question to somebody who has tried version 5 (or the development team), is this possible in MySQL stored procedures too? So it is not nessecery for me to write much code, 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]