Re: name of a database in mysql....

2012.10.29. 20:59 keltezéssel, FHDATA írta: mysql server 5.1.41 hello Is there a way mysql server can be told to disallow any attempt of creating a database whose name contains certain characters? thanks, make an empty dir in /var/lib/mysql with that name + chmod 000, owner !mysql :)

Re: Запрос

On 04/28/2011 12:40 PM, Johan De Meersman wrote: Я предлагаю более отчетливо английски применения :-p could you guys stop talking alien language on the list, please? t -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: Get date from unix_timestamp only up to the hour

On 02/24/2011 05:41 PM, Bryan Cantwell wrote: How would I go about modifying a unix timestamp to actually represent the 'top of the hour' that it represents? For instance: 1296158500 = 1/27/2011 2:01:40 PM That is in the 2:00 pm hour, how can I find that out and modify it to 1296158400 which

Re: Get date from unix_timestamp only up to the hour

On 02/24/2011 05:56 PM, Nathan Sullivan wrote: Bryan, Maybe something like this would work? select 1296158500 - (1296158500 % 3600) ah, yes, even this one: mysql select now() - interval (unix_timestamp() % 3600) second; +---+ | now() -

Re: Can't read dir of '.' (errno: 13)

mysql show databases ; ERROR 1018 (HY000): Can't read dir of '.' (errno: 13) mysql show databases; ERROR 1018 (HY000): Can't read dir of '.' (errno: 13) mysql $ perror 13 OS error code 13: Permission denied t -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: dumping error

2010.02.06. 12:00 keltezéssel, MuraliKrishna írta: D:\mysqldump -u root -pdbadmin murali murali.sql 'mysqldump' is not recognized as an internal or external command, operable program or batch file. could you stop blogging to the list, please? t -- MySQL General Mailing List For list

Re: MySQL being hacked with commands through URL

James Coffman wrote: Hello all, My website has been hacked using a url such as: -1%20union%20all%20select%201,2,concat(username,char(58),password),4,5,6%20f rom%20users-- . I have been searching on the web for a solution/fix to this issue and I cannot seem to find one. The

Re: How to change root password?

Michael Wilson írta: I am running MySQL 5 on OS X Snow Leopard... Have it set up (by installing the pref pane) to always be running as soon as my MacBook starts. For some odd reason, I can't remember the password I issued for root user and wish to either change it back to blank or a new

Re: Creating a New DB / User

Carlos Williams írta: On Wed, May 13, 2009 at 11:15 AM, Michael Dykman mdyk...@gmail.com wrote: One thing though: your user does not need the 'WITH GRANT OPTION' bit as that gives them permission to gratn permissions to other users, which I don't think is what you want. How do I change the

Re: How to count # of character occurrences in a string?

I have a Char column with text data like ab:cdef:h and I'd like to count the number of : in the column. I can't find an easy way to do it. I thought there should be a MySQL function to do this. Any suggestions? select length('aa:bb:cc:dd')-length(replace('aa:bb:cc:dd',':','')); btw ever

Re: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'ODBC'@'localhost' (using password: YES)'

Varuna Seneviratna írta: I am using WinXP.I am wanted to shutdown MySQL service from the command line and ran the command mysqladmin -p root shutdown next the root password was asked for,I entered the correct password, when I entered the password the below displayed error was the result

Re: convert week of the year into a date string

Ananda Kumar írta: Hi All, I think i worked on this and found the results. I did the below. 1. Multiplied the week_of_the_year with 7 (7 days per week), to get the total number of days from begning of the year. 2. used mysql function makedate makedate(year,number of days from the start

Re: How do I get the file names from a certain directory in SQL?

I accept that.. but my requirement is , I have some no of Excel files..I just need to check the modified time of the files ,if it is modified currently then I need to open those files and convert the excel data to database.. otherwise i didnt change anything in my database.. how can i

Re: Selecting rows by DATE ranges

date(), date_format() t Miguel Cardenas írta: Hello list I found a little problem with an application am developing, in particular creating reports by DATE ranges. Examples: select ... where date2007-01-01; returns all records where date is greater (and equal inclusive) to 2007-01-01

Re: Sort Select by List

Keith Spiller írta: Hello, RE: Sort Select by List I'm wondering how I would turn three different queries: SELECT * FROM team WHERE office = 'Exec' SELECT * FROM team WHERE office = 'VP' SELECT * FROM team WHERE office = 'Dir' Into one query with the sort order of office =