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

How to post a table in the topics or reply to comments?

Eugene Founder

This is example of posting a table in in the topics or 'reply to' comments:

| # | Column Header 1  | Column Header 2 | Column Header 3 |
|:-------------:|:-------------:|:-------------:|:-------------:|
| 1 | Column A | Column B | Column C |
| 2 | Column A | Column B | Column C |

1
Posts

6
Views

Suggested Topics

E

Privacy Policy
About software-testing.com • privacy policy • • Eugene

1

0
Votes

1
Posts

18
Views

No one has replied
S

Field value related to another field of another table?
Software Programming • sql databank table ms access • • simrah

2

0
Votes

2
Posts

0
Views

E

A database is composed of several tables, such as: Customers, Products, Orders, Order Details, etc. Although the information is separated in each of the Tables, in practice there should be relationships between the tables. For example: An Order is made by a Customer and in this Order there may be several items, items that are recorded in the Order Details table. In addition, each Order has a unique number (Application Code), but one Client can make several requests and so on.In a database, we need some way to represent these real-life relationships in terms of tables and their attributes. This is possible with the use of "Relationships between tables", which can be of three types:One for OneOne for MultipleVarious for VariousType Relationship One for One:This relationship exists when the fields that relate are both of the Primary Key type, in their respective tables. Each of the fields does not have repeated values. In practice there are few situations where we will use such a relationship. An example could be the following: Imagine a school with a Student Registration in the Student Table, from these only a small part participates in the School Band. For database design issues, we can create a Second Table "Band Students", which relates to the table Students through a type relationship One for One. Each student is only registered once in the Student Table and once in the Band Students table. We could use the Aluno Matricula Field as the Field that relates the two Tables.Important: The field that relates two tables should be part, have been defined, in the structure of the two tables.In the Band Students table we could put only the student's Number of Film, in addition to the information about the Instrument he plays, band time, etc. When it was necessary to search for information such as name, address, etc., these can be recovered through the existing relationship between the two tables, thus avoiding that the same information (Name, Address, etc.) has to be duplicated in both tables, including increasing the probability of typing errors. Type Relationship One for Multiple:This is certainly the most common type of relationship between two tables. One of the tables (the one side of the relationship) has a field that is the Primary Key and the other table (the various side) relates through a field whose related values can be repeated several times.Consider the example between the Customers and Orders table. Each Client is only registered once in the Customers table (so the Customer Code field, in the Customers table, is a primary key, indicating that two clients cannot be registered with the same code), so the Customers table will be the side one of the relationship. At the same time, each client can make a number of requests, so that the same Customer Code may appear several times in the Orders table: as many times as many requests the Customer has made. That's why we have a kind of relationship One for several of the Customers and Orders table, through the Customer Code field, indicating that the same Customer can carry out several (various) requests. Various type ratio for multiple:This kind of relationship "contested" in a situation where on both sides of the relationship the values could repeat themselves. We will consider the case between Products and Orders. I may have several Orders in which a particular product appears, in addition several Products may appear in the same Order. This is a situation where we have a Various Type Relationship for Various.In practice it is not possible to implement such a relationship, due to a number of problems that would be introduced in the database model. For example, in the table We would have to repeat the Order Number, Customer Name, Employee Name, Order Date, etc for each Order item. http://www.uel.br/pessoal/valerio/08%20Criar%20relacionamento%20no%20access%20-%201%20folha.pdf
J

How bad is to prefix table names to order them exactly as I want?
SQL, Database Testing • mysql table best practices • • Jolied

2

0
Votes

2
Posts

1
Views

K

Its (more than) a little insane. If you add a account_post_comment field you need to renumber and rework all of your code. Better is if you use alter table (or CREATE TABLE to add a comment and use this). ALTER TABLE account_post COMMENT '03' To retrieve in order use the information_schema.tables SELECT TABLE_SCHEMA, TABLE_NAME, TABLE_COMMENT FROM information_schema.tables WHERE table_schema = 'db_name' ORDER BY TABLE_COMMENT
S

How to use the canvas and SimpleDocTemplate mutually? (reportlab)
Software Programming • table canvas reportlab • • shizuka

2

0
Votes

2
Posts

0
Views

G

