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

Question of laying poles from mysql table

K
kalyn last edited by

Hello! Table with two values
ID_IL,IL_LVL,IL_CLASS,IL_NAME,IL_COST,IL_KEY,IL_MIN_DMG,IL_MAX_DMG,IL_DEF,IL_STR,IL_DEX, IL_INT,IL_SPD,IL_IL_MAX_PROCH,IL_TREBUET,IL_IMAGE,IL_SRC,IL_NO,ID_USERS,IL_SHANS_BLOCK, IL_VES,IL_COUNT
We need to set up two cells for an ID_IL 1 and ID_IL 2. I don't know how to do that. ♪ ♪
Reply Quote 0
1 Reply Last reply

briley

$N;//номер нужной строки
$M;//номер следующей строки. Не обязательню плюс один.
$sql = "select `ID_IL`,`IL_LVL`,...,`IL_VES`,`IL_COUNT` from `table` where `id`=$N or `id`=$M";
$res = mysql_query($sql);
if(mysql_num_rows($res)==2){
  $row1 = mysql_fetch_array($res,MYSQL_ASSOC);
  $row2 = mysql_fetch_array($res,MYSQL_ASSOC);
}
foreach($row1 as $key=>$value){
  $row1[$key] = $row2[$key]+$value;
}
unset($row2);
print_r($row1);//при желании, можно запихать опять в базу

mysql 49766

2
Posts

0
Views

Suggested Topics

J

Searching Separate Words in the same string in MySQL
Software Programming • php mysql string bus • • Jolied

2

0
Votes

2
Posts

0
Views

A

Place % among all the words to be filtered:SELECT * FROM `dados` WHERE `nome` LIKE '%".Fulano%Silva."%' I put an example in http://sqlfiddle.com/#!9/aa2eb6/1 to see you working
Update with Inner join
Software Programming • php mysql phpmyadmin • • briley

2

0
Votes

2
Posts

0
Views

K

I annex the following replyUPDATE table_name as P INNER JOIN subproceso as SP ON P.idProceso=SP.idProceso set P.grupo="" where P.idUnidadNegocio=3 Where the important thing was to remove the FROM and also link the alias P with the name of the corresponding table.
B

Subtract row from one table by another table
Software Programming • php mysql • • Burma

2

0
Votes

2
Posts

0
Views

I would do this way:include 'conexao.php'; extract($_POST); /* Lembrando que ao passar os posts, nas variaveis de insert, são as mesmas dos campos vinda no POST */ $sql_insert = mysql_query(" INSERT INTO vendaprodutos ( cd_barras, nomeproduto, preco_venda, quantidade, tamanho ) VALUES ( NULL,'{$cd_barras}','{$nomeproduto}','{$preco_venda}','{$quantidade}','{$tamanho}' ) "); $sql_update = mysql_query(" UPDATE produtos SET estoque = (quantidade - {$quantidade}) WHERE id '{$cd_barras}' "); header("Location: venda.php"); In this change the sum would be automatic, try this way.
E

How to insert values in MySQL with while PHP, do not insert anything
Software Programming • php mysql csv • • emerson

2

0
Votes

2
Posts

0
Views

A

I've finally solved it. This was the right code:while(!feof($archivo)){ $linea=utf8_encode(fgets($archivo)); //Leo datos con CSV y lo voy poniendo en formato UTF8 $arrayLineas=explode(";", $linea); //Aquí tengo mi array con los datos del CSV if(!empty($arrayLineas[0])){ //Con esto quito cuando el ean esté vacío $sql="INSERT INTO articulos_csv (`ean`, `nombre`) VALUES ('$arrayLineas[0]', '$arrayLineas[1]');"; var_dump($arrayLineas[0]); var_dump($arrayLineas[1]); $resultado=mysqli_query($conWebService, $sql); if(!$resultado){ echo "Error: ". $sql ."\n". mysqli_error($conWebService); } } } fclose($archivo);
B

MYSQL. Calculation of values in one table on the basis of another table
Software Programming • mysql sql • • Burma

2

0
Votes

2
Posts

0
Views

SELECT R.OPISANIE_RECEPT, P.CAT FROM RECEPT AS R JOIN PRIZNAK_CAT AS P ON R.OPISANIE_RECEPT LIKE CONCAT('%', P.PRIZNAK, '%'); But the productivity of the request for large volumes of data will be very bad, because the search for the word is in the middle of the line.If productivity is important, instead LIKE Use MATCH and add a full-text field index R.OPISANIE_RECEPT♪
C

MySQL : How do I partition based on Month of date
SQL, Database Testing • mysql mysql 5.6 partitioning • • Cleofas

2

0
Votes

2
Posts

0
Views

O

From here, below is an example that range partitions by YEAR - change as appropriate. Here is the part of the manual that explains how to alter tables and add partitions. You should be able to take it from here. CREATE TABLE employees ( id INT NOT NULL, fname VARCHAR(30), lname VARCHAR(30), hired DATE NOT NULL DEFAULT '1970-01-01', separated DATE NOT NULL DEFAULT '9999-12-31', job_code INT, store_id INT ) PARTITION BY RANGE ( YEAR(separated) ) ( PARTITION p0 VALUES LESS THAN (1991), PARTITION p1 VALUES LESS THAN (1996), PARTITION p2 VALUES LESS THAN (2001), PARTITION p3 VALUES LESS THAN MAXVALUE);
A

