MySQL

How do I make my MySQL table automatically make a timestamp when new data is added?

Sep 14th, 2011
by admin.
3 comments

I am trying to create a MySQL table with three columns. Two colummns are for data and a third the time at which the data is inserted. When I create the table, how do I write out the command to tell MySQL to create a timestamp column?

What can I do so that a mySQL database automatically resets a certain field to 0 every week?

Sep 8th, 2011
by admin.
1 comment

Hi, I have a site where each time you view a particular page (with a corresponding entry in the database), it adds 1 count to the fields weekplays and totalplays. How can I get it so that every week, it automatically resets weekplays to 0 for all the pages? By the way, the reason I [...]

Bases de datos MySQL y Joomla. phpMyAdmin

Sep 7th, 2011
by admin.
1 comment

Manejo de bases de datos de Joomla con phpMyAdmin. Exportación e importación, migración de sitios.

Tutorial SQL 11 en español. Agrupando. Select, Count, Group By con MySql Workbench

Aug 31st, 2011
by admin.
16 comments

How to connect MS Access & MySQL database with JAVA

Aug 29th, 2011
by admin.
No comments yet

This application will show you how the java is used for connecting the different database system

Aula 1246 banco de dados SQL – MySQL 5 Instalação

Aug 27th, 2011
by admin.
21 comments

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 [...]

Conexión a bases de datos MySQL desde Visual Studio 2008 [parte 1]

Aug 27th, 2011
by admin.
22 comments

artículo producido por Diego Ernesto Farías [tecla] desde Mendoza, Argentina para su blog personal: diegoernesto.wordpress.com

what is the different between oracle and mySQL?

Aug 26th, 2011
by admin.
3 comments

I am having a problem regarding the database that i should use in my program….. and i am confuse if i should use oracle or the mySQL data base please explain their different functions of these two databases? Would it be difficult to use oracle or mySQL?

If i have a mysql database of places with GPS cords, How could i find the places with in 10 miles?

Aug 18th, 2011
by admin.
3 comments

I know in Php how to list something using a while loop. But not sure how i would really do the mysql part. Say i have a database with PlaceID | PlaceName | Lat | Lon Say i have a Lat and Lon of the location i am at. How would i search mysql for [...]

How can i run a php or mysql script automatically every month, quarter or year?

Aug 3rd, 2011
by admin.
1 comment

I have a script for a MySQL Database that adds up all of the numbers in a column and sets it back to zero (its pretty much like an adjusting entry). I don’t want to clear the contents completely because I need them for reporting purposes. I want either PHP or MySQL to run a [...]

← Earlier Posts Newer Posts →

Powered by Yahoo! Answers