I used the following code to create a table on MySQL: CREATE TABLE IF NOT EXISTS auth ( id INT AUTO_INCREMENT, email VARCHAR(50) UNIQUE NOT NULL PRIMERY KEY, password VARCHAR(250) NOT NULL, username VARCHAR(50) UNIQUE, admin BOOLEAN NOT NULL DEFAULT…
I am using BIGSERIAL as a Primary key and I want to make use of the deleted row's ids. Example of the table that I want re-use the deleted ids from the deleted rows: DELETE FROM my_table WHERE id=3; INSERT…
I have a 40M record table having id as the primary key. I execute a select statement as follows: select * from messages where (some condition) order by id desc limit 20; It is ok and the query executes in…
I need to make the connection with the PK from a table to its correspondent FK from another table. This is my db: I only have the case_id from the case table, and I need the case_uid from the case_test…
I want to use BINARY UUIDs as my primary key in my tables, but using my own custom functions that generates optimised UUIDs loosely based on this article: https://mariadb.com/kb/en/guiduuid-performance/ The table structure and two main functions of interest here are:…
I have a table with integer ID as primary key--auto increment. Because of frequent delete/insert, the ID values are like 1 1000 2340 5420 .... I want it always to be 1 2 3 4 .... So is there a…
I am trying to make a crud function in laravel with custom primary ID. The Create, Read, and Delete are all working but whenever I tried Update I get an error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'id' in…
Im using phpmyadmin for the first time and I get this error: incorrect table definition. there can be only one auto column and it must be defined as key. What am I doing wrong? This is my code: CREATE TABLE…
I have multiple tables that don't have indexes nor primary key after migration. There are 9149 entries in some tables and about 10 new entries have been given id = 0. I can't give primary key due to multiple entries…
Well, I have the following model structure: I have one class - DatabaseEntity which is basically public class DatabaseEntity { public int Id { get; set; } } so each entity like product, category etc will inherit DatabaseEntity and have…