Creating a Windows database backup service
SQL, Database Testing • mysql c sharp backup • • authera

2

0
Votes

2
Posts

0
Views

It seems you are trying to roll you own incremental backup script. The short answer is: Don't. There are so many things to consider when doing backups and even more for incremental backups that it's very difficult to be done right. Using a simple INSERT IGNORE (which ignores many errors, not only duplicate key errors) is not going to work and give you incremental backups. Also note that a database has a few more things besides tables. There are view definitions and events that you may want to backup as well. And that tables are created and deleted and changed (columns added, dropped, modified, triggers added or dropped, etc). Plus a backup has to be a consistent snapshot of the database, so whatever a script does has to be either a single transaction or while the database is not modified by any other session. I suggest you start by reading the MySQL documentation on: Backup and Recovery It explains the various backup types and methods that can be used. There is no solution that covers all situations so the answer for your specific case depends on what exactly is your objective (normal backups, incremental backups) and many other details like the version, edition, the tables' engine (MyISAM, InnoDB, NBD, etc.), whether the database will be accessed during the backups or not, etc. You might find that a simple mysqldump of the 5 databases is all you need.
C

Mysql big data solutions
SQL, Database Testing • mysql database design • • Cleofas

2

0
Votes

2
Posts

0
Views

J

It depends on your table structures, data layout and usage pattern. However I wouldn't consider 12 gb or actually anything that can fit into the RAM of a reasonable priced commodity server big data (~100-400 Gb). I work with MySQL servers happily running with terabytes of data. If your tables are well designed, indexed and your queries are well written you won't see issues. After that it's usually much easier to split your dataset by common usage pattern and logical dependencies. Move tables to a different database. For example split your log tables to a new server. You can repeat that as long as want until you reach the write limit of a single server and your cannot split your database anymore (all tables are strongly related). Then you can think about sharding.
E

MySQL interaction of tables
Software Programming • mysql sql • • elysha

2

0
Votes

2
Posts

0
Views

UPDATE tab1 JOIN tab2 ON (tab1.idPage = tab2.id) SET tab1.A = TRUE WHERE tab1.idPage = 246 AND tab1.A IS NULL
B

MySQL. How do we calculate the tables?
Software Programming • mysql • • Burma

2

0
Votes

2
Posts

0
Views

The volume of the table can only be calculated if the size of the record is fixed. This requires:All the recording fields had a fixed size. char(50) Always has a size of 50 bytes, while varchar(50) has a size between 1 and 51 byte.The record didn't contain NULL.Dimensions of types can be found https://dev.mysql.com/doc/refman/5.7/en/storage-requirements.html ♪Types nchar♪ varchar♪ varbinary♪ tinyblob♪ tinytext♪ blob♪ text♪ mediumblob♪ mediumtext♪ longblob♪ longtext No fixed size. If the table contains the fields of these types, its exact size cannot be calculated. Sometimes the size can be calculated approximately with a high precision if it is clear what data will be stored.All other types have a fixed size. INT Four bikes, that's easy. CHAR(7) 7 Byte. Size NUMERIC(12, 3) It's hard to count because MySQL packs every 9 decimal digits in 4 bayta.Each record contains https://blog.jcole.us/2013/01/10/the-physical-structure-of-records-in-innodb/ which has a size of 5 byte. If NULL is NULL, it's not stored in the record, it's just a bat in the headline.Once the size of the table is counted in the lights, it can be discounted how much space it takes on the disk. For MySQL speed, the data are stored with large pages, blocks of 4Kbyte or 8KBayte. If the heading is 100 bytes and page 4096 byte, there will be 40 entries on the page and 96 empty byte on each page. 400 records will be recorded on the disk of 10 pages or 40 kbayt.In addition to data, the table contains indices, each of which https://dev.mysql.com/doc/refman/5.7/en/innodb-physical-record.html ♪ If the index contains variable size fields, the index itself will also be variable size.While the precise size of the table is difficult to determine, in practice it is sufficient to assess the order.AdditionalWhen MySQL keeps the text, it and the numbers are stored as normal symbols. Let's say, in the UTF-8 code, all the numbers are one byte, and the Russian letters are two bytes. To be correct, it is necessary to know what coding is used for the field.Types INT etc. keep the numbers in the binary system. INT It always requires 4 baths where the whole number is stored -231♪ ♪ 231-1. Type DECIMAL keeps numbers in the decimal system using https://en.wikipedia.org/wiki/Densely_packed_decimal to pack every 3 decimal numerals in 10 bats (any 9 digit in 4 bayta).Types BIT(n) Packed together into a sufficient number of Byte. BIT(3) It'll always be 1 byte because it's impossible to distinguish less. But two fields BIT(3) They'll also have 1 byte because MySQL will keep them together.
S

