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).

Best organization of the OBD table

E
emerson last edited by

What is it better to create in the table a field of kolvo_comments (when comments are made) or simply to count the number of notes in the table with commentaries? So there's no heavy load. Probably the first option?
Reply Quote 0
1 Reply Last reply
J
juvenalb last edited by
In the table of comments, use:
```
SELECT COUNT(comments) FROM ...
```
It'll take a number of lines in the pole. If the move InnoDBthe sample will be quick and loaded on the server, skeletons, too.
If you create a column with the number of comments. You'll have to arrange either an automatic recalculation or permanently adding a comment, an extra +1 in the line. kolvo_comments♪
INSERT♪ UPDATEAnd especially automation, the server gets more tense than SELECT♪
Reply Quote 0
1 Reply Last reply

2
Posts

0
Views

Suggested Topics

Z

Data from a table Not contained in Table B
Software Programming • php mysql • • zymir

2

0
Votes

2
Posts

0
Views

K

Doing without subquery, just make a WHERE and return all who have idCartao null. It would be like this:SELECT * FROM usuario as u LEFT JOIN cartao as c ON (c.IdUsuario = u.Id)//Altere aqui para igual WHERE c.id is null//retorne todos que não possuem cartão
S

How can all the lines of the first table be removed when inner joining the two tables in the second table?
Software Programming • sql server sql • • shizuka

2

0
Votes

2
Posts

0
Views

N

One option could be the introduction of a variable flog, whose condition is determined by the existence/ absence of lines @ListNumberand use left join instead inner join Flag verification where:declare @listEmpty bit; if not exists (select * from @ListNumber) set @listEmpty = 1; select t.Num, sum(t.KOLVO) as kol from table1 t left join @ListNumber l on l.Num = t.Num where t.column1 > 100 and (@listEmpty = 1 or l.Num is not NULL) group by t.Num; Another option is the injection. If @ListNumber There are lines to join her, if not to:if exists (select * from @ListNumber) select t.Num, sum(t.KOLVO) as kol from table1 t join @ListNumber l on l.Num = t.Num where t.column1 > 100 group by t.Num; else select t.Num, sum(t.KOLVO) as kol from table1 t where t.column1 > 100 group by t.Num;
B

performance issue on using ip2location for group of ips
SQL, Database Testing • mysql performance • • Burma

2

0
Votes

2
Posts

0
Views

E

Please qualify all columns with what table they are in. Meanwhile, I will guess that ip_from and ip_to are in ip_city. A problem is that the tables are over-normalized. ip_city -> cities -> country instead of having a single table slows down the query. But the main problem is that there is no good index for ip between ip_from AND ip_to. Any index with ip_from and/or ip_to can, at best, limit the effort down to scanning half the table. That's O(N). To get to O(1), see http://mysql.rjweb.org/doc.php/ipranges . Sorry, it is rather involved. A first cut at improving your existing schema: CREATE TABLE `cities` ( `id` MEDIUMINT UNSIGNED NOT NULL, `name` varchar(50) NOT NULL, `country_code` CHAR(2) CHARACTER SET ascii NOT NULL, `latitude` FLOAT DEFAULT NULL, `longitude` FLOAT DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `ips` ( `ip` varchar(39) CHARACTER SET ascii NOT NULL, ip_packed BINARY(16) NOT NULL `user_id` int(10) UNSIGNED NOT NULL, `created_at` timestamp NULL DEFAULT NULL PRIMARY KEY(ip) ) ENGINE=InnoDB DEFAULT CHARSET=ascii; CREATE TABLE `ip_city` ( `ip_from` BINARY(16) DEFAULT NULL, `ip_to` BINARY(16) DEFAULT NULL, `city_id` int(11) UNSIGNED NOT NULL, PRIMARY KEY(ip_from, ip_to), INDEX(city_id) -- if desired ) ENGINE=InnoDB DEFAULT; That included getting rid if id when there were good 'natural' PKs, handling IPv6, using standard 2-letter country_codes, tossing the country table, using ascii where appropriate, etc. See my link for further discussion, including why FLOAT is better.
B

Automysqlbackup fix error "Skipping the data of table mysql.event. Specify the --events option explicitly"
SQL, Database Testing • mysql mysqldump • • baileigh

