Search Results

Search found 34274 results on 1371 pages for 'mysql table'.

Page 109/1371 | < Previous Page | 105 106 107 108 109 110 111 112 113 114 115 116  | Next Page >

• SQLite table does not exist exception for existing SQLite database (and table)

  - by SK9

  I've followed the instructions given here for introducing an existing SQLite database to your Android app. When I query the table "android_metadata" this is fine. But when I run a similar query on my own table "words" (which has _id for primary integer key) I get a table does not exist exception and the app crashes. Why is that? Code: Cursor c…

  Read the article

• create dump file from database in mysql

  - by chetan

  following is the that I create dump from mysql database. mysql -u root tempbkk ttt.dump but I want to create a dump that exclude one or more file while creating dump from database we select.What is the command for that ?

  Read the article

• MYSQL: Checking datafile being used from the command line

  - by ming yeow

  i am having trouble configuring mysql database to connect to the right file. I do not know which datafile is being used (due to some pretty tricky EC2 related moving around), My question is: from the command line, how do i see what datafile is being used by the mysql database?

  Read the article

• mysql error using Rails-- Please help

  - by Cypher

  Alright I am sry for the noob question but this has been driving me up a wall-especially because I got it to work yesterday and I can't remember what I did.... I am just trying to use mysql with rails with a mongrel server. I set up the server fine and can run rails applications that don't need mysql but when I create a project using (for…

  Read the article

• Delphi - MySQL Best Data aware components to use

  - by Brad

  I need my applicaiton to connect to my web server's MySQL database, what is the best option for this. Perfered Data aware Component. I tried zeos 7, but I keep getting the error: SQL error: Client does not support authentication protocal requested by server; consider upgrading MySQL client and have not been able to fix it. Thanks -Brad

  Read the article

• "'assert’ was not declared in this scope" in MySQL++

  - by Anonymous

  I'm compiling a project in XCode where MySQL++ in included and linked to. For some reason, I keep getting the following compiler error: 'assert’ was not declared in this scope originating from cpool.h, a header file that's part of MySQL++. Does anyone know why this is being triggered?

  Read the article

• MySQL: Will a column-oriented engine be available in MySQL 5.5?

  - by JakiT

  Will a column-oriented storage engine (e.g. InfiniDB) be available in the core release of MySQL 5.5? Meaning, not as a plugin but available with the core MySQL 5.5 bundle.

  Read the article

• Zend Server with xampp MySQL

  - by Vincent

  I am running Zend Server,Zend Studio (Trial versions) on Ubuntu 9.10. I am also using xampp to do most of my development. I plan to use Zend Server only to do URL profiling to know function level performance of my code. Is it possible to configure Zend Server to use XAMPP's MySQL database instead of installing a new mysql instance for Zend…

  Read the article

• Using preg_replace in mysql

  - by Roshan

  I have a CMS content in database. The content contains '<img src= .............../>' also. I want to retrieve this content using mysql query and show on frontend but with all '<img src='.........../>' removed from the content. How can it be done using query in mysql?

  Read the article

• Can we use JCR API over MySQL?

  - by n_mysql

  Apache Jackrabbit (or the JCR API) helps you separate the data store from the data management system. This would mean that every data store provider would have to implement the JCR API for his own data store. The question is JCR implemented for MySQL? Can we use the JCR API over MySQL? I want to truly abstract out where i store my content,…

  Read the article

• How to use Common Table Expression and check no duplication in SQL Server

  - by vodkhang

  I have a table references to itself. User table: id, username, managerid and managerid links back to id Now, I want to get all the managers including direct manager, manager of direct manager, so on and so forth... The problem is that I do not want to have a unstop recursive sql. So, I want to check if an id alreay in a list, I will…

  Read the article

• GRANT with database name wildcard in MySQL?

  - by JR Lawhorne

  I want to create a user 'projectA' that has the same permissions to every database named 'projectA_%' I know its possible but MySQL doesn't like my syntax: grant all on 'projectA_%'.* to 'projectA'@'%'; Reference: http://dev.mysql.com/doc/refman/5.1/en/grant.html

  Read the article

• Configure options MySQL server was compiled with?? [closed]

  - by GetFree

  I have MySQL server 5.0.67 running on a Linux machine. How can I know what configure options were used to compile it?? I'm interested in the option --with-mysqld-ldflags in order to know whether mysql was linked statically or dynamically. Thanks.

  Read the article

• mysql and linq support

  - by darko petreski

  Hi All, I have read in many forums that there is no good linq for mysql (free) but his forums are 2 years old. In the meantime is there any good free linq for mysql ? Hog good is for professional use? Regards

  Read the article

• How to deinstall mysql?

  - by Kovu

  Hi, I sit on this problem ~5 hours: I try to install php and mysql on my iis7 machine. After install mysql, I can't connect, PW error (Im sure its not btw). I try to deinstall but after a new install, the database is the same. System is Windows Server Standart SP2 (I don't know hich Windows Server is it, its the only information I…

  Read the article

• where has sun mysql database manager gone???

  - by opensas

  If I recall correctly, there where at least to desktop programas from sun which were very useful for handling mysql databases... Now, all I can find is some mysql workbench which is only useful for designing data... Both programs I'm talking about allowed you to manage servers, create database, create tables, index, perform querys,…

  Read the article

• "select * from table" vs "select colA,colB,etc from table" interesting behaviour in SqlServer2005

  - by kristof

  Apology for a lengthy post but I needed to post some code to illustrate the problem. Inspired by the question What is the reason not to use select * ? posted a few minutes ago, I decided to point out some observations of the select * behaviour that I noticed some time ago. So let's the code speak for itself: IF EXISTS (SELECT *…

  Read the article

• MYSQL - datetime to seconds

  - by Mike

  Hello, I wasn't able to find out (googling, reading mysql reference manual) how to get value of DATETIME in seconds in MySQL. I dont mean to extract seconds from datetime, but to convert it into seconds. Thanx

  Read the article

• Pulling data and printing it in an HTML table

  - by John

  Hello, From a MySQL table called "submission" containing the fields "loginid, submissionid, title, url, datesubmitted, displayurl", I would like to print an HTML table thats contains all "title" and corresponding "datesubmitted" where "loginid" equals "$profile." The code I am trying to use is below. It isn't working. Any ideas…

  Read the article

• Tuning MySQL to take advantage of a 4GB VPS

  - by alistair.mp

  Hello, We're running a large site at the moment which has a dedicated VPS for it's database server which is running MySQL and nothing else. At the moment all four CPU cores are running at close to 100% all of the time but the memory usage sticks at around 268MB out of an available 4096MB. I'm wondering what we can do to better…

  Read the article

• Is there any performance difference between Debug and Release?

  - by Lazlo

  I'm using MySql Connector .NET to load an account and transfer it to the client. This operation is rather intensive, considering the child elements of the account to load. In Debug mode, it takes, at most, 1 second to load the account. The average would be 500ms. In Release mode, it takes from 1 to 4 seconds to load the…

  Read the article

• Books for experienced .NET developer learning PHP/MySQL

  - by webworm

  Hi All, I am an experienced .NET developer (C#/ASP.NET) looking to broaden my skills to the PHP/MySQL arena. I would like get recommendations on books for learning PHP/MySQL that are geared towards someone who is already familiar with object oriented programming and web development. I do realize that there are lots of…

  Read the article

• Log MySQL Query In Kohana 3

  - by Asif

  Hi All, I am using Kohana 3. I want to log the MySQL queries being executed by an application. The reason to determine the query of type INSERT,UPDATE and DELETE which are being executed in a process and store them in another MySQL table with date-time for further reference. Can anybody tell how can I achieve this?

  Read the article

• php warning mysql_fetch_assoc

  - by death the kid

  I am trying to access some information from mysql, but am getting the warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource for the second line of code below, any help would be much appreciated. $musicfiles=getmusicfiles($records['m_id']); $mus=mysql_fetch_assoc($musicfiles);…

  Read the article

• MySQL InnoDB insertion is very slow

  - by dharmapurikar

  We use MySQL server 5.1.43 64-bit edition. InnoDB is used as engine. We have a sql script which we execute every time we build the application. On ubuntu machine with MySQL server and InnoDB engine it takes about 55 seconds to complete the execution. If I run the same script on OSX, it takes close to 3…

  Read the article

< Previous Page | 105 106 107 108 109 110 111 112 113 114 115 116  | Next Page >