mysql

I started learning MySQL after 20 years of working with SQL Server. 95% of my database queries are stored procedure calls, wh ... ything is clear. The syntax is no different from Transact-SQL. I would appreciate more elegant solutions (if there are any).

Closed. It is impossible to give an objective answer to this question . Answers to it are not accepted at the moment. ... not complete, scattered. Therefore, I ask for your advice, as people who know and have already passed this stage. Thank you

There is a stranger (worker) view code: $sql = "SELECT `s`.`name1` AS `name1`, `p`.` ... e the purpose of AND here? And, if there is a check for truth or equality to one, then how does MySQL interact with PHP here?

Is it possible to deploy this project locally on windows. Tutorial is only available for Linux. Which specifies the following ... f possible. Ruby, MySQL, and Redis (beta) themselves are already installed in windows. Is it possible without or with docker?

The "DROP DATABASE" command is disabled. DROP DATABASE users; DROP DATABASE `users`; In the configuration config.default.php ... out "The "DROP DATABASE" command is disabled.". You can't delete it from the image editor. Who knows the solution tell me...

I don't have the opportunity to consult with an accountant, so I hope that there are people here who can help me. I have 3 ta ... py if you help me. I hope I have clearly formulated the question, otherwise write in the comments - I will add the question.

I'm trying to design a database (mysql) for a future chat messenger. Here is the resulting model at the moment: I am new to ... rs) has a link to the chat of this list (dialog). I do not know if I need this connection in principle and how I will use it.

Good day to all, I have been trying to solve this problem for a long time, I do not understand what the problem is. I use ORM ... = 8, FK_User = user }; context.WorkerCards.Add(card1); context.SaveChanges(); } } }

There is a table Employees with columns (employee ID, department ID, salary, start date, end date, manager ID): ID ... it is necessary to track the dynamics. The dynamics is the actual number of employees in the department on a monthly basis.

I am trying to install MySQL server on windows 10 x64. Any installation ends with an error (screen). I downloaded the install ... rror 1042: Unable to connect to any of the specified MySQL hosts. Failed to connect to MySQL Server 8.0.20 after 10 attempts

You need to implement a newsletter to registered users of the site. I ran into such a problem that neither on the forums nor ... ll work on PHP7 - where all emails-array are in the variable $usermail (That is, without a connection to the database, etc.)

Please help me decipher mytop. What does the red Ratio and Ratio now mean? And how to solve the problem? +----------------- ... otal_blocks | 6995 | +-------------------------+----------+ Tell me, do I need to enable query-cache-size caching?

There are 2 files: auth.php and auth-file.php. In the first file, the standard form is: <form action="auth-file.php" meth ... e. Here is the code that directs it to nowhere. header("Location: index.php"). Help me figure out where I went wrong, please

Hello, how can I make $obj->rid from the first select be substituted instead of $selects[1] for the second, and the same w ... s[10] as $obj ) { echo "<option value='$obj->rid'>$obj->rname_ru</option>"; } echo "</select>";

Help me figure out how to tell the PDOStatement object that it would give an array with SELECT, SHOW, DESCRIBE or EXPLAIN, an ... ;fetch( PDO::FETCH_ASSOC ) ){ $response->rows[] = $row; } return $response; } } Thank you for your answers.

Just installed a fresh ubuntu 16.04, put mysql on it, but when trying to log in to it $ mysql -uroot An error is returned ... blank, and if I try to log in with the-p flag, the system asks for a password, I press enter, and the same error is returned.

Getting a list of "Categories" from the db table MySql. And the task is to fill Select with the resulting list. <script t ... ult); } return $array; }?>> Here I get an array. It remains to throw in the select with id="mySelect"...How?)

Hello. The site server has a CSV file with the uploaded database. How can it be automatically filled into a table on MySQL? W ... code Load Data and the file load data, but the hosting says this command is disabled. How else can this process be automated?

Program version: 5.5.25-MySQL Community Server (GPL) insertStr = "INSERT INTO cards (id,cardnumber,seccode,valid_until,c_ca ... ySQL server version for the right syntax to use near 'SELECT id,c_cards FROM cards WHERE id ='3' AND c_cards ='2')' at line 1

There is a table where fields with attributes, some have a value, some don't-NULL. Can I somehow select all non-NULL values for all fields in the table ?