Posted
by Vincent
on Stack Overflow
See other posts from Stack Overflow
or by Vincent
Published on 2010-06-09T19:38:18Z
Indexed on
2010/06/09
19:42 UTC
Read the original article
Hit count: 163
All,
I have a database table in mysql with a field that is of "TIMESTAMP" type. I need help writing the SQL query to update the field with the current timestamp.
UPDATE tb_Test set dt_modified = ?????
Thanks,
© Stack Overflow or respective owner
as seen on Ask Ubuntu
- Search for 'Ask Ubuntu'
I tried everything till now:
sudo apt-get remove mysql-server mysql-client mysql-common
sudo apt-get purge mysql-server mysql-client mysql-common
sudo apt-get autoremove
and even more commands...
But whenever I am trying to locate mysql. I get a no. of files related to mysql
command:
shell>>…
>>> More
as seen on Server Fault
- Search for 'Server Fault'
Mysql was started:
/usr/bin/mysqld_safe --datadir=/srv/mysql/myDB --log-error=/srv/mysql/logs/mysqld-myDB.log --pid-file=/srv/mysql/pids/mysqld-myDB.pid --user=mysql --socket=/srv/mysql/sockets/mysql-myDB.sock --port=3700
but when I'm trying to do something:
ERROR 1548 (HY000) at line 1: Cannot…
>>> More
as seen on Server Fault
- Search for 'Server Fault'
A client of my IT-consulting service owns a web-development shop. He's been having problems with a Slackware 12.0 server running MySQL 5.0.67. The machine was set up by the client's sysadmin, who left on bad terms. My client no longer employs a sysadmin.
As far as I can tell, the only copy of MySQL…
>>> More
as seen on Server Fault
- Search for 'Server Fault'
Can't start mysql with:
sudo /usr/bin/mysqld_safe --datadir=/srv/mysql/myDB --log-error=/srv/mysql/logs/mysqld-myDB.log --pid-file=/srv/mysql/pids/mysqld-myDB.pid --user=mysql --socket=/srv/mysql/sockets/mysql-myDB.sock --port=3700
120222 13:40:48 mysqld_safe Starting mysqld daemon with databases…
>>> More
as seen on SQL Authority
- Search for 'SQL Authority'
MySQL is one of the most popular database language and I have been recently working with it a lot. Data have no barrier and every database have their own place. I have been working with MySQL for quite a while and just like SQL Server, I often find lots of people asking me if I have a tutorial which…
>>> More
as seen on Server Fault
- Search for 'Server Fault'
Hi guy,
I would like to update my php 5 in my server. At this moment, I use php 5.2.0 so I want to update it to php 5.2.4 (not php 5.3). I tried to do this:
aptitude update
aptitude upgrade
63 packets were updated but not php which is always in 5.0
How can I update my php please ?
Here is the…
>>> More
as seen on Server Fault
- Search for 'Server Fault'
I just tried to upgrade my version of PHP on Ubuntu 12.04 and now I have messed it up. First I did this:
sudo add-apt-repository ppa:ondrej/php5-oldstable
Then I did this:
sudo apt-get update
Then finally I did this:
sudo apt-get install php5
And now I am getting an error message about Sub-process…
>>> More
as seen on Server Fault
- Search for 'Server Fault'
I want to add command-line support for PHP5 on my server. When I run aptitude install php5-cli I get a message saying that my PHP modules/packages have unmet dependencies.
Here is a list of packages that suffer from these "unmet dependencies" and needs and upgrade:
php5-gd
php5-curl
php5-mysql
php5-cgi
They…
>>> More
as seen on Server Fault
- Search for 'Server Fault'
I want to add Mysqli support to a machine running:
Server Version: Apache/2.2.4 (Ubuntu) PHP/5.2.3-1ubuntu6.3
I would rather not update more things then I need to.
I run the following: sudo apt-get install php5-mysql
However, as the ubuntu version is old I get the following.
WARNING: The following…
>>> More
as seen on Ask Ubuntu
- Search for 'Ask Ubuntu'
i wanted to install php5 5.3.2, so first deleted all the php5 files
sudo apt-get purge php5 php5-cli php5-common php5-mysql
and also delete the deb files form
/var/cache/apt/archives
so now there is no deb file on the system then i add this person repository
sudo apt-add-repository ppa:sushkov/personal
because…
>>> More
