Search Results

Search found 17206 results on 689 pages for 'mysql embedded'.

Page 289/689 | < Previous Page | 285 286 287 288 289 290 291 292 293 294 295 296  | Next Page >

• How to know from a bash script if the user abruptly closes ssh session

  - by Figo

  I have a bash script that acts as the default shell for a user loging in trough ssh. It provides a menu with several options one of wich is sending a file using netcat. The netcat of the embedded linux I'm using lacks the -w option, so if the user closes the ssh connection without ever sending the file, the netcat command waits forever. I need to know if the user abruptly closes the connection so the script can kill the netcat command and exit gracefully. Things I've tried so far: Trapping the SIGHUP: it is not issued. The only signal issued i could find is SIGCONT, but I don't think it's reliable and portable. Playing with the -t option of the read command to detect a closed stdin: this would work if not for a silly bug in the embedded read command (only times out on the first invocation)

  Read the article

• What is the best DBMS for the job?

  - by Evernoob

  Just had a discussion at work about the merits of using PostgreSQL over MySQL and vice-versa. Does anyone have any practical experience where there is a valid reason to use one over the other? Some people were saying that Postgre is better for security purposes whereas MySQL is becoming more feature rich... I'm not sure what to make of it.

  Read the article

• Which database invented the "limit" SQL query syntax?

  - by Howard

  MySQL has a nice feature (although non standard) which allow to query resultsets' limit, offset as SELECT * FROM TABLE LIMIT M, N; Is it created by MySQL? or Postgres?

  Read the article

• is the code given in description is executable in Windows system?

  - by OM The Eternity

  is the code given is executable in Windows system? as it seems to be Linux commands echo 'create database foo2' | mysql -uroot mysqldump --skip-triggers -uroot foo | mysql -uroot foo2

  Read the article

• SSL_accept hangs... sometimes ( C, linux, openssl )

  - by zbigh

  I'm currently working on an embedded linux system. There are two crucial client applications on the system that connect to an external server ( on another embedded system, all written in C ). The two apps use different certificates. The ssl connection works... At least usually, but from time to time an error occures: the server hangs on SSL_accept() when accepting connection from one of the applications - the one using older certificates. Restarting the server application does not help, nor does restarting the client - the only way is to reboot the server system, unless I create a symbilic link to the new certificates used by the other app - only then will restarting the server app work. Never does the error occur when both applications use the same, new certificate. Could this happen due to some strange openssl cache or something like that?

  Read the article

• Looking for open sourced BI (My Sql)

  - by fatnjazzy

  Hi, I know that there are few open sourced / Free BI projects and I am looking recommendations. I have a growing Mysql database that i got tired from writing sql queries + gui + filtering over and over again. if i am not able to find a free one than my budget will be: (1$ - 2500$ ) My needs are: Mysql 5 Connection. user permissions export options Basic Dashboard -- nice to have: Web Based GUI Development framework integration in PHP

  Read the article

• How do I conditionally select a field from one of two tables?

  - by freakwincy

  I have two tables invoices and pending_payments both of which have the following rows in common: invoice_id and balance. I want to do a select in MySQL that'll work thus: [pseudo-code] if(invoice_id exists in pending_payments table) { select balance from pending_payments where invoice_id = yadayadayada } else { select balance from invoices where invoice_id = yadayadayada } Is this even doable in MySQL? If so, how?

  Read the article

• Average rating script

  - by MILESMIBALERR

  I need to know how to make a rating script for a site. I have a form that submits a rating out of ten to mysql. How would you get the average rating to be displayed from the mysqk column? ---using PHP with mysql

  Read the article

• Queries stuck in "copying to tmp table"

  - by Parik

  I am running some sample tests against mysql, and finding that there are a bunch of queries which are stuck in "copying to tmp tables". They remain stuck in the same state. They are usually aggregate queries and I can kill those queries. But how can I find out what is causing them to be stuck? I am using mysql 5.1.42 with the innodb plugin.

  Read the article

