mysql

[Solved] Double SUM query MySQL

by

Given the tables: Tabel_1 idUnit Budget 112 1000 112 2000 Tabel_2 idUnit Real2 112 500 112 100 You can produce the following result: idUnit TotalBudget TotalReal2 112 3000 600 With the following query: SELECT t1.idUnit, SUM(Budget) AS TotalBudget, t2.TotalReal2 FROM Tabel_1 AS t1 JOIN (SELECT idUnit, SUM(Real2) AS TotalReal2 FROM Tabel_2 GROUP BY idUnit ) … Read more

[Solved] Echo from bottom to top [duplicate]

by

You just need to add a order by on the sql you are executing Like this $sql = “SELECT * FROM community_posts ORDER BY id DESC”; If id is your primary key. Hope it helps 3 solved Echo from bottom to top [duplicate]

[Solved] Something wrong with php code [closed]

by

Variable values are not evaluated within a string with single quotes: mysql_query(“INSERT INTO votes (voter, photoid, photoowner, vote) VALUES (‘$voter’, ‘$photoid’, ‘$photoowner’, ‘yes’)”); put double quotes around your select statement or use concatenation and don’t forget to put quotes around your string values Also use use mysql_error() to retrieve the error text 10 solved Something … Read more

[Solved] How to inner join two tables?

by

You say you want solutions in Python, MySQL or MongoDB. But you’ve tagged the question with “perl”. So here’s a Perl solution. #!/usr/bin/perl use strict; use warnings; my %file1 = get_file1(); open my $fh2, ‘<‘, ‘File2’ or die “File 2: $!\n”; chomp(my $header = <$fh2>); print “$header\tcol_F\n”; while (<$fh2>) { chomp; my $colA = (split … Read more

[Solved] Set database column values to a variable in PHP [closed]

by

mysql_query returns a resource you can use with these methods to fetch each row from the result: mysql_fetch_assoc mysql_fetch_row mysql_fetch_array mysql_fetch_object The most common function used is mysql_fetch_assoc which fetches the row as an associative array using the column names as the key names: <?php $result = mysql_query(…); while ($row = mysql_fetch_assoc($result)) { print $row[‘columnName’]; … Read more

[Solved] Backup/Restore on CloudSQL instances

by

Here I address you questions: 1. Any way to check the size of existing databases in CloudSQL instances? Yes, there is. This depends on the database engine you are using(mysql, postgres or mssql) For mysql, you can run: SELECT table_schema “DB Name”, ROUND(SUM(data_length + index_length) / 1024 / 1024, 1) “DB Size in MB” FROM … Read more

[Solved] How to query database column names? [closed]

by

just change database name and table name with yours and run this query SELECT `COLUMN_NAME` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA`=’database_name’ AND `TABLE_NAME`=’table_name’ and COLUMN_NAME like ‘link_%’ solved How to query database column names? [closed]

[Solved] I have error in folloing code of php for update [closed]

by

Use , instead of set between each fields. Use this altered query, (‘UPDATE Registration SET name=”‘.$_POST[‘Username’].'” , password=”‘.$_POST[‘Password’].'” , city=”‘.$_POST[‘City’].'” , state=”‘.$_POST[‘State’].'” , country=”‘.$_POST[‘Country’].'” WHERE id=’.$_POST[‘user_id’]); 1 solved I have error in folloing code of php for update [closed]

[Solved] SQL where clause two seperate values? [closed]

by

You have to join the the employee table twice: select distinct employee.LastName, employee.EmployeeId, manager.Lastname from customer join employee as employee on customer.SupportRepId = employee.EmployeeId join employee as manager on employee.ReportsTo = manager.employeeId where customer.Country = ‘Canada’ 0 solved SQL where clause two seperate values? [closed]

[Solved] PHP insert into not inserting any data

by

$sql = “INSERT INTO tasks (taskName, requestedBy, details, dateAdded) VALUES (‘$taskname’ ,’$requestedby’ ,’$details’, ‘$datenow’)”; // Removed quotes from columns, and added missing quote on datenow Please note, this technique for adding values into the database is very insecure, and is prone to SQL injection attacks. 5 solved PHP insert into not inserting any data

[Solved] PHP insert into not inserting any data

by

Introduction If you are having trouble getting your PHP insert into statement to work, you are not alone. Many developers have encountered this issue and have had difficulty finding a solution. This article will provide an overview of the problem and offer some tips and tricks to help you get your PHP insert into statement … Read more

[Solved] Creating MySQL query from access query

by

Assuming the first query to run is named qryAgreedToServiceOrUnenrolled. Try nesting the first SQL in the second’s FROM clause. Can replace qryAgreedToServiceOrUnenrolled with some other alias everywhere it is referenced. SELECT qryAgreedToServiceOrUnenrolled.patient_id, dispositions.description, dispositions.member_status FROM (( (SELECT DISTINCT t.patient_id, MAX(t.id) AS MaxOfid FROM transactions AS t INNER JOIN disposition_transaction_type AS dt ON t.disposition_transaction_type_id = dt.id … Read more