I have a csv file which I loaded into MySQL after creating a database and a table (phones). The columns of the table among others are: state and phone_condition. Also, I have ran many queries which were successful; but this…
Hi friends This is my code in laravel: Schema::create('programmer', function (Blueprint $table) { $table->id(); $table->string('email', 155)->unique(); $table->integer('primary')->primary(); $table->timestamps(); }); I got this error: SQLSTATE[42000]: Syntax error or access violation: 1068 Multiple primary key defined (Connection: mysql, SQL: alter table programmer…
I have a Subject class and a Course class. They are in a many-to-many relationship so I also have a CourseSubject class with navigation properties and id properties to the other two classes. I can now read subjects and courses…
I have created a simple flask authentication I have deployed it on render The app runs fine locally But when in the deployed app, the check_password_hash always returns false I use mysql on my local machine and the code works…
recovered a client sql , current situation is we need to mail the users from sql . the data format atm is : (sample) : [email protected] vyourclientd8572fee33aec16b3a22cc04629e1b33you3elient@yopmail.comy fascwail.com3153741243f27e84f73a9f018f239725allg00ds@fastmail.coma [email protected] pwdflamingo900197393e11808e7f27ebf4331f0860c9cscrfdsold120@gmail.com hrdpfreakdc30025992230a7e564581bf7360fe36newnewuserfir22e@gmail.com so it user|md5|email|erors the hard part to delete the…
I'm adding data to a MySQL 8 database on PythonAnywhere. I'm doing this via a python 3.10 script run in VSCode using an SSH Tunnel. When I add the data it takes approximately 50 seconds to add 275 rows, data…
On hight loaded service periodically I see a deadlock in DB ------------------------ LATEST DETECTED DEADLOCK ------------------------ 2023-03-06 22:48:18 0x7fa6a24af700 *** (1) TRANSACTION: TRANSACTION 209985062, ACTIVE 2 sec starting index read mysql tables in use 1, locked 1 LOCK WAIT 2…
I am a beginner in SQL, this is maybe a dumb question... Table 1 (guide_book) : ID Table ID Column A 0 0 a 1 0 b 2 0 c 3 0 d Table 2 (adding) : ID Table ID…
I want to get data from two tables and group them by date, like a daily report that shows data from two tables. Example output: Date Active User Total Deposit 2023-07-31 10 12500 2023-08-01 5 10000 2023-08-02 20 20000 2023-08-03…
I have made a new AWS RDS MySQL instance and I want to import some existing .sql data generated from an existing database using MySQL Workbench's export tool. I connected to the database using the "admin" master user, then started…