• Getting duplicate count when executing INSERT IGNORE via JDBC

  - by Nickolay Komar

  Is it possible to get the duplicate count when executing MySQL "INSERT IGNORE" statement via JDBC? For example, when I execute an INSERT IGNORE statement on the mysql command line, and there are duplicates I get something like Query OK, 0 rows affected (0.02 sec) Records: 1 Duplicates: 1 Warnings: 0 Note where it says "Duplicates: 1", indicating that there were duplicates that were ignored. Is it possible to get the same information when executing the query via JDBC? Thanks.

  Read the article

• Can I create a database using PDO in PHP

  - by thearchitect

  I am create a class which uses PDO to interact with MySQL. Can I create a new MySQL table using PDO?

  Read the article

• Maintain case sensitivity when importing db into windows

  - by razass

  I have an export from a MYSQL database on a linux machine however when importing that database into MYSQL on windows all of the table names that were camel cased are now all lower case. The sql dump has the correct case in it but the importing via phpmyadmin seams to remove these. How can I import it and keep the case? Thanks

  Read the article

• Utilizing 5 physical servers in 1 cluster

  - by Vijay Gharge

  Hi all, I have 5 physical servers with low end memory & cpu resources. I want to create 1 cluster using all these servers and want to run mysql db on the same such that mysql db would utilize 5 server's CPU power to execute db queries & same for memory. Could you please help me understanding how to achieve this? Regards,

  Read the article

• how to ensure comparison is case sensitive?

  - by newguy

  Hi there, im trying to do a comparison in MYSQL but wish for it to be case sensitive ex: $userID="test" $q = db_query("select * from users where user_id = '" . $userID . "'"); In DB: userid = "TEST" Ho do i go about making sure the mysql query does not return TRUE for this query as the userid varialbe doesnt match the case of the userid in the database thanks

  Read the article

• gauge chart is not displaying any thing

  - by Sandy

  i am trying to display the latest speed in mysql database on guage chart. i have tried so many things but gauge is not display plz any can help me...my code is attached and php part shows the correct value but dont know why guage is not display <?php $host="localhost"; // Host name $username="root"; // Mysql username $password=""; // Mysql password $db_name="mysql"; // Database name $tbl_name="gpsdb"; // Table name // Connect to server and select database. $con=mysql_connect("$host", "$username")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot select DB"); $data = mysql_query("SELECT speed FROM gpsdb WHERE DeviceId=1234 ORDER BY TIME DESC LIMIT 1") or die(mysql_error()); while ($nt = mysql_fetch_assoc($data)) { $speed = $nt['speed']; $jsonTable = json_encode($speed); echo $jsonTable; } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="content-type" content="text/html; charset=utf-8"/> <title> Google Visualization API Sample </title> <script type="text/javascript" src="//www.google.com/jsapi"></script> <script type="text/javascript"> google.load('visualization', '1', {packages: ['gauge']}); </script> <script type="text/javascript"> function drawVisualization() { // Create and populate the data table. var data = new google.visualization.DataTable(<?=$speed?>); // Create and draw the visualization. new google.visualization.Gauge(document.getElementById('visualization')). draw(data); } google.setOnLoadCallback(drawVisualization); </script> </head> <body style="font-family: Arial;border: 0 none;"> <div id="visualization" style="width: 600px; height: 300px;"></div> </body> </html>

  Read the article

• What exactly this error is?

  - by user144842

  Database i am using is MySQL 5.1. I specified, i believe, right connectionstring in my web.config. but when i run my web app. it throws this exception:- MySql.Data.MySqlClient.MySqlException: The user specified as a definer ('root'@'%') does not exist Any help. Why am i getting this?

  Read the article

