Search Results

Search found 14956 results on 599 pages for 'mysql dba'.

Page 112/599 | < Previous Page | 108 109 110 111 112 113 114 115 116 117 118 119  | Next Page >

• Importing json data into MySQL?

  - by AP257

  Pretty much what the title says :) At the moment I'm using Python to turn the json data into a plain-text tab-separated file, and then mysqlimport to pull that into my MySQL tables. Anyone know a nicer / more direct way?

  Read the article

• How to search a 'near word' in MySQL?

  - by Trez

  For example, i want to search a word 'marple', this should return row with near or exact word like 'marble','maple','marple', etc... How to do it in mysql query? or better give word suggestion if any? Thanks,

  Read the article

• How to store Richtextbox Foramtted COntents in MYSql DB ' Direclty ' using VB.Net

  - by Priya

  I have one Field in MYSQL DB. Name is ' Field1 '. I can store the Richtextbox text(it contains Bold, Italic, Etc). using the code ' Richtextbox1.rtf ' But when i am trying to display using 'Richtextbox1.rtf=dt.rows(0).item(0).tostring ', It shows 'File Format is not Valid '. What is the Solution.

  Read the article

• Automatic MySQL Database backup and email through cPanel cron

  - by Shishant

  Hello, Can anybody help how to setup a automatic backup of mysql database and then emailing it to me daily? Thank You.

  Read the article

• normalize mysql tutorial please...

  - by Camran

  Is there a good guide for normalizing a mysql db? I have only knowledge about phpmyadmin... Thanks

  Read the article

• Get nested/hierarchical JSON from MySQL/PHP

  - by brz dot net

  I am using spacetree chart and I require JSON in hierarchical format. See sample required JSON format here. I have ID,ParentID,Name,Description fields in Mysql database table. Now How can I convert data in Hierarchical/nested JSON using PHP?

  Read the article

• detecting locked tables mysql (locked by LOCK TABLE)

  - by Marcin

  Hi guys, I would like to know whether is there an option to detect locked tables in mysql or no. I mean locked by LOCK TABLE table WRITE/READ command ? cheers, Marcin

  Read the article

• Insert a bunch of duplicate rows into a mysql table

  - by incrediman

  I need to insert 50 rows into a mysql table. They should all be exactly identical, besides the primary key. Is there a query that can do this?

  Read the article

• parse results in MySQL via REGEX

  - by Derek Adair

  Hi, I'm a bit confused on the functionality of the REGEX support for MySQL and I have yet to find a solid example on how to separate a result with REGEX within an sql statement. Example: How could I pull data from a table emails that looks something like... +-------------------------+ |Emails | |-------------------------| |[email protected]| +-------------------------+ and return something through an sql statement that looks like... +------------------------------+ |Username | Domain | TLD | |-----------|------------|-----| |some.email | yourdomain | com | +------------------------------+

  Read the article

• Need to replace HTML single-quote entity in MySQL

  - by modulaaron

  Hi, I currently have the following MySQL statement to replace the HTML entity for a single quote with an actual single quote: update photo_galleries replace(title, '&#39;', '\''); This statement returns an error. I have tried adding additional backslashes, but this does not help at all. I want to run this command using pure SQL (no PHP, etc.). Any suggestions are welcome and appreciated. Thanks.

  Read the article

• can we use something IN and something NOT in mysql

  - by JPro

  I want to know if I can use something like this : If yes, then what will be order ? I dont seem to understand quite well the explain plan of mysql Select * from results where TestCase NOT IN (select TestCase from results where Verdict <> 'PASS' and StartTime > DATE_SUB(NOW(), INTERVAL 2 MONTHS)) and TestCase IN (Select TestCase from testcases where Type = 'NONOS') EDIT : Also how can I order by StartTime to display the latest first?

  Read the article

• Error querying database in PHP, MySQL

  - by user296516

  Hi guys, I have this code in PHP. It connects to the DB fine, but pops an error, when tryinto to insert the info. $dbc = mysqli_connect('localhost', 'root', 'marina', 'aliendatabase') or die('Error connecting to MySQL server.'); $query = "INSERT INTO aliens_abduction (name, email) VALUSE ('John', '[email protected]')"; $result = mysqli_query($dbc, $query) or die('Error querying database.'); mysqli_close($dbc); Here's a screenshot: http://img532.imageshack.us/img532/2930/63306356.jpg Thanks, R

  Read the article

