Logo
  • Home
  • About
  • Services
  • Career
  • Blogs
  • Contact
Logo

The UK's #1 Software Development Company. PodTech IO builds custom software solutions for businesses. Call today for a free consultation

  • Address

    4th Floor, 4 Tabernacle Street London EC2A 4LU
  • Email

    info@podtech.com
  • Contact

    +44 (0) 20 8720 6583

Category Archives: SQL

  • Home
  • Category Archives

Oracle Adds Machine Learning Support to MySQL HeatWave

  • By podtech
  • In cloud services SQL

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 […]

Read More

Datameer & Snowflake Partner on Multi-Persona Data Modeling Solution

  • By podtech
  • In Software Development SQL

Datameer & Snowflake Partner on Multi-Persona Data Modeling Solution Datameer has today announced a partnership with Snowflake, to launch a multi-persona code/no-code data modeling and transformation solution on Snowflake, designed to enable customers model and transform data, regardless of their programming skills. The new solution is expected to offer an innovative data modeling and transformation […]

Read More

2002 Cannot log in to the MySQL server – MAC

  • By podtech
  • In PHP SQL

2002 Cannot log in to the MySQL server – MAC To fix In /etc/php.ini, replaced the three occurences of /var/mysql/mysql.sock with /tmp/mysql.sock prompt% sudo chmod u+w php.ini   <- had to give myself write permission to that file.. you may need to become root user to actually edit the file.. depends who owns php.ini Now edit […]

Read More

SQL Where values are not in another table

  • By podtech
  • In MYSQL 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]

Read More

Select the next available value in a table

  • By podtech
  • In SQL

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 > […]

Read More

Recent Posts

  • What is Software Piracy?
  • Microsoft and SITA Launch New Innovation Center in South Africa
  • Ericsson, Qualcomm and Thales to Launch 5G into Space
  • Schneider Electric Launches Free Data Center Professional Education Platform
  • UK and South Korea Reach Data Sharing Agreement

PodTech IO

The UK's #1 Software Development Company. PodTech IO builds custom software solutions for businesses. Call today for a free consultation

Company

  • About
  • Services
  • Contact
  • Blogs
  • Career

Terms

  • Terms & Conditions
  • Privacy Policy

Contact Us

  • ADDRESS

    Headquarter: Tabernacle Street London India: Vi john Tower, Gurgaon, Haryana
  • EMAIL

    info@podtech.com
  • CONTACT

    +44 (0) 20 8720 6583

Copyright ©2022 PodTech IO. All Rights Reserved

Logo