I have a database containing different information from our website. One table (called Raw_Pages) contains a list of every page on our site and the path to it (along with other fields of course). Another table (called Paths) contains a…
I am using phpMyAdmin on MySQL 5.7 The code below selects the lowest values excluding any zero values and gives me a nice table of all the teamids with the lowest times in seconds next to them for that event…
How to display the information of the customer who has the most 'use' in 'audit' table. problem i dont know how to get information customer. select * from audit where used= (select MAX(used) from audit) audit table customer table
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…
actually i had some text content to include into my database the format is text. But i can save it in my database (in phpmyadmin)i'm using xammp . Can you help me to find where is the problem with my…
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'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…
the thing is, i have a table students table and another scores table and i already have all the students in the scores table but the class field is still empty so, i thought i could update all of them…
Okay, so I'm working on this Microsoft SQL database table that contains message strings, and I am trying to identify all of the URLs in those strings via starting with 'www.' and ending with either ('.biz','.com','.net','.org'). I found a very…