January 2009

January 31, 2009

How can I convert a MySQL timestamp into a format I want using PHP?

mysql
danny asked:


I have a colum in a MySQL database that uses datatype TIMESTAMP to save the date and time that a new row is inserted. This displays like 2008-09-21 09:31:25 when retrieved and echoed using PHP.

How can I use PHP to display the data like 21-Sep-08?

Filed under Programming & Design by administrator

Permalink Print 3 Comments

January 27, 2009

how to set up a remote mysql database (a remote database is the one stored on a web hosting server!)

nextblain posted video:


heres a perfect tutorial showing you how to setup a remote mysql database, means a database installed in your remote host! mysql databases are awesome and in this tutorial we are gonna setup a database that contains the username and password of a login system!

Filed under Tech by administrator

Permalink Print 7 Comments

Import Excel to MySQL Database

mikenku posted video:


Take a Microsoft Excel Spreadsheet and import it into a MySQL Database using CSV files and PHPMyAdmin.

Filed under Education by administrator

Permalink Print 6 Comments

How can I set a date type field to auto increment in MySQL?

mysql
Uncle Rico asked:


I’m managing tables with phpMyAdmin.
The dates are in MySQL date string format.

Filed under Programming & Design by administrator

Permalink Print 1 Comment

Aula 1248 banco de dados SQL - MySQL 5 Insert

nerineitzke posted video:


Aqui mais de 1.600 vídeo aulas no site www.informaticon.com.br. Desenvolvido pelo professor Neri Aldoir Neitzke, pós-graduado em Desenvolvimento para Web, professor da Universidade Ulbra e proprietário da Informaticon, email
videoaulas@informaticon.com.br 0xx543330-1222 Carazinho-RS Brasil Obs.: No youtube.com, as video aulas não estão nítidas e apenas a metade das vídeo aulas estão aqui. Caso queira, posso enviar um dvd com centenas de vídeo aulas originais com alta
qualidade, e você ainda vai receber todo o código fonte.

Filed under Education by administrator

Permalink Print

January 24, 2009

Monty Widenius (MySQL) vs. Josh Berkus (PostgreSQL).

lenify posted video:


At the Sun party at OSCON 2008, Monty and Josh decided to perform a little sumo wrestling feat. Needless to say, the score was 5-0, advantage MySQL

Or as monty says, “this is what we do to people who leave sun”!

Filed under Comedy by administrator

Permalink Print 3 Comments

What is the best/easiest way to backup a MYSQL database to sourcecontrol?

mysql
Superpappa asked:


Its a hosted account with PHP and phpMyAdmin. The source control is local subversion.
The idea is to easily see relevant differences, and I suspect that for example SQL code backup is not the best way to do that.
How is this better than PHPMyAdmin?
Was thinking of something like XML, or perhaps having just one item pr line.

Filed under Software by administrator

Permalink Print 2 Comments

mySQL? ?

mysql
Liza asked:


How can you get the line break or paragraph that you entered when you input the data when you retrieve it from mySQL?

Filed under Programming & Design by administrator

Permalink Print 2 Comments

What is the easiest way to practise using PHP and mySQL?

mysql
bob1704 asked:


I want to start using PHP and mySQL to help me with my work. Does anyone know if and how I can set up somewhere locally on my computer or something where i can test my pages and database as if it were live on a web server?

Filed under Programming & Design by administrator

Permalink Print 4 Comments

January 20, 2009

Crear base de datos mysql + php registro de usuarios prte2

tatpe posted video:


http://www.videotutoriales.us/

Más detalles de Tutorial y tambien los scripts, visita nuestra web: http://www.videotutoriales.us/

Filed under Howto by administrator

Permalink Print