Performance Problems With JOINS - Tunnng required or upgrade hardware?
ImagemNoticia IMN ON (N.id = IMN.noticiaId) WHERE N.dataInsercao= '.$clippingDate.' GROUP BY N.id ORDER BY VCT.tipoVeiculo, (VCT.ordemVeiculo VCT.id), (NAC.ordemAssunto NAC.assuntoId), N.id thank´s all. Filipe Tomita
Re: HTML in MySQL?
Use addslashes($htmlCode) and execute query normally. ?php $slashedHtmlCode = addslashes($htmlCode); ? []´s Tomita On 9/9/05, Vladimir B. Tsarkov [EMAIL PROTECTED] wrote: Hello! Be careful here Vladimir, the (\n) are not 'null' characters; but newline characters. Agree, I was wrong. And i would highly recommend *not* replacing them with br tags as you write them into the database. This is asking for trouble on so many levels. The database will cope with carriage returns and newlines just like any other character, so will have no problems. HTML is just string; treat it as such and don't give it anymore credit than that and you'll be fine. If you need to output a HTML string (not in a textarea field), you'll need to replace \n with br. That is why, I think that it is better to replace it before saving (You will not need to replace \n during the output process. It will save you some lines of code, and add productivity.). Of course, you need to be sure that your program will make HTML output more often, than any other type of output. -- Удачи! Владимир Please, avoid sending me Word or PowerPoint attachments. See http://www.gnu.org/philosophy/no-word-attachments.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
Data import problems
Hi people, I having problems to import a dump generated via mysql dump in mysql 4.0.20slackware version to a mysql 4.1.14. The dump generated with other table name (Insert into temp, temp2 , temp3) in 20 sql large (420mb.) sql files. I tried LOAD DATA INFILE but data not inserted correctly, someone help-me?? tks. Tomita
Re: Data import problems
tks for reply but i dont have acces to original database... the dump file not generated from me.. Someone tell me about SAD command to replace table name to correct name but i dont find anything about it. On 9/9/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Filipe Tomita [EMAIL PROTECTED] wrote on 09/09/2005 04:37:01 PM: Hi people, I having problems to import a dump generated via mysql dump in mysql 4.0.20slackware version to a mysql 4.1.14. The dump generated with other table name (Insert into temp, temp2 , temp3) in 20 sql large (420mb.) sql files. I tried LOAD DATA INFILE but data not inserted correctly, someone help-me?? tks. Tomita If you look at the output from mysqldump, you will realize that it is just a series of SQL statements. Execute them with your command line client just as you would any other SQL script file. mysql database -u username -p dumpfile.txt or use the source or . commands if you are already in the CLI mysqlsource dumpfile.txt Where you will run into problems is if you didn't specify a max_packet_length WHEN YOU MADE THE DUMP. That option tells mysqldump just how long the longest single statement can be. If you try to run a dump file that contains a statement that exceeds the max_packet_length setting on your server, it will fail silently (server gone away). If you failed to dump with a maximum set, your options are to increase the MAX_PACKET_LENGTH on the server to accept the longest single statement in your dump file or to edit your dump by hand and break your long statements into shorter ones or both. Shawn Green Database Administrator Unimin Corporation - Spruce Pine