We're not joining the Canvas method with SimpleDocTemplate, it doesn't make sense. After several researches what I've come up with is that Canvas is great for generating text, simpler documents and for initially to realize a bit of the library reportlabThe solution I got was the following:I imported two more variants of the reportlab and kept the same code to generate the table.from reportlab.platypus import Paragraph from reportlab.lib.styles import ParagraphStyle elements = [] data= [['Periodo a que diz respeito', startdate + ' a ' + enddate], [' ', ' '], ['Horas despendidas no período de 01/01/2021 a 20/01/2021', '271,04'], ['Por rubrica:', ' ']] t=Table(data) t.setStyle(TableStyle([('BOX', (0,0), (-1,-1), 0.25, colors.black), ('INNERGRID', (0,0), (-1,-1), 0.25, colors.black), ('ALIGN',(1,1),(-3,-3),'RIGHT'), ('VALIGN',(0,-1),(-1,-1),'MIDDLE'), ('TEXTCOLOR',(0,0),(1,-1),colors.black)])) The text is being added to the array elements through the variable Paragraph of the reportlab. The style variable is the one that will give another aspect to this text.style = ParagraphStyle('heading1', fontName = 'Helvetica-Bold', fontSize = 20, textColor = colors.black, leading = 20) elements.append(Paragraph('RELATÓRIO FEVEREIRO 2021', style)) elements.append(Paragraph('PROJECTOS', style)) elements.append(Paragraph('TIVOLI HOTEIS', style)) elements.append(t)#adiciona a tabela à variavel elements pdf = SimpleDocTemplate('exemple3.pdf', pagesize=A4) pfd.build(elements) Finally, 'pdf.build(elements)' will add the text and table to the PDF report, with the formatting configured.I'm new around here, I'm sorry if I didn't explain well. Feel free to ask questions.
E

Suggest a new Category or Subcategory
About software-testing.com • categories • • Eugene

1

0
Votes

1
Posts

12
Views

No one has replied
M

Edge on the TR not appearing
Software Programming • css table • • meriah

2

0
Votes

2
Posts

0
Views

C

According to http://www.w3.org/TR/CSS21/tables.html#borders of the recommendation:Rows, columns, row groups, and column groups cannot have borders (i.e., user agents must ignore the border properties for those elements). http://www.w3.org/TR/CSS21/tables.html#collapsing-borders :In the collapsing border model, it is possible to specify borders that surround all or part of a cell, row, row group, column, and column Group. Borders for HTML's "rules" attribute can be specified this way.To "fix" this problem just add the rule border-collapse: collapse to your table (class rwd-table). Look at that. https://developer.mozilla.org/en-US/docs/Web/CSS/border-collapse .Follow the code posted by you already with the rule set:.rwd-table { margin: 1em 0; min-width: 300px; border-collapse: collapse /* Alteração */ } .rwd-table tr { border-top: 1px solid #ddd; border-bottom: 1px solid #ddd; } .rwd-table tr:first-child { border-top: none /* para não exibir uma linha antes da tabela */ } .rwd-table tr:last-child { border-bottom: none /* para não exibir uma linha depois da tabela */ } .rwd-table th { display: none; } .rwd-table td { display: block; } .rwd-table td:first-child { padding-top: .5em; } .rwd-table td:last-child { padding-bottom: .5em; } .rwd-table td:before { content: attr(data-th) ": "; font-weight: bold; width: 6.5em; display: inline-block; } @media (min-width: 480px) { .rwd-table td:before { display: none; } } .rwd-table th, .rwd-table td { text-align: left; } @media (min-width: 480px) { .rwd-table th, .rwd-table td { display: table-cell; padding: .25em .5em; } .rwd-table th:first-child, .rwd-table td:first-child { padding-left: 0; } .rwd-table th:last-child, .rwd-table td:last-child { padding-right: 0; } } h1 { font-weight: normal; letter-spacing: -1px; color: #34495E; } .rwd-table { background: #34495E; color: #fff; border-radius: .4em; overflow: hidden; } .rwd-table tr { border-color: #46627f; } .rwd-table th, .rwd-table td { margin: .5em 1em; } @media (min-width: 480px) { .rwd-table th, .rwd-table td { padding: 1em !important; } } .rwd-table th, .rwd-table td:before { color: #dd5; }<style class="cp-pen-styles">@import "http://fonts.googleapis.com/css?family=Montserrat:300,400,700"; .rwd-table { margin: 1em 0; min-width: 300px; } .rwd-table tr { border-top: 1px solid #ddd; border-bottom: 1px solid #ddd; } .rwd-table th { display: none; } .rwd-table td { display: block; } .rwd-table td:first-child { padding-top: .5em; } .rwd-table td:last-child { padding-bottom: .5em; } .rwd-table td:before { content: attr(data-th) ": "; font-weight: bold; width: 6.5em; display: inline-block; } @media (min-width: 480px) { .rwd-table td:before { display: none; } } .rwd-table th, .rwd-table td { text-align: left; } @media (min-width: 480px) { .rwd-table th, .rwd-table td { display: table-cell; padding: .25em .5em; } .rwd-table th:first-child, .rwd-table td:first-child { padding-left: 0; } .rwd-table th:last-child, .rwd-table td:last-child { padding-right: 0; } } h1 { font-weight: normal; letter-spacing: -1px; color: #34495E; } .rwd-table { background: #34495E; color: #fff; border-radius: .4em; overflow: hidden; } .rwd-table tr { border-color: #46627f; } .rwd-table th, .rwd-table td { margin: .5em 1em; } @media (min-width: 480px) { .rwd-table th, .rwd-table td { padding: 1em !important; } } .rwd-table th, .rwd-table td:before { color: #dd5; } </style></head><body> <h1>RWD List to Table</h1> <table class="rwd-table"> <tr> <th>Movie Title</th> <th>Genre</th> <th>Year</th> <th>Gross</th> </tr> <tr> <td data-th="Movie Title">Star Wars</td> <td data-th="Genre">Adventure, Sci-fi</td> <td data-th="Year">1977</td> <td data-th="Gross">$460,935,665</td> </tr> <tr> <td data-th="Movie Title">Howard The Duck</td> <td data-th="Genre">"Comedy"</td> <td data-th="Year">1986</td> <td data-th="Gross">$16,295,774</td> </tr> <tr> <td data-th="Movie Title">American Graffiti</td> <td data-th="Genre">Comedy, Drama</td> <td data-th="Year">1973</td> <td data-th="Gross">$115,000,000</td> </tr> </table>
E

