Questions tagged [MySQL] (11512)

0
answer

How to register a trunk to asterisk realtime + mysql?

Hello, please do not judge strictly if someone question seems stupid and thanks in advance. How to register a trunk to asterisk realtime + mysql ? The situation is the following trunk is logged if you specify the callbackextension value specifies the internal number for example, 101. if I remove the value and leave blank ch...
nina_Brakus asked April 19th 20 at 12:46
1
answer

How to make the generation of html pages using mysql?

I'm still new to this area, so do not scold. For example there is already a ready template and a database, how to do so when put the new data into the database, was taken as a template and create the final html for example: The title is written Habr - after the html is created with the name habr.html. This question is of co...
Lisandro.Sta asked April 19th 20 at 12:45
0
answer

How to make the implementation of the Handbook?

How to configure connection and queries for the dictionary? Now 5 tables. Office, floor, phone, linking the table of floors and offices, phones, and offices. I bring all offices, by pressing displays the floors. Now the question is how to split people even on the floors that I have pushed the branch, then the floor and remo...
rozella.Gottli asked April 19th 20 at 12:41
1
answer

Replication from MySQL to SQL Server. If you want to use?

The last few years to replicate live data use Oracle Golden Gate, maybe there are some simpler alternatives.
Gage67 asked April 19th 20 at 12:41
1
answer

How to merge three MySQL tables and delete certain rows?

There are three tables: 1. Table Sciences 2. Table with known science 3. Table indicates what science opens after the study of a specific. Sciences can be over 500 so I don't want the time to display all the science, and it makes no sense. You should print only those which are possible to explore and hide studied. In my ...
sandy_Lynch asked April 19th 20 at 12:40
3
answers

How to select only one row with the desired values?

Hello everybody, There is a table with users, where each user has a id and there is a table with messages, where each message is a string and has two fields for the id of the sender. There are many messages, some are the same on both id. Example: Where "id" is a sequence number of the message, "fsender_id" - id of the sen...
Gustave_Schamberger asked April 19th 20 at 12:37
1
answer

How to make a sample of 5 tables with the same fields by condition in MySql?

There is a database with 5 tables and dikoviny fields. id, tel, login, pass, type You need to find the value of a field (tel) searching in all tables and display the result in same form (id, tel, login, pass, type), cutting off the replays. PS. I'm new, and join-s for me is not yet entirely clear
emery.Heller73 asked April 19th 20 at 12:35
0
answer

How to make a generic function to search for products?

There is a table stock and Columns stock_id stock_name stock_imei stock_category In this table store the list of products that have different stock_category If stock_category the value of the phone in stock_imei recorded data but if headphones that stock_imei empty. Also there is a func...
Fredrick.Swaniaws asked April 19th 20 at 12:33
1
answer

Can't deportirovat backup mysql workbench?

I want to import database in workbench but produces an error ERROR 1046 (3D000) at line 23: No database selected Operation failed with exitcode 1 14:55:13 Import of C:\Users\Andrey\Documents\dumps\collegePractice1.sql has finished with 1 errors now, what is on line 23: DROP TABLE IF EXISTS `cars`;
gage asked April 19th 20 at 12:32
3
answers

How to check the answers to the questions, if there are multiple answers?

Good day! There is a table with the following structure: id-----name----------id_question-----correct_answer 1-----the Answer 1----------55---------------0 2-----the Answer 2----------55---------------1 3-----the Answer 3----------55---------------1 4-----the Answer 4----------55---------------0 5-----the Answer 1---------...
josh33 asked April 19th 20 at 12:30