menu

Recent questions tagged mysql

1 vote
3 answers
How do I clear a value through sql phpmyadmin if the name has a hyphen in it? Tried these options: UPDATE ywjy2_jshopping_products meta_keyword_ru-RU = NULL и UPDATE ywjy2_jshopping_products SET meta_keyword_ru-RU = '' But both options don ...
by bit24yes
asked Sep 24, 2021
1 vote
1 answer
Transition mysql > mysqli? There is a store in 2005 made in Shop Script free, all works fine, but since the hosting and Opencart installed and the latest versions that require PHP 7.4, then the ol ...
by Admos_ru
asked Sep 24, 2021
1 vote
1 answer
1 vote
1 answer
How do I make letter IDs? I once saw a URL shortener like this: /1, /2, /9, /a, /b, /z, /A, /Z, /1a, /2a ...? How do you do that? Someone was talking about the 64-rith number system, but it was ...
by alekssamos
asked Sep 23, 2021
5 votes
5 answers
Geo-distributed database/sharding? Colleagues, I want to get a little weird. there is some kind of authentication service. Now the server is exclusively in Europe, there is a desire to drag the second se ...
by MaxDukov
asked Sep 22, 2021
1 vote
1 answer
2 votes
2 answers
image
Why does it sometimes take too long for a model to be added to the database (Laravel)? From time to time such requests appear in the server logs: That is, from time to time the server response speed starts to increase from 0.2 seconds to 3 or even 8 seco ...
by Tutucu
asked Sep 22, 2021
1 vote
1 answer
How do I create a table with two columns of necessarily different values? Is there any way to designate when creating a table that the value of one column is necessarily different from the other? For example, if a table has two columns colum ...
by MSAFT
asked Sep 22, 2021
1 vote
1 answer
Problems with MySQL MAMP after removing the root user? Hello, everyone! Don't judge strictly I don't understand php and mysql) Faced with a problem, through my own fault. I deleted unnecessary databases and users and acci ...
by VVS10
asked Sep 22, 2021
1 vote
1 answer
How do I link the key in the tables? How can I substitute several values from one table into another? Paint ...
by delongeroman
asked Sep 22, 2021
1 vote
1 answer
How do I make incomplete numbers in the blacklist count? There is such an entry in Asterisk - blocks numbers from the MySql database The format of the numbers is specified in full, such as 79001234567 How to make incomplete ...
by anton99zel
asked Sep 22, 2021
1 vote
1 answer
How to output from a database using PDO? I'm accessing the database using PDO and want to put the lines I need on the page, but for some reason it doesn't work. Can you tell me what the problem is? The HTML ...
by DamWolf
asked Sep 22, 2021
1 vote
1 answer
Cash flow on the site. How to properly design the base? Colleagues, good afternoon! With this question I appeal to your thoughts, vision and opinion for help, my own brains unfortunately not enough, but, I tried. The situa ...
by FreeAero
asked Sep 22, 2021
1 vote
2 answers
How do I get the table name prefix at JOIN? There is a table of opera two. Each of them has a repeating name column. When I do a JOIN, I get two fields named name in the result. There are a lot of such fields ...
by oe24y
asked Sep 22, 2021
1 vote
1 answer
What is the problem with creating a registration form? Built registration form with PHP+MYSQL. On the local server works fine, but when I uploaded it to the hosting began to give an error: 30) { $err = "The login must be ...
by Temirla
asked Sep 22, 2021
9 votes
3 answers
image
What causes the request processing time jumps? Hi all, what's up: Server: 2 x 2.8 GHz, 4 GB RAM, 50 GB NVMe (13 GB full), 200 mbps ubuntu, nginx, php-fpm, php 7.3, laravel, mysql it has an API server that is supp ...
by Tutucu
asked Sep 22, 2021
1 vote
1 answer
How to specify date interval in SQL from GET? Available: $stat = mysql_query("SELECT FROM `betaintranet`.`ad_stat` WHERE `ban_id` = $banid AND `datetime` LIKE '%2020-10-28%'"); and there are /bnid.php?start=28-0 ...
by shambler81
asked Sep 21, 2021
1 vote
1 answer
How to display records that were not displayed on this page? Good afternoon, I have this problem. I output records randomly from one table, the problem is that I want to output them both in one of the sections and in the basement ...
by semechki
asked Sep 21, 2021
1 vote
1 answer
PhpStorm, how do you define your own property value? Hi all. I encountered that PhpStorm does not understand $this->db->database declaration in the query. There are two databases in the project, and when I need t ...
by Alxjzx100
asked Sep 21, 2021
1 vote
2 answers
image
Why does Lazarus truncate a line when reading? I am writing logs to a Mysql database. I am trying to read them from Lazarus. I have found that Lazarus cuts some of the lines. It looks like this: And in fact in the ...
by Insaned
asked Sep 21, 2021