I got this error from mysql its not creating my table as suppose since there is an error from it the code is the following CREATE TABLE customers ( customer_number INT PRIMARY KEY, name VARCHAR(20) NOT NULL, address VARCHAR(60) NOT…
This is my first using a database. I've made an application that contains tables in dbForge through mySql localhost with XAMPP. I copied all my files and downloaded the latest 6.0 framework on the other PC, but it does not…
I'm developing an app in which I need to show come "coupons" I get from the API. I also have a "liked coupons" page where I need to show the ones the user has liked. I'm facing 2 problems here:…
We see large gaps in primary key column with auto_increment in mysql 8.0.31 release version in multiple tables (with default - innodb_autoinc_lock_mode = 2 (“interleaved” lock mode)). Also I understand some smaller gaps can happen in this mode. We have…
I'm using Postgresql,and I have a table named stock,this table has no index or id: open high low close volume datetime 383.97 384.22 383.66 384.08 1298649 2022-12-16 14:25:00 383.59 384.065 383.45 383.98 991327 2022-12-16 14:20:00 383.59 384.065 383.45 383.98 991327…
Can't do anything with Heroku using Rails and Postgres. It was working a few days ago and I upgraded from the Free plan to the Mini postgres plan and from the Free dyno to the Eco dyno. I get this…
i have one table TABLE 1 ID CLASS GENDER SUBJECT A1 6A A1 ENG A1 6A A1 MATH A1 4A A1 COMPUTER A1 3A A1 GK I want to copy and paste the records in the same table(table1) with ID…
i want to search and filter the data in my table but i dont know how to do it im currently studying php. this is my php script to search data <?php require('./conn.php'); if (isset($_POST['search'])) { $valueToSearch = $_POST['query']; //…
I am new in laravel and working on E-Commerce Project. Plz Help me! I am trying to get data from the database but I can't. My function public function add_product_attributes($id) { $attributes = Product::where(['id' => $id])->with('attributes')->first(); $attributes_data = $attributes->toArray(); dd($attributes_data);…
I have limited access to the MySQL database, I just can see a view called customer contains customer_id, name, and their location id_customer name location 1 Andy Detro.it 2 Ben CALiforNIA 3 Mark uk 4 Niels London123 5 Pierre Paris…