Questions tagged [multirow]

92 questions
0
votes
1 answer

How I can draw vertical lines between columns in Latex?

How I can draw vertical lines between column 3 and 4, also between column 2 and 3? I used long table and \multirow and I wrap the text to become inside table but I do not know how I can draw lines between columns? the wrong result of code is…
RJFF
  • 37
  • 1
  • 5
0
votes
1 answer

Process Multiple Row by a MYSQL Store Procedure

I am facing some trouble inserting data into a table by Store Procedure. Please allow me to explain in details. I have a Three tables CREATE TABLE `table_1` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `s_id` INT(11) NOT NULL, `created` DATE…
Jhilom
  • 1,028
  • 2
  • 15
  • 33
0
votes
2 answers

to validate checkbox input for table using multiple rows

i using js to add multiple row in a particular table, but when submit the form all check box having the same value, so how can i validate this checkbox using js before submit so change value to if unchecked, i trying on that but got no solution,…
Apache
  • 1,796
  • 9
  • 50
  • 72
0
votes
0 answers

Insert Multiple Rows without selecting them to MySql Database

Im working on a Project right now I did the same thing in WinForms a couple months back, so im pretty new to WPF and now I need some help. I've been struggeling the past 2 Weeks with a multiple row insert from a DataGrid in WPF to my MySql…
0
votes
3 answers

How do I do a multirow formula?

I am trying to use a multirow formula to have a new calculated column but can't quite figure it out. Suppose I my data is this: x y 1 2 1 2 1 6 1 7 2 4 2 5 2 9 I want to create a calculated column z in which…
Tim Batten
  • 45
  • 7
0
votes
1 answer

Separating data in a row to multiple columns

I'm a relative newbie to MySQL. I have experimented with selects and joins to filter and combine data from different tables. One thing I'm struggling with is how to output more than one line for one row. Here is an example I've created to describe…
MLG
  • 3
  • 1
0
votes
1 answer

Codeigniter - Update Multiple Row With Select2

When entering 2 values collecting_id attribute and 2 values nama_driver attribute, and in database successfully input 2 rows, INPUT--> RESULT but if inputting 2 values collecting_id and 1 value nama_driver, then only 1 row entered into database…
Indra
  • 3
  • 5
0
votes
0 answers

SQL - Time-Series and multirow condition

I want to know how long 2 users have collaborated even on different action. I have a table like this: id | id_action | time -------------------------- 1 | A | 10:01 -------------------------- 2 | A | 10:02…
Fabioe
  • 9
  • 2
0
votes
0 answers

Sum or mean(aggregate) array across row in hive

Here is my problem, I have a table in hive with 2 columns, id and an array of double values. I want to add the double values across rows for a given users. This is how the data looks like. Each array is of same length greater than 100 but for…
abhijit
  • 1
  • 3
0
votes
1 answer

How can I copy a multiline and multirow text inside a textarea and paste to a sheet?

I am trying to paste a text in a textarea and paste it in a sheet, like a Ctrl+shift+V command. The following script only paste in one cell, but I want to paste the way that span in the sheet (like copy and paste in Ctrl+shift+v). Here comes the…
0
votes
0 answers

PHP Insert multiple records into MySQL

I have some code for simultaneously inserting several records in MySQL. Here is the form and the request to insert into the database. So everything works fine, but when I try to add to the query and the current date, for example. Then, when I send…
0
votes
1 answer

Adding Mulitple table rows into mysql database

Here is a table for a challan. On clicking the "Add Product" Button, a new row is added to the table. My issue here is that how should I create a table in MySQL Database so that I can add data from multiple rows into the database table. Here is…
0
votes
1 answer

Update table (col1 through col4) where exists throws single-row returns more than one row error

The sql statement below is throwing an error: ORA-01427: single-row subquery returns more than one row UPDATE TABLE_1 T1 SET ( COL1, COL2, COL3, COL4) = ( SELECT col1 , col2 , col3 , col4 …
udflyerfan
  • 11
  • 1
0
votes
1 answer

SQL Server Multi-row insert trigger

I have tested that trigger but it works only with one insert row. The trigger fails with multiple-row insert and I didn't find the syntax to fix the trigger. Any suggestion to fix that? Thanks to the stackoverflow users that let me notice the…
overcomer
  • 2,244
  • 3
  • 26
  • 39
0
votes
1 answer

latex combining multirow and multicolumn

I noticed some strange behaviour when combining \multirow with \multicolumn: head 1.1 should vertically centred. head 1.2 is supposed to be vertically and horizontally centred Is there an alternative solution to \multirow and \multicolumn for…
thomas
  • 43
  • 1
  • 6