mysql

There is Debian, only MySQL 5.1 is in the repositories. I download it .deb package from the official MySQL website. Next, aft ... r-5.5.18. Please tell me the method install MySQL version 5.5 without building it from the source code. Thank you in advance.

This is the first time I have encountered such a problem. Encoding on the site: <meta http-equiv="Content-Type" content="t ... eneral_ci The form sends the Cyrillic alphabet, and the questions are saved in the database. What else could be the problem?

Prompt a request to select only the date from the database. There is a row in the table of the TIMESTAMP format 0000-0-0 00:00:00, so here's how to make the screen display only the date and not the date with time ???

I was interested in the way that bashorg generates a quote to insert on the site. FAQ here Having seen that you need to acce ... not work with MySQL, you can explain how to use js to output a certain text from the database to a third-party page? Thanks.

I enter the data in the database through the form. I.e., in one file I create a form for input, and use the $_POST method to ... Информация в базу добавлена успешно."; } else echo "<br>Информация в базу не добавлена."; mysqli_close($link); ?>

Hello! On the mysql server version 5.5.28, I export the database via phpmyadmin, and then import it to the server with mysql ... 01 SET @OLD_CHARA' at line 13 I deleted line 13 and there are a few more and still an error, help anyone who can, thank you.

Is it possible to somehow set a search for all the database, all the columns of all the tables? The task is to scan the database for eval. Please tell me if it is possible to implement such a search ?

When you fill out the database in Russian through the form, question marks are added to the database. Here is a picture of the form - Here is a picture of the result of adding - Tell me how to solve this.

I install MySQL on Centos7 as follows. First I download wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarc ... Jan 14 05:56:57 systemd[1]: Unit mysqld.service entered failed state. Jan 14 05:56:57 systemd[1]: mysqld.service failed.

Setting openfire to ubuntu 16.04. Mysql version 15.1, distrib 10.0.38-MariaDB, version openfire 4.5.3. Reached the step where ... exist After that, the show tables command does not show the list of tables, so nothing was unloaded. How to deal with this?

I would like to know how to add data to linked tables in a single query. The figure shows the database schema. How do I add an author and a book so that their ID is added to the central table? Database on MySQL.

I tried it like this: select cast(convert('1900-01-02 00:00:01.000000', datetime(6)) AS BINARY) I got this: 4957484845484 ... m interested in datetime(6). This approach worked for MS SQL Server, but for some reason the behavior is different for MySQL.

Hello everyone. Tell me how to make a selection of data from a table with several conditions. Now I have so: SELECT NAME FROM ... uest. Adding another AND at the end didn't help. How to write correctly if you need to check the record for 3, 4 or 5 fields?

What program do you recommend for working with the MySQL database for Ubuntu 10.04? to be similar to SQL Manager Lite for MySQL

I couldn't find a topic with an answer to my question. There is a database on the local MySQL server. I create a Windows For ... dataGridView1.Rows.Add(s); } } } Here's what happens as a result, attach the screen

Dear professionals, after trying many options from the forums and Google, I got completely confused, so I have to ask for hel ... tried to get the server encoding via character_set_name () - returns latin1. Please tell me, I'm already completely confused

Does anyone know how to Russify the program shell mysql query browser and mysql administrator? OS-Ubuntu 11.04.

The table has a Date column. Which query will return the time interval in the database. Let's say we output results that were created between 21.10.10 and 21.10.12

There is some form of: <form action="#" class="d-md-flex justify-content-between"> <select& ... ed out, if "Category 2" is selected, then from Table 2, etc. How to make such a conclusion? Which is better to use PHP or JS?

The essence of the problem: In Qt, a file is parsed that contains Emoji characters. After that, the data is written to a MySQ ... uestion: How, working with Qt, as with a MySQL client, to achieve full support for Emoji characters, when writing to a table?