Comments by Ahmed AE - CodeProject

Ahmed AE 15-Feb-19 15:31pm View

i am not trying to hack any thing, please read the question carefully

Ahmed AE 15-Feb-19 11:18am View

it inserts a 2 rows in 2 relational table that are connected with a foreign key. I want to automatically get the foreign key name between the 2 tables instead of manually writing it and use to to insert data in it

Ahmed AE 21-Apr-18 11:26am View

Deleted

people like you makes me love this site

Ahmed AE 21-Apr-18 11:20am View

thank you very much

Ahmed AE 21-Apr-18 9:45am View

thank you, again one more question:
how long does the stored procedure last in server? i mean when i close MySQL workbench, and open it again does the procedure will be found, if yes what makes the procedure to be dropped from the server?

Ahmed AE 21-Apr-18 7:58am View

this was very helpful, i have another question:
what is the difference between the EXIT and CONTINUE handler_actions?
form https://dev.mysql.com/doc/refman/8.0/en/declare-handler.html, i have found that:

CONTINUE: Execution of the current program continues.
EXIT: Execution terminates for the BEGIN ... END compound statement in which the handler is declared. This is true even if the condition occurs in an inner block.
what is the difference between them?

Ahmed AE 20-Apr-18 11:21am View

please have a look at my code below.

Ahmed AE 19-Apr-18 19:36pm View

Deleted

i have modified the above to be:
DROP PROCEDURE IF EXISTS mprocedure;
DELIMITER $$
CREATE PROCEDURE mprocedure ()
BEGIN
START TRANSACTION;
INSERT INTO `mschema`.`table1`
(`maxbudget`,
`blocked`,
`d_percentage`,
`max discount`)
VALUES
('2250',
'0',
'.9',
'.99');
if (@@error_count = 0 ) then
INSERT INTO `mschema`.`table2`
(`name`,`image`,`date`,`fKey_id`)
values
('jhon','jfdd', '2018-01-01 00:00:00', LAST_INSERT_ID());
if (@@error_count = 0 ) then
commit;
else
rollback;
end if;
else rollback;
end if;
commit;
END;
$$
DELIMITER ;

Ahmed AE 16-Apr-18 7:54am View

Thank you, i have another 2 question please.
1. During the execution of that code the CMD is flashing, is there any way to stop it from flashing?
2. How to catch the stderr as you stated?

Ahmed AE 14-Apr-18 7:10am View

thanks

Ahmed AE 13-Apr-18 11:36am View

"Create a new unique id for each record as you read them in." does this will solve the problem ? this will only avoid overwriting the already found id's but will not solve the problem that there will be repeated records in the server database

Ahmed AE 13-Apr-18 11:32am View

the problem that is found between the dump files and each other, can also be found between the resultant dump file (after merging) and the database on my server,i mean that there might be records that are found in the resultant dump file and also found in the database on my server, so what can i do in that case?

Ahmed AE 13-Apr-18 10:29am View

What if there are the same record in 2 dump files but have different id's.

Ahmed AE 13-Mar-18 17:00pm View

the problem is not with the Set @temp select query', this work fine. But the problem with the remaining part of the query

Ahmed AE 17-Feb-18 15:02pm View

How to test this?

Ahmed AE 16-Feb-18 20:11pm View

Deleted

more clarification please

Ahmed AE 16-Feb-18 9:55am View

Deleted

I really trust in your opinion. But how to test it is OK or not?

Ahmed AE 16-Feb-18 7:46am View

What about using only delete[] to delete it?

Ahmed AE 16-Feb-18 7:38am View

But what about using only delete[] myArray;
as array deallocation?

Ahmed AE 16-Feb-18 7:35am View

OK, i will try

Ahmed AE 16-Feb-18 7:00am View

because i will use these matrices in mathematical calculations. And the vector will consume more CPU and Ram resources.

Ahmed AE 16-Feb-18 6:58am View

Deleted

Good explanation, i misused the int variable i; myArray[i] = new int[j];

Ahmed AE 16-Feb-18 6:35am View

He made me confused

Ahmed AE 16-Feb-18 3:33am View

Deleted

me too

Ahmed AE 16-Dec-17 14:21pm View

thanks

Comments by Ahmed AE (Top 25 by date)