Tag Archives: mysql

OXID eShop from a different point of view

OXID eShop started to use database views from about 4.5.0 on. Which means I’m in trouble, because my current webpack (L 3.0) at hosteurope does not allow views on my database. Called my provider and they confirmed, that they do … Continue reading

Posted in oxshop | Tagged , , , , , , , , , , , | Leave a comment

Fun with MySQL autoincrement

Imagine the following scenario: you have a table with an autoincrement primary key. Let’s name it id and assume it is an UNSIGNED INT. See http://dev.mysql.com/doc/refman/5.0/en/numeric-type-overview.html for details.  id can have values between 0 and 4294967295. Let’s set up some … Continue reading

Posted in mysql | Tagged , | Leave a comment