Quote: select * from s_transaction Where between UNIX_TIMESTAMP('2010-06-28 15:40:00') and UNIX_TIMESTAMP('2010-06-28 16:00:00') and user_id = '15545941';
Is this the syntax correct to retrieve a particular user transaction between given time period? because "its return error check the syntax near the between"
i ,musing mysql5 at fedora12 i have just installed it but i ,m using mysqladmin -p root password mypassword it says ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysqladmin -uroot password 123456' at line 1
View 10 Replies View RelatedMental note: ignore start-up process scroll.
Okay, now MySQL is just being (even more) difficult. Prior to boot's starting MySQL, I notice the line
Code:
/etc/rc2.d/S19mysql: line 132: syntax error near unexpected token ')'
Near?? Line 132 consists of
Code:
'stop')
Which is proper, and identical to all the other /etc/rc#.d/S19mysql scripts that don't result in errors. C'mon...!
I have a logfile which looks like:
tableabc 1786rows
tabledfg 8374rows
tablefhd 726rows
[code].......
Now i have to writ a script which takes this log as input and quesries the DB for each table. So,I want to: input the logfile
start a while loop.So,while read LINE This variable LINE would store the table name by CUT using a delimiter once the table name is ready it makes a connection to DB and queries the table for its rowcount writes the rowcount to an O/P file.
I have inherited our Linux packaging and as the number of versions increase, the number of conflicts is starting to get a bit unmanageable. I believe the easiest way would have been to keep the package names the same and just change the release in the spec file but unfortunately I am past that as a lot of these packages are rolled out to our estate. (I am told there were reasons for not keeping the package name the same and incrementing the version/release)
Is it possible to wildcard conflicts so I don't need to keep adding as new versions are created. For example, instead of using all the conflicts below, have something along the lines of AAtest45* <= 1.4 & BBtest45* <= 1.4 Meaning that all I would need to do was change this to 1.5 at the next release (the packages below version matched the release in the spec file)
[Code]....
I need help about the error in my website. I have the following error....
Code:
user warning: Got error 134 from storage engine query: SELECT data, created, headers, expire, serialized FROM cache WHERE cid = 'theme_registry:database1' in /var/www/html/web/includes/cache.inc on line 26.
I have an ubuntu 10.10 server and want to run a script on it to check if a process is running. If it is not running, it will start the process and also write into a log file.
When running the script i get the following error message:
syntax error near unexpected token `else'
Here is my script.
With this sqlite query ? I have these tables:
what is the query to list all cities and its neighboring cities like this?
I have the following mysql query which works great.
Code:
SELECT msg FROM `logs` WHERE ((`host` = 'aaa.bbb.ccc.ddd') OR (`host` = 'aaa.bbb.ccc.ddd')) AND `msg` REGEXP CONVERT( _utf8 'physical addresses' USING latin1 ) COLLATE latin1_swedish_ci
I need to refine this query so that I can query the last # hours using the `datetime` field in the database. I have researched the DATE_SUB function and can query for example the last 1 hour like this:
[Code]....
I am on a CentOS 64 bit and used webmin to rotate MySQL slow query log. Now the thing is although logs are being rotated daily but the new log files being created are empty which means MySQL is unable to write them due to some reason. I have checked using "ls -l" that both permission and owner of files is same but still MySQL is not writing logs. What could be the reason?
View 10 Replies View RelatedI want to install mysql query browser in debian
View 1 Replies View RelatedHow to check memory in unix or nix
View 1 Replies View RelatedI am running Ubuntu 10.04 LTS. I am trying to run a query browser for mysql but keep receiving the following error:
X11 connection rejected because of wrong authentication.
The application 'mysql-query-browser-bin' lost its connection to the display localhost:10.0; most likely the X server was shut down or you killed/destroyed the application.
In ssh_config, I do have ForwardX11 set to yes.
I am a Novell (now defunct) CNE tring to learn Linux and am having a lot of trouble finding out where the WB 6-6 is wrong in the syntax for adding local4... the the syslog-ng config file. In the instructions there are discrepancies between commas and simi-comma, they are both in the statements in no particular order. there is no pattern to them. Here is what the book shows:
filter f_local4debug { level(debug) and facility(local4); };
When I try to input this in the Gnome terminal window to try and find out where it goes wrong I get the following: -bash: syntax error near unexpected token "(" If I can get the correct syntax I belive I can use the info to get past the rest of this portion of the lesson. I am desperate to learn Linux as the only jobs out there for a Novell CNE are migrations to MS, which really sucks, since MS really really sucks.
I know the 'history' command give me a list of the commands I have typed into the Unix terminal.
How do I see the command history for all of the users currently logged onto the system?
How to check quota of a user in UNIX/Linux?
View 2 Replies View RelatedCan query browser be installed in 11.4??
I've tried to use workbench but it's such a big step backwards in that you can't easily edit the output from a "select x,y,z from table" query. I'd have thought that was a pretty basic requirement...
I have created a database which stores students grades for different stages of a project. One of the stages of the project is the specification part. I have a simple bit of html code which is going to be used as the searching facility. I want the user to be able to enter their ID and then it will display only their results. At the moment, it is displaying the results for EVERY student because I cant seem to find the correct syntax for my statement.
Heres the HTML code
<html>
<head>
</head>
<body>
<body bgcolor="#6881bb">
<center>
[Code]....
At the moment when i click the button, no matter what I enter every students marks appear on the screen.
I think, but obviously dont know for sure because if i did i would know how to solve the problem, the code that i need to change is in green.
When i enter this query to mysql:
Code:
return this error:
Code:
when i delete the insert part :
Code:
query is ok:
Code:
1 row in set (0.00 sec)
i have MySQL on my CentOS server and have installed it and got it up and running through the command line.
I have changed root's username and password so there is no user called 'root' anymore. I also created a database called pancakes.Now when i try to log in using Query Browser, i put the server's IP in 'hostname', my new roots username and password in 'username' and 'password'.When i try to log in it gives me error 1130 and says connection from myhostname not allowed.
Trying to export a Mysql query to a .csv file the query draws from multiple tables, e.g. sales, purchase and currency
Code:
What i'm trying to do is to export both the sales and purchase to a single line where both the currency for the sales and the purchase is specified.
Basically like this:
Code:
Problem here is that i'm stating currency.value twice in the same select and don't know how to define which currency.value applies to sales and which to purchase.
It is under PHP/MySQL
$queryresult = $conn->query("INSERT INTO normalrequests VALUES($finalkey, 1234, 5678, FALSE)");
It is connected to the database successfully but I feel there is something wrong with the statement up there.
I am new to shell scripting, bash specifically.
I am trying to run the following script:
Code:
When trying to execute I always get this error:
Code:
In case you need to know the permissions. Here is it:
Code:
I run the script using the following command:
Code:
i will be quick, im trying to send a mysql query output into an array ie:
Code:
declare -a HD
HD=`echo "USE db; SELECT uid FROM user" | mysql -u $login -p$pwd -h $dbhost -B`
echo ${#HD}
those vars in mysql connection are previously and correctly assigned.
but got an error
script.sh: 2: declare: not found
I am querying a single string column in a table. The string values have spaces in them. I want to loop over each value in bash. I set IFS to split lists on newlines instead of spaces. When I try this, it is splitting the list of results on the actual character 'n', not the newline ''.
DATA=`mysql -u root -ppassword --silent 'SELECT name FROM table_a;'`
IFS=$'
'
for i in $DATA; do
echo "item = $i"
[Code]....
My brother has Tri boot Ubuntu ,7 and Vista ..GRUB2 is the bootloader..The problem : At boot after the Lenovo splash disappears , there appears some 4 to 5 lines of error , error:syntax error GRUB or similar..This is visible only for a fraction of a second before the GRUB2 menu pops up...
The OS es load properly on selection in the menu so no loss of functionality One another problem is there is no OS highlighted by default and the timeout message "Automatic Boot in 10 Secs" does not appear Reinstalling GRUB does not solve the issue
I am not sure if this is possible. I have IP's stored in a mysql database. When I query the database, it returns the IP. I would like to replace the IP with something else prior to displaying the results. Is it possible even though I have not stored it in the database?
I have the following in a while loop (mysql_fetch_array).
Code:
<td align="left">' . $row[IP] . '</td>
Instead of displaying $row[IP] from the database, I would like it to display something else which I define in the PHP code but based on the IP.
ie. aaa.bbb.ccc.ddd = hostnameABC
So I've got a rather vast database, one of the columns is date in the following format: DD/MM/YY HH:MM:SS. This is starting to cause problems with a php page I'm writing which asks the user for a 'start date'. Would it be better for me to split the date column into date and say time? Or is there a way of using distinct and masking the times.
View 10 Replies View RelatedI am using MySQL 5.0.77 Version rpm on CentOS 5 Red Hat Linux. I want to install micro second slow query log patch on this MySQL S/W version.As I found the slow query micro second patch on percona site i.e. [URL]step by step to install above mentioned patch with rpm based MySQL installation? Do we need MySQL source files to apply patch ?
View 13 Replies View RelatedDoes anyone know where I can get a link to download MySql query browser(windows version)?
I want to query my database on my fedora box in windows to make life easier... I can not seem to find a link to download the query browser though