01-29-2019
A question: can you not place your data temporarily in a file and use command line tools to get your answer, since the query runs for potentially a very long time? What table contains "data"? Then you can use a subquery.
Plus, having been an admin and system programmer for a long time I would commend code like this to help from a very senior techie. Quadratic time queries may have system wide impacts that affect other processes and users. This is a polite way of me saying if you did this you would incur the wrath of a lot of people. Just saying. If it is your desktop, okay, maybe.
8 More Discussions You Might Find Interesting
1. Programming
Hi there,
I have a hierarchical database that include 4 tables. Table A is the parent of B, B is Parent of C, C is parent of D. If I want to query everything in D that is associated with A.name, how do I do that? Thanks!
YanYan (0 Replies)
Discussion started by: pinkgladiator
0 Replies
2. Shell Programming and Scripting
Hi there, I have a table that stores multiple records for many different servers, each of which is timestamped ... I wanted to write a query that would enable me to only output the "latest" record (based on timestamp) for each "unique" server. So for example my main table looks like this
... (3 Replies)
Discussion started by: hcclnoodles
3 Replies
3. Web Development
hello all
i have 2 columns every column in the following format
column1
2011-04-01 11:39:54
column2
2019-02-03 00:00:00
i want get difference between above data as following
2 days 11:39
how to do so ?
i tried many functions but nothing works
please advice what is the query... (6 Replies)
Discussion started by: mogabr
6 Replies
4. Shell Programming and Scripting
Hi,
I want to access mysql query from database , for that i have tried the below code
#! /bin/bash
TABLE_NAME=database1
USER_NAME=root
IP_ADDR=111.20.9.256
somevar=`echo "select altid from alert where altid='2724'"| mysql -h $IP_ADDR -u $USER_NAME $TABLE_NAME `
echo $somevar
... (1 Reply)
Discussion started by: aish11
1 Replies
5. Programming
Hi,
I want to run below query on shellscript but having one problm.
ADV=$( mysql -h "$IP_ADDR" -u "$USER_NAME" "$TABLE_NAME" -BNe" SELECT ADV FROM indata where inid='$INSTRUID' and Date='$latest Date';" )
here Date column contans different below dates
2011-12-01... (0 Replies)
Discussion started by: aish11
0 Replies
6. Shell Programming and Scripting
Hi,
I want to run below query on shellscript but having one problm.
ADV=$( mysql -h "$IP_ADDR" -u "$USER_NAME" "$TABLE_NAME" -BNe" SELECT ADV FROM indata where inid='$INSTRUID' and Date='$latest Date';" )
here Date column contans different below dates
2011-12-01... (11 Replies)
Discussion started by: aish11
11 Replies
7. Programming
Hello
i have created mysql query to compare to values and get difference in percentage
as following:
SELECT file_name, 100 - ((100 * (SELECT file_count FROM xipi_files z WHERE x.file_group = z.file_group AND x.file_name = z.file_name AND z.insert_date = CURDATE( ) - INTERVAL 1 DAY)) /... (1 Reply)
Discussion started by: mogabr
1 Replies
8. Programming
Hi All,
i have a table in mysql with the following data
Table name Test
Assettype Serial_No Status location
Mouse 123456 In Stock chennai
Mouse 98765 Allocated chennai
Keyboard ... (2 Replies)
Discussion started by: venkitesh
2 Replies
LEARN ABOUT OPENSOLARIS
time-admin
time-admin(1) User Commands time-admin(1)
NAME
time-admin - Basic configuration of system time, date, timezone and NTP client.
SYNOPSIS
time-admin [gnome-std-options]
DESCRIPTION
time-admin enables the user to configure the default timezone and current date/time on the system. It also enables the user to turn on
auto-synchronisation of this using NTP.
OPTIONS
The following options are supported:
gnome-std-options Standard options available for use with most GNOME applications. See gnome-std-options(5) for more informa-
tion.
EXAMPLES
Example 1: Running the main application.
example% time-admin
EXIT STATUS
The following exit values are returned:
0 Application exited successfully
>0 Application exited with failure
FILES
The following files are used by this application:
/usr/bin/time-admin Executable for time and date configuration.
/var/spool/setup-tool-backends/backup/time
Backup directory for files that are modified.
/var/run/setup-tool-backends/debug/time
Debug logs can be found under here.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWgnome-system-tools |
+-----------------------------+-----------------------------+
|Interface stability |Uncommitted |
+-----------------------------+-----------------------------+
SEE ALSO
Latest version of the GNOME Desktop User Guide for your platform.
users-admin(1), shares-admin(1), services-admin(1), network-admin(1), gnome-std-options(5), rtc(1M), ntpdate(1M), xntpd(1M), attributes(5)
NOTES
Written by Darren Kenny, Sun Microsystems Inc., 2006.
SunOS 5.11 6 Nov 2006 time-admin(1)