menu
Log In
Register
menu
Login
Register
Questions
Hot!
Unanswered
Tags
Users
Ask a Question
About us
Cookie Policy
Home
Tag
mysql
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?
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 ...
mysql
by
bit24yes
asked
Sep 24, 2021
1
vote
1
answer
Transition mysql > mysqli?
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 ...
php
mysql
by
Admos_ru
asked
Sep 24, 2021
1
vote
1
answer
What books, courses are needed to write complex mysql queries?
What books, courses are needed to write complex mysql queries?
SELECT, INSERT, UPDATE, DELETE I know with JOINs so far ...
mysql
by
Speakermen
asked
Sep 24, 2021
1
vote
1
answer
How do I make letter IDs?
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 ...
mysql
by
alekssamos
asked
Sep 23, 2021
5
votes
5
answers
Geo-distributed database/sharding?
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 ...
mysql
postgresql
sql
by
MaxDukov
asked
Sep 22, 2021
1
vote
1
answer
What does the filtered column in EXPLAIN mean?
What does the filtered column in EXPLAIN mean?
Which one is better and why? ...
mysql
by
ganbatte
asked
Sep 22, 2021
2
votes
2
answers
Why does it sometimes take too long for a model to be added to the database (Laravel)?
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 ...
mysql
ubuntu
laravel
by
Tutucu
asked
Sep 22, 2021
1
vote
1
answer
How do I create a table with two columns of necessarily different values?
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 ...
mysql
by
MSAFT
asked
Sep 22, 2021
1
vote
1
answer
Problems with MySQL MAMP after removing the root user?
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 ...
php
mysql
by
VVS10
asked
Sep 22, 2021
1
vote
1
answer
How do I link the key in the tables?
How do I link the key in the tables?
How can I substitute several values from one table into another? Paint ...
mysql
design-base-data
by
delongeroman
asked
Sep 22, 2021
1
vote
1
answer
How do I make incomplete numbers in the blacklist count?
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 ...
mysql
asterisk
by
anton99zel
asked
Sep 22, 2021
1
vote
1
answer
How to output from a database using PDO?
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 ...
mysql
sql
by
DamWolf
asked
Sep 22, 2021
1
vote
1
answer
Cash flow on the site. How to properly design the base?
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 ...
php
mysql
by
FreeAero
asked
Sep 22, 2021
1
vote
2
answers
How do I get the table name prefix at JOIN?
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 ...
mysql
sql
by
oe24y
asked
Sep 22, 2021
1
vote
1
answer
What is the problem with creating a registration form?
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 ...
php
mysql
by
Temirla
asked
Sep 22, 2021
9
votes
3
answers
What causes the request processing time jumps?
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 ...
php
mysql
nginx
ubuntu
laravel
by
Tutucu
asked
Sep 22, 2021
1
vote
1
answer
How to specify date interval in SQL from GET?
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 ...
php
mysql
by
shambler81
asked
Sep 21, 2021
1
vote
1
answer
How to display records that were not displayed on this page?
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 ...
php
mysql
by
semechki
asked
Sep 21, 2021
1
vote
1
answer
PhpStorm, how do you define your own property value?
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 ...
php
mysql
codeigniter
phpstorm
by
Alxjzx100
asked
Sep 21, 2021
1
vote
2
answers
Why does Lazarus truncate a line when reading?
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 ...
mysql
lazarus
by
Insaned
asked
Sep 21, 2021
Page:
1
2
3
4
...
493
next »