• select similar values from mysql database

  - by mathew

  Hi I have several data s in MySQL database. In my table there is a column called rank. what I want is when some one enter a rank say 25 then the result should display names on similar(+ or -) ranks LIMIT to 10 from table. example mathew - 25 john - 26 joe - 25 stewart - 27 kelly - 24 brandon -23 magy - 22 .......etc. Thanks Mathew

  Read the article

• Better PHP,MySql,HTML and JavaScript IDE

  - by War Coder

  Hello guys, I am currently using the below IDE's. They serve their purposes but am wondering if there are better ones out there that i can switch to. phpDesigner v6.2.5 (For PHP) Navicat 8.0.29 (For MySql) Dreamweaver CS3 (For HTML & CSS) Spket IDE (For JavaScript) Thats my collection of production tools. Wondering if there is anyone of them i can switch to a better one. Thanks

  Read the article

• MDB2, Pear, Mysql error

  - by Kyle Hudson

  Hi Guys, I have PEAR, MDB2 and Mysql Driver installed however I keep getting: Fatal error: Call to undefined function: MDB2_Driver_mysql::_isNewLinkSet(). in /home/**/PEAR/MDB2.php on line 1937. The Server is CentOS I am stuck, any help would be appriciated. Thanks :)

  Read the article

• php,mysql and Zend lucene

  - by Anil

  how to index mysql table and search using zend lucene? Pls provide with code and posible with table structure... thanking all...

  Read the article

• mysql innodb max size of transaction

  - by chris

  Using mysql 5.1.41 and innodb I'm doing some data import, but can't use load data infile, so I'm manually issuing insert statements. I found that it's much faster to disable auto commit and issue say, 100 insert statements and then commit, instead of the implicit commit after each insert. It got me thinking, what limits are there to how much data I can put into a transaction? Is there a limit on the number of statements, or does it have to do with the size in bytes etc...?

  Read the article

• A MySQL schema parser in Java?

  - by Richard

  Hi all, Does anyone know whether there is a java library for parsing a MySQL schema? In code I want to be able to determine the tables and fields specified in a schema. Or am I going to have to write my own? Thanks Richard.

  Read the article

• Fail2Ban - Log to mysql

  - by user319660

  Hi! We have a few servers with SSH public (using sFTP). Obviously, the attacks ar too many. We want put the banned logs into a MySQL DB for make stats and etc. Have anyone tryied this? Thanks

  Read the article

• simpledb, sql azure, mysql + memcached

  - by sirmak

  For a new scalable high traffic global ecommerce website (asp.net) project which technology fits best (max. scalability & performance, min. price & maintenance)? amazon simpledb, microsoft sql azure, mysql + memcached combo, or your solution...

  Read the article

• MySQL: SSH Connection through Terminal in MAC

  - by RedEye

  Hi Thanks for reading my question. I currently use Mac Terminal to use MySQL. I connect to either localhost or a remote server. Should I be using SSH?

  Read the article

• mysql query - blog posts and comments with limit

  - by Lemon

  Hi, I have 2 tables: comments and posts and I'd like to display a list of 15 posts and maximum 2 most recent comments under each blog post the database scheme looks like this posts_table: post_id, post_txt, post_timestamp comments_table: post_id, comment_txt, comment_timestamp how the mysql query should look like to select 15 posts and related comments (max 2 most recent ones per post) ??? thanks, Leo

  Read the article

• Required help to Increase the performance of the MySQL query

  - by Joseph

  Hi all, I am using a following query in MySQl for fetching data from a table. Its taking too long because the conditional check within the aggregate function.Please help how to make it faster SELECT testcharfield ,SUM(IF (Type = 'pi',quantity, 0)) AS OB ,SUM(IF (Type = 'pe',quantity, 0)) AS CB FROM Table1 WHERE sequenceID = 6107 GROUP BY testcharfield

  Read the article

• MYSQL in PHPMYADMIN - create table relationship from one table

  - by Stanley DecoWood

  I want to create a table relationship with MYSQL PHPMYADMIN. I have this Create table: CREATE TABLE students(code_students int(8)not null AUTO_INCREMENT, name_students varchar(25), age_students int(3), degree_program varchar(25), code_advisor int(8)not null, primary key(code_students, code_advisor) ); and i want to make a create table named advise relationship between code_students, code_advisor.

  Read the article

• MySQL high IO usage quries

  - by jack

  MySQL has a built-in slow query logger. Is there any options or third-party tools which are able to detect the queries causing high IO usage just in the way like what slow query logger does?

  Read the article

< Previous Page | 108 109 110 111 112 113 114 115 116 117 118 119  | Next Page >