• How to search dob in db is in the yyyy-mm-dd strucuture. But i have to compare only with yyyy of the

  - by Fero

  Hi How to search dob in db is in the yyyy-mm-dd strucuture. But i have to compare only with yyyy of the field using mysql. example: id dob 1 1999-05-10 2 2000-10-05 I am having only the year 2000 . Now how can i get the record 2000-10-05 using mysql search query. thanks in advance

  Read the article

• how to create image thumbnails using django running on jython?

  - by Nitin Garg

  Hi guys, I am a newbee to django and jython. I need to create and save image thumbnails in database. I am using django running on jython and mysql database. I was exploring python imaging library, but the i found out that i wont work with jython. How do i create image thumbnails using jython and then save them in mysql db?? Any kind of help will be appreciated. thanx

  Read the article

• Sync tables between different database providers

  - by sergiogx

  I have 2 tables in 2 different databases, one is in a mysql server and one is in an informix server. Using .net and odbc, is there a way to identify the differences of both tables and merge them? so that both informix database and mysql database have the same data. thanks.

  Read the article

• How to Limit Text Characters in PHP?

  - by hateMe

  I was wondering how can I limit a users input like HTML maxlength attribute but with PHP, example would be nice? Is MySQL varchar(255) one way to limit a users character input? What are the cons of just counting on MySQL to do this?

  Read the article

• Can I get the full query that a PreparedStatement is about to execute?

  - by ufk

  I'm working with PreparedStatement with MySQL server. example: String myQuery = "select id from user where name = ?"; PreparedStatement stmt = sqlConnection.prepareStatement(myQuery); stmt.setString(1, "test"); stmt.executeQUery(); ResultSet rs = stmt.getResultSet(); How can I receive the full SQL query that is about to be executed on the MySQL server? thanks!

  Read the article

• Count days within a month from date range

  - by G. Muqtada

  I have three date ranges in mysql table as follow from 2013-09-29 to 2013-10-02 from 2013-10-14 to 2013-10-16 from 2013-10-28 to 2013-11-05 I want to count only days that occur in Month of October, for example from first range (2013-09-29 to 2013-10-02) I should get difference of two days (1st and 2nd October) , and it should ignore days from September month, Finally i want to count total days in a given month from above date ranges. Can it be done from direct mysql query. or any short PHP logic.

  Read the article

• Convert date/time string value to .NET DateTime

  - by stighy

  Hi guys, i've this string example value: Sun, 09 May 2010 11:16:35 +0200 I've to insert it into MySql Date/Time field. How can i convert it into .NET format (or Mysql format), so i can make my INSERT INTO mydate='2010-05-09 11:16:35' ? Thank you !

  Read the article

• How to install mysql gem on Mac os 10.6 ?

  - by Mr_Nizzle

  i just installed MAMP on this iMac and the rubygems but when i run: sudo gem install mysql — –with-mysql-config=/usr/local/mysql/bin/mysql_config gives me Building native extensions. This could take a while... ERROR: Error installing mysql: ERROR: Failed to build gem native extension. /System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/bin/ruby extconf.rb mkmf.rb can't find header files for ruby at /System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/ruby.h Gem files will remain installed in /Library/Ruby/Gems/1.8/gems/mysql-2.8.1 for inspection. Results logged to /Library/Ruby/Gems/1.8/gems/mysql-2.8.1/ext/mysql_api/gem_make.out ERROR: could not find gem — locally or in a repository ERROR: could not find gem –with-mysql-config=/usr/local/mysql/bin/mysql_config locally or in a repository how can i install this gem ?

  Read the article

• Non-public application uses GPL code — are we obliged to publish our source?

  - by Cimbit

  Real Example. I have a closed source server-side program for "internal purposes only" (no distribution or selling). I want to use "MYSQL C++ Connector" in my server application in my VPS (MYSQL C++ Connector is GPL). Do I have to make my application "GPL" and distribute my source code? Can I use the GPL Source Code in my closed source application. (There is no distribution or selling of my application — it is for internal purposes only.)

  Read the article

< Previous Page | 285 286 287 288 289 290 291 292 293 294 295 296  | Next Page >