Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you may not be able to execute some actions.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

work on the two tables

T
terrea last edited by

How to put this in SQL.
The dates of 3 settlement and 3 dates of eviction (half may be empty, i.e. unknown when evicted).
Example: (2007-09-01 villages), 2007-10-01 (settlements), 2008-09-01 (settlements), 2010-09-01 (outs), empty date(s), 2014-06-30(outs)
QuestionHow do we make 2-day settlements comparable to 1-settlements, then 3-day settlements compare to 2-day evictions, etc?
i.e. each next settlement date compares with the previous eviction
Reply Quote 0
1 Reply Last reply
K
kalena last edited by

If I understood you correctly in table 2 of the field date1 settlements date2 evictions You need to use the table three times in your request. example
select * from table t1, table t2, table t3 where t1.tt=t2.tt and t1.tt=t3.tt and (t1.date1>t2.date2 or t2.date2 is null) and t2.date1>t3.date2 or t3.date2 is null)
Reply Quote 0
1 Reply Last reply

2
Posts

0
Views

Suggested Topics

How do tie the two tables?
Software Programming • mysql • • inna

2

0
Votes

2
Posts

0
Views

INSERT INTO table2 (id_main) SELECT LAST_INSERT_ID()
K

Integration of two tables
Software Programming • php mysql sql • • Kadyn

2

0
Votes

2
Posts

0
Views

K

Some of the options for addressing the challenge are by date grouping using the function GROUP_CONCAT()SELECT `date`, GROUP_CONCAT(sum ORDER BY id_source) AS calls FROM calls WHERE operator = 'petr' GROUP BY `date` ORDER BY `date` DESC Requires two columns, the first, the second, the second, the second, the two, the two, the two, the two, the two, the two, the two, the two, the two, the two, the two, the two, the two, the two, the two, the two, the two, the two, the two, the two, the two, the two, the two, the two, the two, the two, the two, the two, the two, the two, the two, the two, the two, the two, the two, the two, the two, the two, the two, the two, the two, the two, the two, the two, the two, and the two, the two, the two, the two, the two, the two, the two, the two, the two, the two, the two, the two, the two, the two, and the two, the two, the two, the two, the two, the two, the two, the two, the two, the two, the two, the two, the two, the two, the two, the two, the two, sum classified source_id♪ In order to form the table ' s cap, it is sufficient to request the data from the call source table by also discarding them. source_id♪
How do you work with two branches at the same time?
Software Programming • git • • Alberto

2

0
Votes

2
Posts

0
Views

T

What's described isn't exactly a one-time job, first with one branch, something's done, then the other.git clone ... git checkout -b origin/HEAD A # создает ветку для задания А git commit # A1 git commit # A2 git commit # A3 git checkout -b origin/HEAD B git commit # B1 git commit # B2 git commit # B3
P

Increase values after an INSERT
Software Programming • mysql c sharp visual studio • • Pearlaqua

2

0
Votes

2
Posts

0
Views

E

what you can do is that in the identity of your table the incremental is based on 2 instead of base 1example:Create table TablaNombre ( [KEyTable] [int] NOT NULL IDENTITY(1,2) )
N

Comparison of two tables
Software Programming • sql server sql • • nishika

2

0
Votes

2
Posts

0
Views

I would honestly get these SQL checks out to a programming language like C# if you were possible, but if you want to do it by SqlServer you must first link the services ( https://docs.microsoft.com/en-us/sql/relational-databases/linked-servers/linked-servers-database-engine?view=sql-server-2017 And once you do, you can do something like that:SELECT CASE WHEN t1.Id = t2.Identificador THEN 1 ELSE 0 END AS IdIguales, CASE WHEN t1.Nombre = t2.Descripcion THEN 1 ELSE 0 END AS NombreIguales, CASE WHEN t1.Fecha = t2.Creado THEN 1 ELSE 0 END AS FechaIguales, CASE WHEN t1.Cantidad = t2.Valor THEN 1 ELSE 0 END AS CantidadIguales FROM Server1.Db1.dbo.TablaPoC1 AS t1 INNER JOIN Server2.Db2.dbo.TablaPoC2 AS t2 ON t1.Id = t2.Identificador I've invented the names of the boards and columns, but you can do something simily with yours.If you can tell us, I hope I helped you.
J

I can't deal with the into the database.
Software Programming • php sql • • juvenalb

2

0
Votes

2
Posts

0
Views

C

