Oracle has just announced that its Oracle MySQL HeatWave now supports in-database machine learning (ML) in addition to the previously available transaction processing and analytics, to help eliminate the need to move data or the model to a machine learning tool or service. As announced, MySQL HeatWave ML fully automates the machine learning lifecycle and […]
Extract CREATES from SQL dump If you are trying to extract the create routines from a SQL dump, this might help you! Basically it picks out the contents between “CREATE” and “\;” You can modify these two variables as need be.. [bash] cat dump.sql |awk ‘/CREATE/,/\;/ { print $0 ; }’ > create.sql […]
SQL Where values are not in another table [sql] select TCode from Tracking where not exists (select * from Task where Task.TCode = Tracking.TCode ) [/sql]
Select next available ID ## Select the next available UID ## Do not delete users from unixuid and unix gid as there id’s may get re-used ######################################## [sql] SELECT min( r1.uid ) +1 AS next_available_uid FROM unixuid AS r1 LEFT OUTER JOIN unixuid AS r2 ON r2.uid = r1.uid +1 WHERE r1.uid >200 AND r2.uid […]
Select the next available value in a table Let’s say I have a table like this: ID Value ———————- 100 val1 101 val2 104 val3 105 val4 107 val5 [sql] SELECT Min(r1.uid) + 1 AS next_available_uid FROM unixuid AS r1 LEFT OUTER JOIN unixuid AS r2 ON r2.uid = r1.uid + 1 WHERE r1.uid > […]