I want to select data from multiple tables at once using a single query. I sent an Id as classify data. What I’m currently doing is writing multiple select queries to get data. I want to know if there is a way to get all data using 1 query…
I am implementing the full text search on table called programming_language.
It contains multiple rows with ‘name’ column such as java, javascript, etc.
Initially I didn’t full text index so I did the following:
ALTER TABLE `Example`.`prog…
I got a VPS with CentOS, the only thing I have done is install MySQL for testing purposes.
When trying to connect from my pc I got this:
mysql -u root -p -h [REMOTE-IP]
Enter password:
ERROR 1045 (28000): Access denied for user ‘root’@’f…
I have always wondered, what is the query for finding the most similar string in DB When I search for a word and get back the most similar string. How to do it in MYSQL? Here is an example of a site that works this way
I got query witch gives me a distance.
(6378 * acos(cos(radians(".$lat.")) * cos(radians(p1.lat)) * cos( radians(p1.lng) – radians(".$lng.")) + sin(radians(".$lat.")) *
sin(radians(p1.lat)))) A…
My goal is to have a 5 by 5 table that looks like this:
State
MostRE
MostNRE
LeastRE
LeastNRE
WA
4499698
blank
blank
blank
TX
blank
91590135
blank
blank
DC
blank
blank
4780
blank
DC
blank
blank
blank
438130
I have found t…
I have some data that looks like this:
+——————–+——————–+——————–+——————–+———–+——————–+——-+————-+————-+——————–+———–+————+…
I am stuck in a script which is throwing php and mysql syntax error at the same time.
Error:
Notice: Undefined variable: id in /home/****/order.php on line 31
Notice: Undefined variable: order_no in /home/****/order.php on line
31
You hav…
Here i store the iframe code into variable, and attach the variable $row[‘youtubeId’] inside of it.
$iframeCode = "<iframe width=’560′ height=’315′ src=’https://www.youtube.com/embed/".$row[‘youtubeId’]."?autoplay=1&m…
I’m learning SQL and I was curious about type of JOINS. Does Table1 Left Outer Join Table2, Same as Table2 Right Outer Join Table1? Is there any difference at output due to the sequence?
I’m trying to build a few tables in MySQL for a small project. I’m working on it . Now, in my project, there will be 2 tables with data in them. In the application, you add an item and give it a certain date to go live so in the database t…
New to this and cant seem to get my head around it
I have two tables first table is cities, 2nd table is states, what I am trying to do is list all cites under the states their associated with
cities structure -> city_id, city_name, st…
in a mysql table I have a field of type Enum (‘S’, ‘N’) with default value = S. Now I have checked this table and I find many records that have no value in this field. How is it possible? I wanted to force the values of this field to be on…
in a mysql table I have a field of type Enum (‘S’, ‘N’) with default value = S. Now I have checked this table and I find many records that have no value in this field. How is it possible? I wanted to force the values of this field to be on…
I have a table transactions like this
date
amount
2020-02-26
1000
2020-02-26
1500
2021-01-11
200
I want to select the sum of all transactions per month. The result should look something like…
month
sum
2020-02
250…
here is my code
no any error i get
after put the registration number of student
so its showing only blank page after click on submit button.
this is my search.php file code other all code i done no issue
but its not fetching the data from …
In the past, I only worked with mysql database with phpmyadmin on localhost.
Now I have a official website (online, not localhost).
So do I need to download the database and put it into the webserver, for example with WinSCP?
Let’s say I have this table
id | user_id | warns
1 | 84327832 | 0
2 | 89432943 | 2
I want a MySQL query that does that.
My SQL query is this:
REPLACE INTO warns (first_name, last_name, username, user_id, warns) VALUES (%s, %s, %s, %s,…
I am building a MySQL table to aggregate a set of particular information for a customer. Much of it I’ve assembled and filtered successfully with simple INNER JOIN commands on records with shared keys/columns. The schema for this table t_s…
I have the following 2 tables (browsers and metrics). browsers is a "dimensions table" which stores the name and version of a browser. metrics is a "facts table" which holds the browser_id and metrics, in conjunction wi…