I don't get it. I'll try.You've got to cut all your guts.The directory's path is to keep the picture in the class, not inside the cardboard method.The reference to the loaded and copied file can also be stored in the class field.Something like that:class MySuperNothingClass { private $uploadDir = "image/uploads/"; private $uploadedImgPath = ''; private $flashMessage = ''; public function upload(){ if (is_uploaded_file($_FILES['upload_photo']['tmp_name'])) { $ext = ''; if ($_FILES['userfile']['error'] !== UPLOAD_ERR_OK) { $this->$flashErrorMessage = "<script type=\"text/javascript\">parent.document.getElementById(\"image_upload_status\").innerHTML = '<p class=\"image_error\">Произошла ошибка при загрузке файла</p>';</script>"; return false; } if ($_FILES['upload_photo']['size'] > 512000) { $this->$flashErrorMessage = "<script type=\"text/javascript\">parent.document.getElementById(\"image_upload_status\").innerHTML = '<p class=\"image_error\">Недопустимый размер файла</p>';</script>"; return false; } $ext = pathinfo($_FILES['upload_photo']['name'], PATHINFO_EXTENSION); if ($ext != 'gif' && $ext != 'jpeg' && $ext != 'jpg' && $ext != 'png') { $this->$flashErrorMessage = "<script type=\"text/javascript\">parent.document.getElementById(\"image_upload_status\").innerHTML = '<p class=\"image_error\">Недопустимый тип файла</p>';</script>"; return false; } $upload_photo = $_FILES['upload_photo']['name']; $uploadedPath = $this->uploadDir . uniqid($upload_photo); if (copy($_FILES['upload_photo']['tmp_name'], $uploadedPath)) { $this->uploadedImgPath = $uploadedPath; $this->$flashErrorMessage = "<script type=\"text/javascript\">parent.document.getElementById(\"imageId\").innerHTML = '<img src=\"image/uploads/demo.png\">'; parent.document.getElementById(\"image_upload_status\").innerHTML = '<p class=\"image_success\">Файил успешно загружено</p>';</script>"; return true; } return false; } } public function actionUploadImage() { if (!$this->upload()) { echo $this->flashMessage; return false; } // здесь работа с БД // ... $this->db->query("INSERT INTO `" . DB_PREFIX . "order` SET invoice_prefix = '" . $this->db->escape($data['invoice_prefix']) . "', store_id = '" . (int)$data['store_id'] . "', file = '" . $this->uploadedImgPath . "', store_name = '" . $this->db->escape($data['store_name']) . "', ... ... и т.д" ); echo $this->flashMessage; } } It appears that the text of the error was also made in the class field. Now, in a processor's method, we're asking for a method. upload()Did it go well or not? If not, we'll throw out the retained text of the error and finish the job. And if it's okay, That's it. We keep it in the database and we display the inscription that the file is downloaded.Well, the most important thing is, in fact, the method. upload Look, if copy() Makes it right, then we're going to the field. $uploadedImgPath and already. applicable in request.P. S. in method copy You've been writing for nothing. . $ext♪ You should've done that if you've divided a file from expansion somewhere, and now you need to stick it. But you didn't do it, so it's not necessary.P.P.S. to verify the identity of a particular type can be used http://php.net/manual/ru/function.exif-imagetype.php instead of what I wrote. Read it yourself.P.P.P.S. This code can be improved infinitely. But not knowing exactly how you're barking inside, I almost left everything there.
J

Complex query on big table
SQL, Database Testing • mysql performance • • jules

2

0
Votes

2
Posts

0
Views

D

You would save yourself a fortune in time by changing data types to `gender` varchar(1) -- or even `enum('m','f') `city` varchar (60) -- or something sane like that The index on these would be much more friendly to you and so much smaller. Trust me, the smaller and more exact you can make the data the easier it is to search. I would expect your search time to improve as you wish just by using the lighter (non object, as Manny pints out) data types. You could try something like ORDER BY active DESC, RAND() to select different results each time favouring active users. If you have a lot of inactive users to filter against then you might want to create a temporary table for just active users but to be honest these sorts of optimisations are case specific and a few tests are sometimes the best way to know if they are worth your while.
M

MYSQL Search for dates and exclude those between Friday 17:00 and Sunday 17:00
Software Programming • php mysql sql • • meriah

2

0
Votes

2
Posts

0
Views

J

You can use the function DAYOFWEEK() from MYSQL to get the day of the week and discard it, in fact you can read it on https://www.w3schools.com/sql/func_mysql_dayofweek.asp#:~:text=The%20DAYOFWEEK()%20function%20returns,%3DFriday%2C%207%3DSaturday. As for your query to determine a query considering three months to the past you can use MYSQL funcuion DATE_SUB() https://www.w3schools.com/sql/func_mysql_date_sub.asp with which there are other time intervals, now if you consider that we already have 2 out of 3 parts of your code and if you consider the operator BETWEEN of MYSQL https://www.w3schools.com/sql/sql_between.asp your query could stay more or less the following waySELECT * FROM table WHERE id NOT IN (SELECT id FROM table WHERE DAYOFWEEK(timestamp) = 6 AND TIME(timestamp) >= "17:00:00" OR DAYOFWEEK(timestamp) = 7 OR DAYOFWEEK(timestamp) = 1 AND TIME(timestamp) <= "17:00:00") AND DATE(timestamp) BETWEEN DATE_SUB(DATE(NOW()), INTERVAL 3 MONTH) AND NOW();
J

How do you write a SQL request to put two columns from another table in the table?
Software Programming • sql server sql • • jonetta

2

0
Votes

2
Posts

0
Views

O

You probably want to join the same table twice. That's what they need to give different alias. Actually, in my view, the code is more compact and readable.Somehow:SELECT avc.Name AS Авиакомпания, ps.Model AS Самолёт, ctyFrom.Name AS Откуда, ctyTo.Name AS Куда, ... FROM [airport].[dbo].FlightsCurrentSet fc INNER JOIN [airport].[dbo].AviacompaniesSet avc ON avc.Id = fc.AviacompanyID INNER JOIN [airport].[dbo].PlanesSet ps ON ps.Id = fc.PlaneID INNER JOIN [airport].[dbo].CitiesSet ctyFrom ON ctyFrom.Id = fc.fromID INNER JOIN [airport].[dbo].CitiesSet ctyTo ON ctyTo.Id = fc.toID
J

Mysql for c#. Target model as Sqlite
Software Programming • mysql c sharp database • • juvenalb

2

0
Votes

2
Posts

0
Views

T

I personally use PetaPoco for the same task. I'll bet you a packet. Especially since the base has already been established.Examples of the peta-wait code are here: https://github.com/CollaboratingPlatypus/PetaPoco Entity's going to be dealt with, and it's slow enough. If you want it, you're gonna have to put it like that with a sniff-package.
How to condition the insertion of a SQL registry Server?
Software Programming • sql server sql insert tsql • • irl

2

0
Votes

2
Posts

0
Views

You can use one http://msdn.microsoft.com/en-us/library/bb510625.aspx (available from SQL Server 2008):MERGE DatasBase AS existentes USING (SELECT '2013-12-13', '2013-12-14') AS novos (DateBase, DataAtualizacao) ON (existentes.DateBase = novos.DateBase) WHEN MATCHED THEN UPDATE SET DataAtualizacao = novos.DataAtualizacao WHEN NOT MATCHED THEN INSERT (DateBase, DataAtualizacao) VALUES (novos.DateBase, novos.DataAtualizacao); http://sqlfiddle.com/#!6/797ae/16
T

As I must relate two tables
Software Programming • mysql • • Trenton

2

0
Votes

2
Posts

0
Views

G

Looks like you need to create an additional table that supports your relationship from many to many between tables motor and combustible. This would make you less redundant. So:CREATE TABLE combustible_motor ( id INT PRIMARY KEY AUTO_INCREMENT, idCombustible INT NOT NULL, idMotor INT NOT NULL, FOREIGN KEY (idCombustible) REFERENCES combustible (idCombustible), FOREIGN KEY (idMotor) REFERENCES motor (idMotor) ); And there you associate the records of both tables.INSERT INTO combustible_motor (idCombustible, idMotor) VALUES (1, 1), -- el primer 1 refiere a tu combustible Diesel y el segundo 1 al motor de 2.5cc (2, 1) -- el 2 refiere a tu combustible Gasolina y el 1 al motor de 2.5cc; Just in case, doing this means you're gonna have to remove the direct relationship between your board. combustible towards your board motor.
B

Charts google returning empty php mysql
Software Programming • php mysql google c languageharts • • Burma

2

0
Votes

2
Posts

0
Views

K

Your code is not passing the data in the right way. See this example:<?php $con = mysqli_connect('hostname','username','password','database'); ?> <!DOCTYPE HTML> <html> <head> <meta charset="utf-8"> <title> Create Google Charts </title> <script type="text/javascript" src="https://www.google.com/jsapi"></script> <script type="text/javascript"> google.load("visualization", "1", {packages:["corechart"]}); google.setOnLoadCallback(drawChart); function drawChart() { var data = google.visualization.arrayToDataTable([ ['Date', 'Visits'], <?php $query = "SELECT count(ip) AS count, vdate FROM visitors GROUP BY vdate ORDER BY vdate"; $exec = mysqli_query($con,$query); while($row = mysqli_fetch_array($exec)){ echo "['".$row['vdate']."',".$row['count']."],"; } ?> ]); var options = { title : 'Date wise visits' }; var chart = new google.visualization.ColumnChart(document.getElementById("columnchart")); chart.draw(data, options); } </script> </head> <body> <h3>Column Chart</h3> <div id="columnchart" style="width: 900px; height: 500px;"></div> </body> </html> Just adapt to your code, changing query and options.
D

Select (filter by column) from. Does that exist?
Software Programming • sql oracle sqldeveloper • • Duquan

2

0
Votes

2
Posts

0
Views

N

You can. generate dynamically the consultation, to execute it.For example, this anonymous block that I leave below generates a query select for a board. You must adjust the name of the owner, the name of the table and the value that must exist in the name of the columns you want to include in the select which will result.In the end, print on screen the query so you can copy it and paste it wherever you want to run it.declare miSelect varchar2(10000); tOwner varchar2(100); tName varchar2(200); cContenido varchar2(100); cursor cols (aOwner varchar2, aTable varchar2, aContenido varchar2) is select column_name from all_tab_cols tc where tc.owner = aOwner and tc.table_name = aTable and column_name like '%' || aContenido || '%'; begin tOwner := 'CO'; tName := 'PRODUCTS'; cContenido := 'P'; for rCol in cols(tOwner, tName, cContenido) loop if (miSelect is null) then miSelect := '"' || rCol.column_name || '"'; else miSelect := miSelect || ', ' || '"' || rCol.column_name || '"'; end if; end loop; miSelect := 'select ' || miSelect || ' from ' || tOwner || '.' || tName || ';'; dbms_output.put_line(miSelect); end; The example lists all columns of the table CO.PRODUCTS that have a letter 'P' as part of the name, https://livesql.oracle.com/apex/livesql/s/kmahdclh2exfdnciwwblewt9c , where it generates this result:select "PRODUCT_ID", "PRODUCT_NAME", "UNIT_PRICE", "PRODUCT_DETAILS", "PRODUCT_IMAGE", "IMAGE_MIME_TYPE", "IMAGE_LAST_UPDATED" from CO.PRODUCTS; You can run the online script https://livesql.oracle.com/apex/livesql/s/kmahdclh2exfdnciwwblewt9c .
Relationship of two tables _
Software Programming • sql • • jeanid

2

0
Votes

2
Posts

0
Views

O

Correct me if I have misunderstood the question, but I think you need it:SELECT ii.sku, ii.cod_setor, ia.setor_ini, ia.setor_fim, ia.desc_ambiente, ii.cod_coletor FROM item_inventarios ii inner join inventario_ambientes ia on ii.id_inventario = ia.id_inventario and ii.cod_setor between setor_ini and setor_fim WHERE ii.id_inventario = '46' order by 1

work on the two tables

Suggested Topics

How do tie the two tables? Software Programming • mysql • • inna

Integration of two tables Software Programming • php mysql sql • • Kadyn

How do you work with two branches at the same time? Software Programming • git • • Alberto

Increase values after an INSERT Software Programming • mysql c sharp visual studio • • Pearlaqua

Comparison of two tables Software Programming • sql server sql • • nishika

I can't deal with the into the database. Software Programming • php sql • • juvenalb

Complex query on big table SQL, Database Testing • mysql performance • • jules

MYSQL Search for dates and exclude those between Friday 17:00 and Sunday 17:00 Software Programming • php mysql sql • • meriah

How do you write a SQL request to put two columns from another table in the table? Software Programming • sql server sql • • jonetta

Mysql for c#. Target model as Sqlite Software Programming • mysql c sharp database • • juvenalb

How to condition the insertion of a SQL registry Server? Software Programming • sql server sql insert tsql • • irl

As I must relate two tables Software Programming • mysql • • Trenton

Charts google returning empty php mysql Software Programming • php mysql google c languageharts • • Burma

Select (filter by column) from. Does that exist? Software Programming • sql oracle sqldeveloper • • Duquan

Relationship of two tables _ Software Programming • sql • • jeanid

How do tie the two tables?
Software Programming • mysql • • inna

Integration of two tables
Software Programming • php mysql sql • • Kadyn

How do you work with two branches at the same time?
Software Programming • git • • Alberto

Increase values after an INSERT
Software Programming • mysql c sharp visual studio • • Pearlaqua

Comparison of two tables
Software Programming • sql server sql • • nishika

I can't deal with the into the database.
Software Programming • php sql • • juvenalb

Complex query on big table
SQL, Database Testing • mysql performance • • jules

MYSQL Search for dates and exclude those between Friday 17:00 and Sunday 17:00
Software Programming • php mysql sql • • meriah

How do you write a SQL request to put two columns from another table in the table?
Software Programming • sql server sql • • jonetta

Mysql for c#. Target model as Sqlite
Software Programming • mysql c sharp database • • juvenalb

How to condition the insertion of a SQL registry Server?
Software Programming • sql server sql insert tsql • • irl

As I must relate two tables
Software Programming • mysql • • Trenton

Charts google returning empty php mysql
Software Programming • php mysql google c languageharts • • Burma

Select (filter by column) from. Does that exist?
Software Programming • sql oracle sqldeveloper • • Duquan

Relationship of two tables _
Software Programming • sql • • jeanid