I want to create a table in a database to be able, in one of the fields, to paste html code, this code varies in size but always has between 200,000 and 400,000 characters.
I want to paste it manually with Phpmyadmin but as for this type of field the type is Blob, it does not allow me to paste it but it asks me to choose a file.
Is there any other way to manually insert html code of these mentioned characteristics with Phpmyadmin?
In PHpMyAdmin go to the "SQL" tab and in there you have the INSERT, you must make sure that the quotes with which you open the value that you are going to insert, are not present in that html.
the INSERT should be something like this:
INSERT INTO nombredetutabla (nombrecolumna) VALUES ('<html> ... todo el resto de tu html sin usar comillas simples, solo comillas dobles ... </html>')
I've tried this in a BLOB type field and it has gone smoothly:
Then you click on the "Continue" button and that's it, just make sure that the quotation marks do not throw you an error.