mysql

Why? SQL query: ALTER TABLE `media` CHANGE `id` `id` INT( 11 ) NOT NULL AUTO_INCREMENT MySQL response: #1075 - Incor ... `title` varchar(255) NOT NULL, `info` varchar(255) NOT NULL, `dt` date NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

I have sent data from the form, everything is fine, it is added to the database, I also output data from the database to the ... dy sent by) I reread a lot of options on the Internet, nothing helped, I think there is some error in my code. Please help me

I installed XAMPP for myself. I started everything. I open the browser, enter localhost, and the error ERROR The requested ... host` # localhost name resolution is handled within DNS itself. # 127.0.0.1 localhost # 127.0.0.1 localhost

How can I merge two tables using sql queries? There is such a table: CREATE TABLE [dolgnosty] ( [id] INTEGER PRIMARY KEY, ... able dolgnosty is unchanged, and the table stavky changes, but, all this should be shown as a single table! How do I do this?

I can't figure out how to work with MySQL queries in C++. I'm trying to write a console program that will record customer dat ... ведите имя клиента: "; getline(cin, fullName); cout << "Введите ID абонемента: "; cin >> ID_abon; }

How can I safely add a field to a table in a DB on a site that is on Yii2? Just add a field by query to the DB and add this f ... ortant to do it safely and without jambs, since there are a lot of entries in the table and the site is spinning on the prod.

Http://sqlfiddle.com/#!9/aef5ce/7 In the example, 2 queries are made to the table. The requests are the same, the only diffe ... isplayed in the example as the result of the 1st query is returned (that is, the value for the string with format_id = null).

Hello there! It is not an easy task, there is xml with the following content: <offers> <offer id="3783" available=" ... ing large files (my file is about 150,000 lines and about 9 Mb). Please tell me, and then for the whole day I can not master!

There is a page As I found out the page data is stored in the database. In which database and how to edit the database?

Closed. It is impossible to give an objective answer to this question . Answers to it are not accepted at the moment. ... And html do you need an editor? I think it would be better without him. canvas. Which library is better to use? An atom?

It is necessary to execute the script using the cron at the exact time (for example, at 14: 00:00), with the accuracy of a se ... ver time and calculate the remaining time, and then execute the necessary script. Is it possible to do this in a simpler way?

I read about transactions in MySQL and a question arose. Will there be any collisions with simultaneous requests to the datab ... e by the second user will also be rolled back? Or the database monitors the separation of transactions different connections?

There is a wordpress framework Unyson, running on bootstrap. Supports extensions and custom options. There is a Mega Menu ext ... array of the default option is, and contains an array with the url key and a link to the file. How do I get this value back?

Hello! I wanted to ask, is it possible to work with a mysql database via javascript? That is, in php there are standard fun ... such a login is already in the database, then the inscription immediately appears that "Such a login is already registered."

Here is the database schema and it turns out that in the "Purchase Log" and "Delivery Log" tables, the primary key matches the foreign key

Hi! Tell me a PHP framework like CodeIgniter ' a to write small sites with an admin panel, etc.. Why for a beginner? Because I had no previous experience writing projects on frameworks. I have knowledge of OOP, MVC. I would be grateful.

Good evening, everyone. I just started learning AJAX, and I'm also new to php and mysql. Created a database and a users table ... o the first question is removed. Tell us about the checks, pliz, do you need everything or do you need to add something else?

You need to use PHP to find out how many users in the users table have a rating value greater than 10. Please tell me how to do this?

I can't find articles on how to make a painless search on the site by two keywords for example words in the search I did this ... ry for Apple iPhone 4 Copy" and I want to get the search result for the words iPad battery . How do I do this? MySQL DATABASE

You can't prepare a query MySQL (ALTER TABLE) and do the following. There is a list of tables, the tables have Column Name ( ... ES` t, `information_schema`.`COLUMNS` d WHERE t.`table_name` LIKE 'wp_%' AND d.`COLUMN_TYPE` = 'datetime' LIMIT 0, 30; **