mysql

I create a foreign key, build a diagram using Reverse Engineer in MySQL workbench, on the diagram the connection is indicated ... N UPDATE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; Here is what the connection turns out to be:

There is a regular update request $db_query = "update " . DB_PREF . "advert set key_words='" .$_POST['key_word'] . "' wher ... do not understand. I guess that first you need to make a selection, and then sum the value from the selection and POST ' a.

After a little Googling, I decided to link it via php. I've never worked with php before. The connection is established, the ... hp with a more suitable option, if that makes sense. And yes, I'm a newbie, with almost no experience, so don't throw stones)

I transfer the database (MySQL). I do the transfer by the most common method - "copy-past" of the directory to the "data" dir ... are buyer is 100% owned by the organization that purchased the software. And has the full right to provide a password to DB.

There is a local server based on Endels, a MySQL database phonebook, and a tblMain table encoded in utf8_general_ci. The brow ... mysql_close($link); ?> What is the latin1 encoding and how can I change it to the right one?!

I develop, for home needs, photo hosting. There will be up to 7 thumbnails for each photo. I need to save the dimensions and ... of them), the thumbs ratio will have 7000 rows. Which of these options is the most optimal? Surely there is an alternative?

When installing, using the commands apt-get install phpmyadmin, I got the settings window dbconfig-common, entered all the da ... cess denied for user 'root'@'localhost' (using │ │ password: YES) How do I access mysql to complete the phpmyadmin setup?

I parsed one order, I write it down in the database. If you write to the database as is, then the database will be: ОфорР... сь помучиться CP1252 → CP1251 получилось слово: Оформлен So the encoding doesn't change? How do I change the encoding?

The password in the database is stored as F40A1DD8BD13322642527D1ADC22FA6DF1B1D0ED Is it possible to decipher it?

I added to MySQL services using the bat file: "C:\Program Files\MySQL\MySQL Server 5.1.72\bin\mysqld" --install-manual ... number 0 0 161208 15:03:59 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist

So, dear ones. I'm reading a PHP5 book for beginners. I missed some things(I don't think xml and working with directories are ... in the table? And why row 1? Explain to the ignorant. PS: I'm trying to create a new mysql user(mysql database, table user).

SQLSTATE[28000] [1045] Access denied for user 'myuser' @ 'localhost' (using password: YES) (same with root). Symphony ... or a long time. I looked through the topics on the usual stock , the recipes did not help. Could you have missed something?

Why does phpmyadmin give an error #1698 - Access denied for user 'root'@'localhost' when logging in. The installation was per ... the console]} After that, it demanded to enter and again returned the error #1698 - Access denied for user 'root'@'localhost'

Here is a query to search for MySQL: SELECT `opisanie` FROM `daba` where vepe='все' It outputs information from the "opisani ... e" table says: "All products". How do I make it so that it finds "everything" regardless of what is written before this word?

What is the difference between MySQL - InnoDB and MyISAM engines? What are their strengths and weaknesses?

I installed mysql-server on ubuntu 15.04, but the mysql console client does not allow you to enter Cyrillic characters (nothi ... machine) via the graphical terminal emulator - I open it by pressing ctrl+alt+T, then enter the command mysql -uroot -p123

Hello! Please tell me why such a group request does not work in php: $query = "SELECT * FROM table WHERE id = '1'; ... query($query); $query = "DELETE from table WHERE id = '1'"; $res = mysql_query($query); What could be the problem? Thanks!

Created one table: CREATE TABLE art ( art_id INT PRIMARY KEY art_name VARCHAR(20)); And this is the second request: CRE ... or: ERROR 1005 (HY000): Can't create table 'set_default_test.craft' (errno: 150) Question: What did I do wrong? Thank you.

When I tried to output data from a table in the database, to a table on a site page, I ran into a nose-to-nose output problem ... the values alternate, for example, maybe we should assign to echo"".$row['znachenie'].""; a bracket [] with something inside?

Here I put the MySQL management system - phpMyAdmin 3.4.8 in the folder with the site on the local computer running the Apach ... he entire config is configured in a file "config.inc.php", but in the folder with phpMyAdmin I didn't find it. Please help...