2

0
Votes

2
Posts

0
Views

In answer to the Server Fault question How to avoid mysqldump warning “Skipping the data of table mysql.event”: User Shane on a bike wrote: Modify or Create your ~/.my.cnf and create a mysqldump section by adding the following [mysqldump] events ignore-table = mysql.events
Z

not in in the same table
Software Programming • sql pl sql orac languagele12c langua • • zymir

2

0
Votes

2
Posts

0
Views

D

You need to check if the customer has null contracts, the way it did is checking the entire table without specifying this:SELECT con_customer FROM con_contratos C1 WHERE NOT EXISTS (SELECT * FROM con_contratos C2 WHERE C1.con_customerId = C2.con_customerId AND C2.con_vencimento IS NULL);
C

Where do you put the logic of server scrips in php on the server or JS on the client?
Software Programming • javascript php mvc architecture structures • • Cleofas

2

0
Votes

2
Posts

0
Views

C

Controller - JSC Script, which, depending on the task, causes various php crypts on the server. To call various php violators on the server has long been a bad practice. Modern MVC applications have a single entry point. Look at the popular MVC Freamworths - Laravel, Symfony, Yii2, etc. They're all using rolling.If you don't use the Framworths, look towards a little library. https://github.com/bramus/router ♪ The Library is established through composer.But if you don't use composer in your projects (I met in 2018 apprenticeships who sit in php 5.3 it's fatigue,) I'm very recommending that the gaps in the bases of the class loading and the management of dependence be closed first.
R

Vulnerability in restricted eval
Security, Penetration Testing • php web application appsec language • • rielyn

2

0
Votes

2
Posts

0
Views

No, that's not exploitable. All variables in the string you're passing to eval() are \-escaped, so they don't get expanded. This means you're always literally evaluating... $RequestVariables = $_REQUEST; ...which is just an ordinary assignment without any possibility to inject your own code. What if they were not \-escaped? In that case you're still out of luck because $_REQUEST and $_SERVER are guaranteed to be arrays, and the string representation of an array is always just Array, not displaying any contained values.
J

How do I backup my database from my web with php?
Software Programming • php html mysql • • jules

2

0
Votes

2
Posts

0
Views

A

Stackoverflow serves to help you evacuate specific doubts, in your case you're asking how to make a complete system.What I can answer to your question is that you must select from the entire database and then convert it into a CSV (excell file) or maybe there is some tool that exports you to sql from the database, something like that. https://github.com/2createStudio/shuttle-export Greetings
T

Intermediate table for communication of three tables
Software Programming • php laravel • • terrea

2

0
Votes

2
Posts

0
Views

E

It's easy. category to attributes -to-Many - It's Many-to-ManyWhat does the values have to do with the category? You can easily get them through attributes.
E

How to get link from any anchor, using regular expression?
Software Programming • php regex • • elysha

2

0
Votes

2
Posts

0
Views

A

Try this way, ignoring what is between a and href:preg_match_all('/<a.*href="(.*)"/i', $resultado, $outros); I hope I helped!
Connection to Bitrix24
Software Programming • php bitrix data base • • carriann

2

0
Votes

2
Posts

0
Views

K

Bd's structure is not so simple, and it's likely that you'll lose some of the data directly through the table. If there's any way, you better pull the data in the bricks and make some sort of sv file, and then move all the necessary data to your website. Clarify what you want.
How to filter the table from another table
Software Programming • python python 3.x django django rest framework • • Demir

2

0
Votes

2
Posts

0
Views

F

First, you're not right. related_namecourse = models.ForeignKey(Course, related_name='course', on_delete=models.CASCADE) student = models.ForeignKey(Student, related_name='student', on_delete=models.CASCADE) What? related_name This is the name of the properties of the associated object used to address the object in which the link is identified.Which means that for students, related_name should, for example, participantion♪ For courses - participants♪Then access to these data from the facility Student It's gonna look like that.# student - объект Student student.participantion.all() # queryset модели CourseParticipant Now on the question. Based on my advice, you should write:potential = Student.objects.exclude(participantion__course=pk) For your example, without my right.potential = Student.objects.exclude(student__course=pk)
B

I can't insert data into my text file.
Software Programming • php arc languagehivo servidor • • Burma