MySQL - link the table field to the other field of the same table
Software Programming • mysql foreign key • • shizuka

2

0
Votes

2
Posts

0
Views

https://dev.mysql.com/doc/refman/5.7/en/innodb-foreign-key-constraints.html If ON UPDATE CASCADE or ON UPDATE SET NULL recurses to update the same table it has previously updated during the cascade, it acts like RESTRICT♪ This means that you cannot use self-referential ON UPDATE CASCADE or ON UPDATE SET NULL operations.
MySQL update the field in the table
Software Programming • mysql join • • briley

2

0
Votes

2
Posts

0
Views

A

UPDATE import_desc JOIN os_product USING (sku) JOIN os_product_description USING (product_id) SET os_product_description.description = import_desc.description https://dbfiddle.uk/?rdbms=mysql_8.0&fiddle=4d086d040519af16fe5ebc21442d376b
J

Setting up a record table in mysql
Software Programming • java mysql • • juvenalb

2

0
Votes

2
Posts

0
Views

T

Option 3.To remember the statistical list (plays, ratings). Set a timer to update this structure from the table at the interval. Interval depends on your task. In my opinion, 30 seconds or 1 minute is quite good.This option has been optimized by a large number of readings and has significantly deteriorated the base.
T

select to several tables in mysql
Software Programming • mysql • • Trenton

2

0
Votes

2
Posts

0
Views

E

I need to get the date and description of each of the tables where the id_tabla1 is present, in some may have more records than in the others, that's my problem.You could use http://dev.mysql.com/doc/refman/5.7/en/union.html for example:SELECT * FROM ( SELECT 'tabla2' as tabla, fk_tabla1, fecha, descripcion FROM tabla2 UNION SELECT 'tabla3', fk_tabla1, fecha, descripcion FROM tabla3 UNION SELECT 'tabla4', fk_tabla1, fecha, descripcion FROM tabla4 ) A WHERE fk_tabla1 = 1 The result would be as follows:tabla fk_tabla1 fecha descripcion tabla2 1 2016-12-29 prueba tabla2 1 2016-12-30 prueba2 tabla3 1 2016-12-29 prueba tabla4 1 2016-12-29 prueba
Check MySQL in several tables
Software Programming • mysql sql • • Marcee

2

0
Votes

2
Posts

0
Views

S

You should use a INNER JOIN, its functionality is to "unite" the different tables with a "field". For example:SELECT producto.id, producto.nombre, producto.precio, categoria.nombre FROM producto INNER JOIN categoria ON producto.categoria_id = categoria.id In case the table producto contain id of the category to which it belongs (which is normal)

Question of laying poles from mysql table

Suggested Topics

Searching Separate Words in the same string in MySQL Software Programming • php mysql string bus • • Jolied

Update with Inner join Software Programming • php mysql phpmyadmin • • briley

Subtract row from one table by another table Software Programming • php mysql • • Burma

How to insert values in MySQL with while PHP, do not insert anything Software Programming • php mysql csv • • emerson

MYSQL. Calculation of values in one table on the basis of another table Software Programming • mysql sql • • Burma

MySQL : How do I partition based on Month of date SQL, Database Testing • mysql mysql 5.6 partitioning • • Cleofas

Creating a Windows database backup service SQL, Database Testing • mysql c sharp backup • • authera

Mysql big data solutions SQL, Database Testing • mysql database design • • Cleofas

MySQL interaction of tables Software Programming • mysql sql • • elysha

MySQL. How do we calculate the tables? Software Programming • mysql • • Burma

MySQL - link the table field to the other field of the same table Software Programming • mysql foreign key • • shizuka

MySQL update the field in the table Software Programming • mysql join • • briley

Setting up a record table in mysql Software Programming • java mysql • • juvenalb

select to several tables in mysql Software Programming • mysql • • Trenton

Check MySQL in several tables Software Programming • mysql sql • • Marcee

Searching Separate Words in the same string in MySQL
Software Programming • php mysql string bus • • Jolied

Update with Inner join
Software Programming • php mysql phpmyadmin • • briley

Subtract row from one table by another table
Software Programming • php mysql • • Burma

How to insert values in MySQL with while PHP, do not insert anything
Software Programming • php mysql csv • • emerson

MYSQL. Calculation of values in one table on the basis of another table
Software Programming • mysql sql • • Burma

MySQL : How do I partition based on Month of date
SQL, Database Testing • mysql mysql 5.6 partitioning • • Cleofas

Creating a Windows database backup service
SQL, Database Testing • mysql c sharp backup • • authera

Mysql big data solutions
SQL, Database Testing • mysql database design • • Cleofas

MySQL interaction of tables
Software Programming • mysql sql • • elysha

MySQL. How do we calculate the tables?
Software Programming • mysql • • Burma

MySQL - link the table field to the other field of the same table
Software Programming • mysql foreign key • • shizuka

MySQL update the field in the table
Software Programming • mysql join • • briley

Setting up a record table in mysql
Software Programming • java mysql • • juvenalb

select to several tables in mysql
Software Programming • mysql • • Trenton

Check MySQL in several tables
Software Programming • mysql sql • • Marcee