I am looking to remove the last 30 characters from a colum within my database. Column Name = gatewayid Table Name = tblclients I have created the below which works in the sense it shows me the result and it's…
I have a simple select statement without any join. All it does is checking a date_time and some other flags table has about 45.000 entries. The query is performed within a php script every 5 minutes, to send out an…
I am the sole dev working with a very large warehouse management system for a small business. Our software is housed on a local server that is only accessible within the building, but I also have a local copy of…
I have created an application in Laravel and completed it using a localhost MySQL database. When I was using a localhost XAMPP database, my application worked perfectly but, when I deployed my Laravel application on a newly purchased shared hosting…
I am using mysql and here is the schema that I have. First table: Keywords +------------+-------------+ | keyword_id | keyword_tag | +------------+-------------+ | 2 | marketing | | 58 | sales | | 59 | scraping | | 1 |…
I'm learning SQL and I try some things in phpMyAdmin like creating or deleting tables, creating or deleting records and so on... Let's assume I have a table where there are 2 columns - id and name populated with 7…
I have inserted some values into two columns but i can't find the Edit, Copy, Delete options in the browsing page in phpmyadmin. I thought that i need to update phpmyadmin but i still have the same problem after updating.…
I'm going to delete some rows in one of my table called sy_user. I want to delete some of the rows that is not matched in the other table, which is the tb_master_pegawai. How do i solve this query to…
I am new to this forum and learning to code. I want to ask how can I change the time stamp to current timezone or is there any way I can convert the timestamp date/time to my current time zone…
I have done the Setup database in localhost PHPMyadmin. when I submit a form via PHP it throw error like please enter valid length What is the problem with this query? Please look into the query and help. CREATE TABLE…