RE: Good book
I suggest: For PHP and MySQL: PHP and MySQL Web Development (Sams Publishing) by Luke Welling and Laura Thomson For MySQL: MySQL (second edition) by Paul Dubois -Mensaje original- De: Scott Hamm [mailto:[EMAIL PROTECTED] Enviado el: Viernes, 27 de Agosto de 2004 11:16 a.m. Para: 'Mysql ' (E-mail) Asunto: Good book Since I'm new with MySQL, I want to apologize for asking questions that should've been answered by googling, RTFM and such. However, I'm looking for a good book that deals with MySQL and PHP whether it be single book (combined with PHP and MySQL) or separate books for each. I am intensive in Linux Operating System and bash shell scripting, C++, Access and html + css (using notepad only). With my knowledge, which book(s) do you recommend the most? (prefably with execrises) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: GUI for MySQL
I would suggest DBDesigner available on http://www.fabforce.net/ -Mensaje original- De: Kirti S. Bajwa [mailto:[EMAIL PROTECTED] Enviado el: Jueves, 12 de Agosto de 2004 12:09 p.m. Para: '[EMAIL PROTECTED]' Asunto: GUI for MySQL This is my first attempt to design and test MySQL. I have used MS SQL for number of years. I do appreciate if members of this list can recommend a good GUI application for MySQL. I want the GUI application to design DB, design Quiries, etc. Thanks. Kirti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL know
En español lo más útil que he visto es: www.mysql-hispano.org/ Para crear tablas y en general para hacer algo útil en MySQL se necesita aprender SQL, hasta donde yo se, con solo MySQL instalado no vas a poder crear aplicaciones y solo podrás interactuar con el por medio de la línea de comandos del DOS o bien con algún programa como MySQL Control Center, pero esto es útil solo para labores de administración del servidor. Si lo que se quiere son aplicaciones para la web, sugiero tomar algo de tiempo adicional y que aprendas PHP (no es difícil) para lo cual tienes que bajarlo e instalarlo en www.php.net y también hay que instalar el servidor que puede ser Apache www.apache.org (primero esto y después PHP) en el link de http server. Si se desea utilizarlo con aplicaciones de escritorio puedes utilizar Visual Basic o cualquier programa para comunicarse con el por medio de ODBC. Saludos -Mensaje original- De: Yusdaniel Rodriguez Espinosa [mailto:[EMAIL PROTECTED] Enviado el: Miércoles, 11 de Agosto de 2004 03:22 p.m. Para: [EMAIL PROTECTED] Asunto: MySQL know I install MySQL Server in my computer, now how a can run the program to make a code In whats program I write the code thanks Yusdaniel Por si alguien habla español: Yo instale el MySQL Server en mi computadora, quiero empezar a aprender a programar en el, pero no encuentro ningun ejecutable para abrir el programa, tengo que utilizarlo desde otro Programa??? como creo las tablas??? etc. Si alguien conoce algun sitio en español que hable detalladamente del MySQL, por favor agradeceria mucho que me pasen el link. Gracias Yusdaniel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: sql function for timestamp
In MySQL you can do that with: DATE_FORMAT DATE_FORMAT (column_name,'%Y-%m-%d %H:%i') -Mensaje original- De: J S [mailto:[EMAIL PROTECTED] Enviado el: Miércoles, 14 de Julio de 2004 08:26 a.m. Para: [EMAIL PROTECTED] Asunto: sql function for timestamp Hi, What SQL function do I need to convert timestamp 200406011403 into 2004-06-01 14:03 ? Thanks, JS. _ Stay in touch with absent friends - get MSN Messenger http://www.msn.co.uk/messenger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: DBF to MySQL
John: I´m new to MySQL but I hope this could help. Please read below. Regards from Costa Rica -Mensaje original- De: John Mistler [mailto:[EMAIL PROTECTED] Enviado el: Martes, 06 de Julio de 2004 09:55 p.m. Para: [EMAIL PROTECTED] Asunto: Re: DBF to MySQL For some reason, the imported information showed up as garbled nonsense. The file I was importing was an .xls file. Do you know if there is another TERMINATED BY I should be using? If not, I wonder how I can find out? A/ I think you could export your xls file into a comma separated value file (CSV). In excel File/Save as/CSV then with the Notepad you can delete the first line of the csv file (if there are column headers in your xls file). For example if your xls file is like Year NumberDate Total Unit ID Unit Name 20039253 05/05/2003 -36.365,003202 Unidad Programación 20039030 06/03/2003 1 4201 Depto. Consumidores 20039055 14/03/2003 3.000,00 7020 Proyecto de Distribución 20039798 26/08/2003 3.000,00 3210Sección Transportes y Taller your csv file will be: Year;Number;Date;Total;Unit ID;Unit Name 2003;9253;05/05/2003;-36.365,00;3202;Unidad Programación 2003;9030;06/03/2003;1;4201;Depto. Consumidores 2003;9055;14/03/2003;3.000,00;7020;Proyecto de Distribución Subterránea 2003;9798;26/08/2003;3.000,00;3210;Sección Transportes y Taller If you delete the first row (headers) you will have only the raw data Then you could save your file as a txt (but I think any extension should work) Then LOAD DATA LOCAL INFILE 'myfile.txt' INTO TABLE mytable FIELDS TERMINATED BY ';' ENCLOSED BY '' LINES TERMINATED BY '\n'; I think you could left out the clause ENCLOSED BY '' because this is the default Also, please note: 1) If LOCAL is specified, the file is read by the client program on the client host and sent to the server. If LOCAL is not specified, the file must be located on the server host and is read directly by the server. 2) If you have generated the text file on a Windows system, you might have to use LINES TERMINATED BY '\r\n' to read the file properly, because Windows programs typically use two characters as a line terminator. Some programs, such as WordPad, might use \r as a line terminator when writing files. To read such files, use LINESTERMINATED BY '\r'. The other question I have is: do I have to create a table within the MySQL database with exactly the right number of columns ahead of time for the import to work? - this is what I did. If so, is there a way to import info from a .dbf or .xls file without knowing the structure of the table ahead of time? A/ As far as I know you need to know the table´s structure in advance. From the mysql manual: By default, when no column list is provided at the end of the LOAD DATA INFILE statement, input lines are expected to contain a field for each table column. If you want to load only some of a table's columns, specify a column list: mysql LOAD DATA INFILE 'persondata.txt' The whole history is in: http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html Thanks, John on 7/6/04 3:59 PM, Chinchilla Zúñiga, Guillermo at [EMAIL PROTECTED] wrote: Try, for example: LOAD DATA INFILE 'myfile.cdf' INTO TABLE mytable FIELDS TERMINATED BY ',' ENCLOSED BY '' LINES TERMINATED BY '\n'; -Mensaje original- De: John Mistler [mailto:[EMAIL PROTECTED] Enviado el: Martes, 06 de Julio de 2004 04:51 p.m. Para: [EMAIL PROTECTED] Asunto: DBF to MySQL I am wanting to parse the info in a .dbf file (or .xls file for that matter) and place it in a table in a MySQL database. Is this something that I can do with the server side MySQL application, or do I need to figure out a way to do it on the client side? Any description of the method would be very welcome! For what it is worth, I am a Mac OSX.3 user. Thanks, John -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: DBF to MySQL
Try, for example: LOAD DATA INFILE 'myfile.cdf' INTO TABLE mytable FIELDS TERMINATED BY ',' ENCLOSED BY '' LINES TERMINATED BY '\n'; -Mensaje original- De: John Mistler [mailto:[EMAIL PROTECTED] Enviado el: Martes, 06 de Julio de 2004 04:51 p.m. Para: [EMAIL PROTECTED] Asunto: DBF to MySQL I am wanting to parse the info in a .dbf file (or .xls file for that matter) and place it in a table in a MySQL database. Is this something that I can do with the server side MySQL application, or do I need to figure out a way to do it on the client side? Any description of the method would be very welcome! For what it is worth, I am a Mac OSX.3 user. Thanks, John -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Recommendation on god MySQL books
I think Wiley´s Mysql enterprise solutions could be a good option. It´s a great book and have an entire chapter covering replication -Mensaje original- De: Bartis, Robert M (Bob) [mailto:[EMAIL PROTECTED] Enviado el: Jueves, 17 de Junio de 2004 11:44 a.m. Para: [EMAIL PROTECTED] Asunto: Recommendation on god MySQL books I'm looking for suggestions on books that would help me to improve my understanding of MySQL operations, admin operations, replication etc. I'm new to MySQL and am about to embark on supporting a database for my team to use in recording test results. Any suggestions and recommendations ones to stay away from? Thanks in advance Bob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Perfomance issues
Hi folks: I would like to know if there are a perfomance loss using PEAR DB comparing with PHP native Mysql functions, and if this is a significant issue. Also I´m wondering if using persistent connections in PHP could lead to have many connections at the same time slowing the server, and how to handle this. Thanks in advance -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Perfomance issues
Hi folks: I would like to know if there are a perfomance loss using PEAR DB comparing with PHP native Mysql functions, and if this is a significant issue. Also I´m wondering if using persistent connections in PHP could lead to have many connections at the same time slowing the server, and how to handle this. Greetings from Costa Rica, Pura Vida!!! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]