2

0
Votes

2
Posts

0
Views

C

Try file_put_contents($filename, $content) instead of fwrite, this is good for you to use php5.You can show the code where you try to write the data to the file. !
see tables of a dB and columns of those tables
Software Programming • sql server sql • • irl

2

0
Votes

2
Posts

0
Views

C

The most compatible way to consult the tables of a database, is to view directly sysobjects:-- Para consultar las tablas de master select * from master..sysobjects where xtype = 'U' xtype = 'U' allows filtering "user files". You can combine the previous consultation with the view syscolumns to see the tables with their columns:select o.name as tablename, c.name from master..sysobjects o inner join master..syscolumns c on o.id = c.id where o.xtype = 'U' These views have been maintained throughout many versions, however Microsoft recommends using new views sys.objects and sys.columnsamong others ( https://docs.microsoft.com/en-us/sql/relational-databases/system-compatibility-views/sys-sysobjects-transact-sql?view=sql-server-ver15 ).
How to setate HTML attribute with @yield() in Laravel?
Software Programming • php laravel template attributes • • Alberto

2

0
Votes

2
Posts

0
Views

Assuming that dashboard is the name of your route, you need to convert to a valid url before returning to the href.Try the following:@extends('../layouts.master') @section('voltar') link_to_route('dashboard') @stop More information http://laravel.com/docs/4.2/responses#views

Best organization of the OBD table

Suggested Topics

Data from a table Not contained in Table B Software Programming • php mysql • • zymir

How can all the lines of the first table be removed when inner joining the two tables in the second table? Software Programming • sql server sql • • shizuka

performance issue on using ip2location for group of ips SQL, Database Testing • mysql performance • • Burma

Automysqlbackup fix error "Skipping the data of table mysql.event. Specify the --events option explicitly" SQL, Database Testing • mysql mysqldump • • baileigh

not in in the same table Software Programming • sql pl sql orac languagele12c langua • • zymir

Where do you put the logic of server scrips in php on the server or JS on the client? Software Programming • javascript php mvc architecture structures • • Cleofas

Vulnerability in restricted eval Security, Penetration Testing • php web application appsec language • • rielyn

How do I backup my database from my web with php? Software Programming • php html mysql • • jules

Intermediate table for communication of three tables Software Programming • php laravel • • terrea

How to get link from any anchor, using regular expression? Software Programming • php regex • • elysha

Connection to Bitrix24 Software Programming • php bitrix data base • • carriann

How to filter the table from another table Software Programming • python python 3.x django django rest framework • • Demir

I can't insert data into my text file. Software Programming • php arc languagehivo servidor • • Burma

see tables of a dB and columns of those tables Software Programming • sql server sql • • irl

How to setate HTML attribute with @yield() in Laravel? Software Programming • php laravel template attributes • • Alberto

Data from a table Not contained in Table B
Software Programming • php mysql • • zymir

How can all the lines of the first table be removed when inner joining the two tables in the second table?
Software Programming • sql server sql • • shizuka

performance issue on using ip2location for group of ips
SQL, Database Testing • mysql performance • • Burma

Automysqlbackup fix error "Skipping the data of table mysql.event. Specify the --events option explicitly"
SQL, Database Testing • mysql mysqldump • • baileigh

not in in the same table
Software Programming • sql pl sql orac languagele12c langua • • zymir

Where do you put the logic of server scrips in php on the server or JS on the client?
Software Programming • javascript php mvc architecture structures • • Cleofas

Vulnerability in restricted eval
Security, Penetration Testing • php web application appsec language • • rielyn

How do I backup my database from my web with php?
Software Programming • php html mysql • • jules

Intermediate table for communication of three tables
Software Programming • php laravel • • terrea

How to get link from any anchor, using regular expression?
Software Programming • php regex • • elysha

Connection to Bitrix24
Software Programming • php bitrix data base • • carriann

How to filter the table from another table
Software Programming • python python 3.x django django rest framework • • Demir

I can't insert data into my text file.
Software Programming • php arc languagehivo servidor • • Burma

see tables of a dB and columns of those tables
Software Programming • sql server sql • • irl

How to setate HTML attribute with @yield() in Laravel?
Software Programming • php laravel template attributes • • Alberto