mysql

Analogous to SET NAMES in MSSQL?

Is there an analog of SET NAMES in MSSQL? , use ini_set not offer, I need exactly an analog of this feature (as in MySQL), only by means of MSSQL (2005).

Why is it bad to store images in a MySQL blob?

Hello! Please tell me, what are the disadvantages and pitfalls in storing images in MySQL blob, if they are stored in a separate service, respectively, without creating problems with io?

Hash code encrypting a string on md5

How to make encryption via md5 (for example) arbitrary. And then uploading an image with the same name, the same code is encr ... ://narod.ru/disk/19236310001/upload.php.html">upload.php</a> Maybe someone will help, I will be very grateful. [:-)

B-TREE and HASH indexes

Hello. Interested in what is B-TREE, HASH indexes? How do they affect the speed of sampling? What is their syntax?

Creating and deleting a table manually in Hibernate using sql queries

You must manually create and delete a table in the database using sql queries using Hibernate. Class-the entity that the tabl ... esn't help, it's just that the table is no longer created automatically. How do I make the methods work, what did I do wrong?

Connecting to MySQL in Go

Good afternoon. I can't connect to MySQL from Go, MySQL is installed and running. Please tell me what it lacks? After "Googl ... ame/go/src/pkg/net/fd.go:236 +0xe4 created by net.newPollServer /home/username/go/src/pkg/net/newpollserver.go:35 +0x382

how to group ResultSet in Map by objects (java, jdbc)

Hi) I have two classes that I need to create by getting some data for them from db: @Data @AllArgsConstructor @NoArgsConstruc ... roducts_categories foreign key (category_id) references categories(category_id) on delete cascade );

How to fix the error "Unable to occupy port 3306 because it is already in use: mysqld.exe"?

I have the MySQL Workbench program installed, which loads the process when Windows starts mysqld.exe, and when you run the Op ... ogram, you get this error message How to change the port, I need these programs at the same time to work on the same project.

I can't build the Nukkit plugin [Maven]

I want to compile a plugin for powernukkit, how can I add it to the EconomyAPI dependencies https://github.com/Nukkit-coders/ ... hosting http://jenkins.onebone.me/plugin/repository/everything/ the plugin is no longer built! How do I compile this plugin?

Why aren't rows deleted in the MySQL view?

Here is the view: Why can't I delete the lines? Delete from p_p where name= "MoscoW";

How do I connect a mysql database to a Tilda site?

I have a database mysql and a website on tilda. The database is located on the server. Can I connect them somehow?

phpmyadmin in lamp-server [duplicate]

This question has already been answered here: ... rote localhost/phpmyadmin and he told me that the document was not found. So where is it installed and why is it not working?

Problems with DB encoding [duplicate]

This question has already been answered here: ... bet is written and selected as in the form of question marks. What could be the problem? Has anyone encountered this before?

How many threads are there in PHP? [closed]

Closed. This question should be clarified or supplemented with details. Answers to it are not accepted at the moment. ... o make multithreaded php, will the connection to MySQL be multithreaded or single? Please explain to anyone who is not lazy.

Working with MySQL in Android

Hello, I'm a beginner programmer for android, and for Java itself, too. I am writing an application for android and faced wit ... experience in it, I will write a script without any problems, but from the Java side, tell me in which direction to drip? =)

Set the MySQL time zone

Hello everyone. Help me figure it out. Every time I turn on my computer, I lose the MySQL time zone. I have to write this co ... , go to mysql and set the time zone with that command. Is it possible to somehow install it and that it does not lost track?

What is a webhook? And how to connect it?

I really couldn't figure out what a webhook was for a while)) It turned out to be a completely simple technology, so no one r ... o work with constructors. Question asked not only for me to answer it myself, but maybe there are more interesting solutions?

How to do Sharding in mysql?

I need to do sharding between servers in MySQL, as the server uses asp. core, I can not find the literature on this or a ready-made solution can who knows how to do this?

Warning: mysql fetch array() expects parameter 1 to be resource [duplicate]

This question has already been answered here: ... ce, boolean given in N:\home\localhost\www\phpsite\testreg.php on line 36 How do I make sure that it doesn't give an error?

How to merge two tables into one when getting the sqlalchemy result

There are two tables in the first table ID and several other fields, in the other table VALUE_ID and several other fields How ... when filtering by ID, or the fields of the table bx_uf outputs only its fields, the table bx does not join the output values