convert tz - Looking for a way to Query data from MySQL database & write it to a output txt file -

-

looking way query data mysql database & write output txt file. trying query linux server db remote windows box.

mysql query: 

mysql -u xxx -pxxx -h ttplxapp-esm01.abc.com -d telalert -e "select max(convert_tz(start_time,\"+00:00\",\"-04:00\")) time,group_concat(username separator \" \") contact, message message sends convert_tz(start_time,\"+00:00\",\"-4:00\") \"$query_date%\" group alert_id order time desc ;"

a java script or script ideal.

try select...from statement into outfile clause.

select syntax.


Comments

Post a Comment

Popular posts from this blog

Glib GIOChannel -

-
i'm trying tutorial on glib uses giochannel. i'm using ubuntu 11.04 (natty narwhal) glib-2.30.2 (gtk+-3.2.3) , c code. the code here: http://library.developer.nokia.com/index.jsp?topic=/guid-e35887bb-7e58-438c-aa27-97b2cde7e069/guid-817c43e8-9169-4750-818b-b431d138d71a.html the program runs contents of source test file not copied destination file. i'm not receiving error or warning messages. program nothing. what's wrong here? works now, changed line: g_print("usage:<cp source> <destination>\n"); to: g_print("usage: %s <source> <destination>\n", argv[0]); then compiled using: gcc -wall $(pkg-config --cflags gio-2.0) -c io.c gcc -wall $(pkg-config --libs gio-20) -o io io.o run program using: ./io io.c new_io.c
Read more

jsp - java.sql.SQLException: [Microsoft][ODBC Microsoft Access > Driver] Too few parameters. Expected 1 -

-
i'm calling inserstudent.jsp file in action of form addstudent.jsp want insert data in database. my database table's structure below: id|name|rollnumber|phonenumber|studyprogram|status below code inserstudent.jsp <%@page contenttype="text/html" pageencoding="utf-8"%> <%@ page import="java.sql.*" %> <!doctype html> <html> <body> <% string nam=request.getparameter("stuname"); string roll=request.getparameter("sturoll"); string phone=request.getparameter("stuphone"); string prog=request.getparameter("stuprogram"); string stats=request.getparameter("stustatus"); class.forname("sun.jdbc.odbc.jdbcodbcdriver"); string url = "jdbc:odbc:stdprojectdatadsn"; connection c = drivermanager.getconnection(url); statement statement = c.createstatement() ; string sql = "insert students (id, name, rollnumb...
Read more

delphi - When I encode/decode SMS PDU (GSM 7 Bit) user data, do I need prepend the UDH first? -

-
while can encode , decode user data part of sms message when udh not present, i'm having trouble doing when udh is present (in case, concatenated sms). when decode or encode user data, need prepend udh text before doing so? this article provides encoding routine sample compensates udh padding bits (which still don't understand) doesn't give example of data being passed routine don't have clear use case (and not find decoding sample on site): http://mobiletidings.com/2009/07/06/how-to-pack-gsm7-into-septets/ . so far, have been able results if prepend udh user data before decoding it, suspect coincidence. as example (using values https://en.wikipedia.org/wiki/concatenated_sms ): udh := '050003000302'; encoded_user_data_part := 'd06536fb0dbabfe56c32'; // padding, evidently decodeduserdata := decode7bit(udh + encoded_user_data_part); writeln(decodeduserdata); output: "ß@ø¿Æ @hello world" encodeduserdata := encode7bit(decodeduse...
Read more