Tag Info

New answers tagged

-1

You can use SELECT *, from_unixtime(received_date), from_unixtime(other_date_field) FROM table; You will have your two date columns shown in both time stamp and readable formats in the result. You might want to use AS to rename the readable columns like so: SELECT *, from_unixtime(received_date) AS date1, from_unixtime(other_date_field) AS date2 FROM ...


1

Problem The value you are setting has double quotation marks. You need to escape these by using backslash \ This tells the script to use the characters as part of the value and not part of the script it's self. Solution Just a simple mistake in your coding, try... mysqli_query($con,"UPDATE table SET description='<a href=\"http://123456.biz ...


2

Your quotes are the issue. You're using double quotes (") twice in the string and the parser is getting confused. Try escaping them instead with a backslash(\): mysqli_query($con,"UPDATE table SET description='<a href=\"http://123456.biz/index.php/123/321/456/*/789\">text</a>' WHERE description IS null;");


2

Dont have PHP installed, can't test if this is working, please try the following: mysqli_query($con,"UPDATE table SET description='<a href=\"http://123456.biz/index.php/123/321/456/*/789\">text</a>' WHERE description IS null;");


0

You can split a large file in Eclipse. I have tried a 105GB file in Windows successfully: Just add the MySQLDumpSplitter library to your project: http://dl.bintray.com/verace/MySQLDumpSplitter/jar/ Quick note on how to import: - In Eclipse, Right click on your project --> Import - Select "File System" and then "Next" - Browse the path of the jar file ...


0

Your user name is stored in an environment variable. If you open a cmd windows (start run cmd) you can enter the following command to find out your user name: echo %username% Example C:\test>echo %username% DavidPostill C:\test> Source Windows Environment Variables An A-Z Index of the Windows CMD command line is an excellent reference for ...


1

Just start your Mysql-Server like this: service mysql start


0

The fix for this is to add a counter in the module config, and call it from the authorize section of the site config file. In modules/counter add: counter dailylocation { filename = ${db_dir}/db.daily key = User-Name count-attribute = Acct-Session-Time reset = daily counter-name = Max-Daily-Session-Location-Time ...


1

I've managed to finally solve this. By looking at the logs I noticed an error saying that 'utf8_general_ci' is not valid for CHARACTER SET 'latin1' and by googling a little, the solution was in this post in a blog, quoting: In this case mysqld trying to start with character-set-server = latin1 and collation-server = utf8_general_ci, which is not valid. ...


1

The MySQL server likely needs to be told to listen to connections from the outside. Depending on which distribution you use, find or create the right .cnf file (typically /etc/mysql/conf.d/local.cnf or worse /etc/my.cnf) with a [mysqld] block and add the line: bind-address = 0.0.0.0 Afterwards, restart the MySQL service (typically service mysql restart) ...


0

A few google searches found me this postfix-admin wiki page: http://sourceforge.net/p/postfixadmin/wiki/Regex_aliases/


1

There are two possible situations: root user hasn't a password. Try: mysql -u root. You are using the wrong password. These are the steps to change the password (keep in mind that other databases and applications using this root user could stop working): Stop mysql. Start it with: mysqld_safe --skip-grant-tables Connect using: mysql -u root. If you ...


1

You can use the PortableZIP edition of Strawberry Perl, available here. There's also a ZIP edition that doesn't require admin privileges, but you need to run some post-install scripts manually after unzipping. Depending on your script something like Perl2Exe might also help: Perl2Exe is a command line program for converting Perl scripts to executable ...


0

It's not quite clear which locations System Restore covers but what you describe is quite possible. The simplest way to prevent it is to move your MySQL data elsewhere: Confirm your datadir as follows: mysql> select @@datadir; +---------------------------------------------+ | @@datadir | ...


0

First install the MySQL ODBC driver. 5.1 or 5.2. I like to set it up for unicode. Then get the MySQL server running. Then from Access: New | Link table | ODBC | MySQL5.1 or MySQL5.2 ODBC Driver and select the base and table you want to link to. (There is better documentation elsewhere, and you will probably need to consult it, but this is the nuts and ...



Top 50 recent answers are included