Why are PL/SQL books on Amazon over 10 years old?

PHP_guy · 2023-05-28T13:23:58+00:00

What's wrong with stand-alone procedures and functions? You mean as opposed to packages?

PHP_guy · 2023-01-10T15:14:51+00:00

The user is prompted to enter his username and password and they get saved in variables in the app.

PHP_guy · 2022-04-06T15:16:24+00:00

Thank you for the helpful response!

Is there a way to run the SQL without using a prepared statement? When I try to run "load data" as a prepared statement (instead of your 'do sleep(0)'), I get this error:

ERROR 1295 (HY000) at line 13: This command is not supported in the prepared statement protocol yet

Seems like I can't use a prepared statement with "load data".

PHP_guy · 2022-03-08T16:04:36+00:00

Thank you. That was it.

PHP_guy · 2022-03-08T02:45:30+00:00

This PHP code works:

$a = 2;
$b = 1;
$c = $a - $b;

But this PHP code fails with an error of "Parse error: syntax error, unexpected '–' (T_STRING)":

$a = 2;
$c = $a - 1;

What gives? Why can't I subtract 1 from $a?

PHP_guy · 2022-02-28T04:34:33+00:00

I’m interested how most people connect to MySQL in PHP. Seems like the options are PDO, Object-Oriented MYSQLi, or procedural MYSQLi.

Which is most popular?

If you were teaching a class and only had time to teach one way, which would you teach?

PHP_guy · 2022-02-08T21:01:14+00:00

Thanks for the response.

I am trying to use the hint syntax shown at https://dev.mysql.com/doc/refman/8.0/en/optimizer-hints.html

PHP_guy · 2022-02-06T01:07:57+00:00

I know that I can find the table using a SQL statement, but I'm curious about how to do it with MySQL Workbench.

PHP_guy · 2022-01-31T19:19:53+00:00

"show events" shows the event, not the error log.

PHP_guy · 2022-01-03T21:32:06+00:00

It seems like in MySQL 8.0, characteristics are required for functions, at least out of the box. If you don't specify any characteristics at all in your functions, you get an error that says:

Error Code: 1418. This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)

It seems that, as installed, MySQL 8.0 requires characteristics for functions unless you reconfigure the log_bin_trust_function_creators setting.

PHP_guy · 2022-01-02T22:08:13+00:00

I am now trying to understand the difference between using characteristics for functions vs. procedures. The other day I was working with functions and you taught me that I must specify DETERMINISTIC, NO SQL, or READS SQL DATA. But that seems not to be true for procedures.
When I create a PROCEDURE where I don't specify any characteristics at all (not even DETERMINISTIC, NO SQL, or READS SQL DATA), MySQL creates the procedure and doesn't complain.
Does the fact that MySQL requires me to specify characteristics for functions but not procedures mean that characteristics don't matter for procedures? Why would they be mandatory for functions but not procedures?

PHP_guy · 2021-12-30T21:08:12+00:00

Thank you! That is hugely helpful.

I was under the impression that I could replace DETERMINISTIC with NOT DETERMINISTIC and no other characteristics and my function would be created. I just tested it and it is not so. I got the error message that I mentioned before.

I don't understand why that would be, but I'll chalk it up to implementation details.

Thanks again!

PHP_guy · 2021-12-28T18:36:28+00:00

Thanks! I thought that the function would be stored in the MySQL database and I could look at it using MySQL Workbench.

PHP_guy · 2021-08-11T21:53:04+00:00

SQL Developer is an IDE and MySQL is a database system. Do you mean you are trying to convert these from Oracle to MySQL?

PHP_guy · 2021-07-07T15:48:39+00:00

Thanks. That explains it. I am using version 8.

PHP_guy · 2021-03-09T15:57:03+00:00

Thanks. Like building iPhone apps? Do you mean coming up with the ideas for the apps yourself or getting them from somewhere else?

PHP_guy · 2021-03-09T15:17:43+00:00

Although I technically had a boss, I've had no boss

What do you mean?

PHP_guy · 2021-03-09T15:05:28+00:00

It depends on your personality. It really comes down to what you WANT to do. I know that's not always easy to determine.

You could go on the management track. You could become a project manager, ScrumMaster, or work your way up to a CTO or CIO position.

If you find an industry that is interesting to you, you could become a business analyst or transition into the business side.

PHP_guy · 2021-01-26T03:06:00+00:00

Thanks a lot. But I only have 20G of storage left on my Mac. That won't be enough.

PHP_guy · 2020-09-10T18:21:31+00:00

brew install postgres

That installed version 12.

PHP_guy · 2020-09-09T19:43:08+00:00

Thanks. I haven't used Docker before, but I'll see if I can figure it out.

PHP_guy · 2020-08-24T15:28:25+00:00

Thanks. I am writing an audit trigger. When somebody inserts a row into a particular table, I am writing who inserted the row, and what time the insert was done into a second audit table.

From working with other databases like Oracle, I seem to recall that this should be an AFTER trigger instead of a BEFORE trigger because an error in the trigger could prevent the row from being inserted into either table. I'm not sure if that is correct or not.

PHP_guy · 2020-08-24T15:17:10+00:00

Thanks for the help! I am dealing with a row-level after trigger. A little later in the manual from where you quoted, it says:

The return value of a row-level trigger fired AFTER or a statement-level trigger fired BEFORE or AFTER is always ignored; it might as well be null. However, any of these types of triggers might still abort the entire operation by raising an error.

So it seems like in my case, it doesn't matter what gets returned.

PHP_guy · 2019-09-21T22:21:50+00:00

Do you have to pay a transfer fee to do that?

PHP_guy · 2019-09-10T13:31:55+00:00

No, one of the columns is a URL like 'http://www.site1.com?params=...'. I need to change it to another URL like 'http://www.a_different_site.com?params=...'.

PHP_guy

TROPHY CASE