Delete all data from multiple tables in mysql
I have a db with 100 tables. I want to delete data from all tables using mysql command or in phpmyadmin
How to delete certain characters from table values? – Mysql
I have a table. In one of the columns of the table , the values have this form: Value1(12) Value2(45) Value3(35) Value4(37) Value5(17) How to delete the opening parenthesis, the value inside the parentheses and the closing parenthesis? So that…
How can I check if accountNumber (non primary key) already exists in my database? – Mysql
String accountQuery = "insert into Account (accountNumber,currentBalance,type,personId) values (?,?,?,?);"; PreparedStatement accountPs = null; try { // These are my prepare Statements for my queries accountPs = conn.prepareStatement(accountQuery); // accountPs.setInt(1, personId.getPersonId()); accountPs.setInt(1, accountHolder.getAccountNumber()); accountPs.setDouble(2, accountHolder.getCurrentBalance()); accountPs.setString(3, accountHolder.getType()); accountPs.setInt(4, personId.getPersonId()); accountPs.executeUpdate(); accountPs.close();…
LOAD DATA LOCAL INFILE file request rejected due to restrictions on access (ODBC) – Mysql
Oh my, how do I even start asking this question.... I have a feeling this has been answered more than ones but I'm too dumb to understand the answers.... So I'm sure I'll be roasted for lots of reasons, but…
php executes in browser but fails in cron job – Mysql
I am trying to create a demo website for users to test. I want to restore the databse every x hours. When I run the php script in browser it works. It drops the tables and restores the databse without…
MySQL DATE_FORMAT() Data truncation: Incorrect datetime value
When I run DATE_FORMAT('test', '%W %M %Y') I get null returned. I'm running an update to my table extras where the column is a nullable varchar, but when I run eg. update extras set extras.`value` = DATE_FORMAT('test', '%W %M %Y');…
React,js + Prisma better way to update sql with a button – Mysql
async function change_status(object_id:number){ const response = await fetch('/api/db', { method: 'POST', body: JSON.parse(`{"id":${object_id}}`) }); if (!response.ok){ throw new Error(response.statusText); } return await response.json(); } I want this button to change an int in mysql <button onClick={() => change_status(object.id)}> change Status…
Hibernate doesn't creating table based on entity – Mysql
After starting the program (launching TomCat) there are no tables created in the schema, but the table "player" has to be created automatically. I checked hibernate config, but can't find where is the problem. I've tried changing hbm2ddl.auto to hibernate.hbm2ddl.auto…
SQL: split values by columns depending on condition – Mysql
I have table data after doing all joins and restrictions like this: Name Type Path Item 1 mobile /mobile/image1.jpg Item 1 desktop /desktop/image1.jpg Item 2 mobile /mobile/image2.jpg Item 2 desktop /desktop/image2.jpg I want the result table to look like this…
MySQL how to get query with 17 month date interval which shows current month plus 5 months ahead
I'm quite new to SQL and i have issues with a query i find quite complex. So i'm trying to create a query that shows a 17 month date interval. In that interval it has to show the what the…