Suggest a new Group related to your job title
About software-testing.com • badge group • • Eugene

1

0
Votes

1
Posts

7
Views

No one has replied
I can't get the date on the table
Software Programming • mysql sql databank table • • Alberto

2

0
Votes

2
Posts

0
Views

R

Your select should be like this:SELECT h.h_dia FROM hh h WHERE cast(h.h_dia as date) = '2018-06-21' GROUP BY h.h_dia; When the field is date and time, if you put in the filter only the date it will understand that the time is 00:00:00 and will not return correctly, then as you want to filter only by date, you should convert the field only to date.If you want to filter by date and time please do as follows:SELECT h.h_dia FROM hh h WHERE h.h_dia = '2018-06-21 10:45:00' GROUP BY h.h_dia;
S

Redesigning a table that has a lot of columns (not always related)
SQL, Database Testing • database design table • • Saumya

2

0
Votes

2
Posts

0
Views

S

Not really an answer - but too big for a comment. Just a few ideas/discussion. "our database was never designed with ANY plan in mind" - I hear yeh, sister! Been there, done that. Once worked with a Btrieve (precursor to Pervasive) system that had 35,000 (not a typo - that's thirty five thousand) fields in one table. Agree with @timpone - hesitant about tables with > 30 fields. Tables should be like women - tall and slim, not short and fat :-). It's a lot of work to redesign. Start with core functionality - what's the minimum amount of tables required? I would consider PostgreSQL if I were you, but like @Austin, that's just my opinion. Read up on the different RDBMSs - check out their functionality. Is there anything that Btrieve has that they do/don't? As far as I can see, the main thing that Btrieve brought to the party was arrays - they are a breach of the relational model and should be avoided at all costs in an RDBMS. You say "a LARGE amount of them only store a CHAR(1) which can be Y/N. (Side note: am I correct in assuming BIT will take up less space?)". With space being so cheap these days, this is not really an issue.
O

Is it possible in the grid view to detect another grid view?
Software Programming • php html table yii • • obi

2

0
Votes

2
Posts

0
Views

For example:<?= GridView::widget([ 'dataProvider' => $dataProvider, ... , 'columns' => [ ... [ 'attribute' => 'your_attribute', 'format' => 'html', 'value' => function ($model) { $otherDataProvider = ...; return GridView::widget([ 'dataProvider' => $otherDataProvider, ... ]); }, ], ... ], ]); ?>
R

Insert data from 1 column to many columns in another table (using 1 line) in sql
SQL, Database Testing • mysql table • • rosemadder

2

0
Votes

2
Posts

0
Views

Find an example of a pivot table here.
C

How to deal with a table that exists in the ALL_OBJECTS table but cannot be selected
SQL, Database Testing • oracle table • • courtlanda

2

0
Votes

2
Posts

0
Views

R

Database objects with lowercase names need to have their name enclosed in double quotes when referenced Also, you left out the schema name. Try select * from SCHEMA_NAME."rca_related_materials";
N

Create a DELETE statement that deletes Models that haven’t had a purchase since December 31st 2014
SQL, Database Testing • database design sqlite table delete subquery • • nishika

2

0
Votes

2
Posts

0
Views

K

Your main issue is you're using an INNER JOIN between Machines and Orders which means only return the rows that match (in other words, only the rows where Orders exist). Rather you should use an OUTER JOIN, in this case a LEFT OUTER JOIN (which can simply be written as LEFT JOIN) so you get all the rows of Models and Machines, and the ones that don't have Orders will show a NULL value for the columns in the Orders table. Then you can use the WHERE clause to filter out anything but the rows without Orders by saying WHERE Orders.SerialNo IS NULL like so: DELETE FROM Model WHERE ID IN ( SELECT Model.ID FROM Model INNER JOIN Machines ON Model.ID = Machines.ModelNo LEFT JOIN Orders ON Machines.SerialNo = Orders.SerialNo AND Orders.OrderDate >= '2015-01-01' WHERE Orders.SerialNo IS NULL GROUP BY Model.ID ); The other issue you had was your OrderDate field is likely storing more than just the year (I'm assuming), so you need to specify the whole date (not just the year) when you do a direct comparison. I fixed that in the above query as well. Please read the resource I linked above on LEFT JOINS along with the other resources I provided you on your last post, specifically understanding the different join types and when to use them are very important concepts.

How to post a table in the topics or reply to comments?

Suggested Topics

Privacy Policy About software-testing.com • privacy policy • • Eugene

Field value related to another field of another table? Software Programming • sql databank table ms access • • simrah

How bad is to prefix table names to order them exactly as I want? SQL, Database Testing • mysql table best practices • • Jolied

How to use the canvas and SimpleDocTemplate mutually? (reportlab) Software Programming • table canvas reportlab • • shizuka

Suggest a new Category or Subcategory About software-testing.com • categories • • Eugene

Edge on the TR not appearing Software Programming • css table • • meriah

Suggest a new Group related to your job title About software-testing.com • badge group • • Eugene

I can't get the date on the table Software Programming • mysql sql databank table • • Alberto

Redesigning a table that has a lot of columns (not always related) SQL, Database Testing • database design table • • Saumya

Is it possible in the grid view to detect another grid view? Software Programming • php html table yii • • obi

Insert data from 1 column to many columns in another table (using 1 line) in sql SQL, Database Testing • mysql table • • rosemadder

How to deal with a table that exists in the ALL_OBJECTS table but cannot be selected SQL, Database Testing • oracle table • • courtlanda

Create a DELETE statement that deletes Models that haven’t had a purchase since December 31st 2014 SQL, Database Testing • database design sqlite table delete subquery • • nishika

Privacy Policy
About software-testing.com • privacy policy • • Eugene

Field value related to another field of another table?
Software Programming • sql databank table ms access • • simrah

How bad is to prefix table names to order them exactly as I want?
SQL, Database Testing • mysql table best practices • • Jolied

How to use the canvas and SimpleDocTemplate mutually? (reportlab)
Software Programming • table canvas reportlab • • shizuka

Suggest a new Category or Subcategory
About software-testing.com • categories • • Eugene

Edge on the TR not appearing
Software Programming • css table • • meriah

Suggest a new Group related to your job title
About software-testing.com • badge group • • Eugene

I can't get the date on the table
Software Programming • mysql sql databank table • • Alberto

Redesigning a table that has a lot of columns (not always related)
SQL, Database Testing • database design table • • Saumya

Is it possible in the grid view to detect another grid view?
Software Programming • php html table yii • • obi

Insert data from 1 column to many columns in another table (using 1 line) in sql
SQL, Database Testing • mysql table • • rosemadder

How to deal with a table that exists in the ALL_OBJECTS table but cannot be selected
SQL, Database Testing • oracle table • • courtlanda

Create a DELETE statement that deletes Models that haven’t had a purchase since December 31st 2014
SQL, Database Testing • database design sqlite table delete subquery • • nishika