Search Results

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

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

• INNER JOIN syntax for mySQL using phpmyadmin

  - by David van Dugteren

  SELECT Question.userid, user.uid FROM `question` WHERE NOT `userid`=2 LIMIT 0, 60 INNER JOIN `user` ON `question`.userid=`user`.uid ORDER BY `question`.userid returns Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INNER JOIN User ON question.userid=user.uid ORDER BY question.userid' at line 5 Can't for the life of me figure out what I'm doing wrong here.

  Read the article

• the Memory problem about MySQL "SELECT *"

  - by Austin Huang

  Dear all: I'm new to MySQL, and I have a question about the memory. I have a 200mb table(MyISAM, 2,000,000 rows), and I try to load all of it to the memory. I use python(actually MySQLdb in python) with sql: SELECT * FROM table. However, from my linux "top" I saw this python process uses 50% of my memory(which is total 6GB) I'm curious about why it uses about 3GB memory only for a 200 mb table. Thanks in advance!

  Read the article

• MySql, InnoDB & Null Values

  - by pws5068

  Formerly I was using MyISAM storage engine for MySql and I had defined the combination of three fields to be unique. Now I have switched to InnoDB, which I assume caused this problem, and now NULL != NULL. So for the following table: ID (Auto) | Field_A | Field_B | Field_C I can insert (Field_A,Field_B,Field_C) Values(1,2,NULL) (1,2,NULL) (1,2,NULL) infinitely many times. How can I prevent this behavior?

  Read the article

• Fill CSS box with text from MySQL till there is no overflow, scrollbar, or hidden text

  - by terrance branigan

  I want to fill a CSS box with text till there is no overflow or scrollbar. I fetch text from MySQL. The user clicks a button and the next bit of text that can fit will fill the box. The only way I've figured to do this is by parsing through the text and counting characters and newlines, etc and calculating whether it will fit in the box. Is there an easier way to do this? Thank you

  Read the article

• Fail to install mysql on cygwin, No curses/termcap library found

  - by ty

  Fail to install mysql on cygwin. When do ./configure, experienced following error: checking for termcap functions library... configure: error: No curses/termcap library found any idea?

  Read the article

• how to get mysql query as xml?

  - by mobibob

  I recall reading about XML support from MySql. Does anyone know how to get XML without writing code? My client-protocol expects XML and I have a data source that I can access from a web app (JSP using JDBC).

  Read the article

• Receives System.Byte[] in GridView when MySql's DateFormat Function is used

  - by Khilen

  I have written this query for retrieving data from mysql as below select FeedbackCode,EMailID,FeedbackDetail, Date_Format(FeedbackDate,'%m,%d') as 'Feedback_Date' from FeedbackDetail where EMailID not like '' and InstanceCode =5 and I'm binding this data with GridView in asp.net but at the column of Feedback_Date, instead of Date I receive System.Byte[].

  Read the article

• MySQL 6.0 Release Date?

  - by GregH

  Any idea when MySQL 6.0 Release Date might be? Nothing specific, more like "second half of 2010" works.

  Read the article

• Listing both null and not null in mysql query

  - by tomasz

  Let's say I have the table NAME | ID | REF foo1 | 1 | NULL foo2 | 2 | 1234 foo2 | 3 | 567 foo1 | 4 | NULL foo3 | 5 | 89 I'd like to count all instances of NULL and NOT NULL in one query so that I can say NAME | null | not null foo1 | 0 | 2 foo2 | 2 | 0 foo3 | 0 | 1 I could run these two queries select NAME,count(*) from TABLE where REF is not null select NAME,count(*) from TABLE where REF is null But I'm sure there must be a simple way to do it in one mysql query.

  Read the article

• use result set of mysql stored procedure in another stored procedure

  - by hmak

  I have a MYSQL stored procedure SP1() that returns a result set. I want to call SP1() inside of SP2() and loop through the result set of SP1() to do some additional work. I don't want to include my logic from SP1() because it would make SP2() too complicated. Any suggestions? Thanks.

  Read the article

• Mysql query are case sensitive?

  - by wezzy

  When i set lower_case_table_names = 1 in mysql i know that it converts every table name to lowecase so "myCoolLowerCaseName" becomes "mycoollowercasename". But the question is: queries with camelcase name works ? with a table called mycoollowercasename the query:SELECT * FROM myCoolLowerCaseName works? Thanks

  Read the article

• MySQL id sequence

  - by Michal Fronczyk

  Is this a correct way for id generation in MySQL ? INSERT INTO Picture (PictureId,First_pick,Title,Description,File_Name,Is_Vertical)VALUES ((SELECT max(pictureid)+1 FROM Picture),0,?,?,?,?) I mean if it is guaranted that PictureId will be unique when this query is run by many threads ? I can't modify table structure. Should I use any specific locks, index or transaction isolation level ? Regards, Michal

  Read the article

• Need free English dictionary or Corpus, ultimately for a MySQL database

  - by Chris

  Hey there, I'm trying to find a free downloadable dictionary (or Corpus might be the better word) which I can import into MySQL. I need to words to have the type (noun, verb, adjective) associated with them. Any tips on where I can find one? I found one several years ago that worked nicely, but I no longer have it around. Thanks! Chris

  Read the article

• MySQL UTC Date format

  - by Btibert3

  Hi everyone, I am pulling data from Twitter's api and the return date is UTC in the following form: Sat Jan 24 22:14:29 +0000 2009 Can MySQL handle this format specifically or do I need to transform it? I am pulling the data using Python. Thanks, Brock

  Read the article

• Convert MYSQL Timestamp to time_t

  - by Kewley

  I'm writing a multi-threaded program that needs to be able to check if a row requires updating and act accordingly. I had problems using the built in date/time functions of MySql and so decided to just store the "lastupdate" timestamp as an integer in the table. However, I'm having problems converting this timestamp to time_t so that I can use the time functions with it. Any help is greatly appreciated.

  Read the article

• Migrating .NET/MySQL app. to DB2

  - by RPK

  I want to migrate my existing desktop Windows .NET 3.5 app. that uses MySQL as backend to DB2 Express C. I downloaded IBM Migration Toolkit to migrate the database. I have further queries: How accurate is IBM Migration Toolkit? Are there any issues? For the application, just changing the connection string will do or something else?

  Read the article

• Determine which table takes most disk space in MySQL

  - by astropanic

  What is the easiest way to determine which table takes most disk space ? A handicap: I have no MySQL server, only the file with all data (dump.sql)

  Read the article

• MySQL Query Help, including a count?

  - by nobosh

  Any ideas why this isn't working in MySQL? SELECT blogentry.*, person.personName, (SELECT * FROM BlogEntryComment Where BlogEntryID = '8') as CommentCount FROM blogentry INNER JOIN person ON blogentry.personID = person.personID WHERE blogentry.deleted = 'N' ORDER BY blogentry.dateAdded DESC

  Read the article

• Date problem in MYSQL Query

  - by davykiash

  Am looking for a query to sum values in a particular time duration say an year or a particular month in an year using MYSQL syntax.Note that my transaction_date column stores daily amount transacted. Am example of a query that returns total sales in an year query would look something like this SELECT SUM(transaction_amount) WHERE transaction_date = (YEAR) Am example of a query that returns total sales in an particular month and year would look something like this SELECT SUM(transaction_amount) WHERE transaction_date = (YEAR)(MONTH) How achievable is this?

  Read the article

• How can I make tables in MySQL?

  - by Sergio Tapia

  I have two distinct scenarios. One, where there is a many to many case, you must create a third table. But I'm not familiar with MySQL syntaxis. Two, is this one: How can I declare using SQL code?

  Read the article

• inserting data into mysql

  - by francesco

  Hi Guys, My insert and update pages (through my admin forlder) into mysql stopped working. When I try to insert/update details it stays on the same page without adding or updating anything into the database table. I really don't know what happened and don't know where start looking. I didn't make any change to the pages whatsoever. Is there anyone who had the same problem and can kindly give me a clue? Appreciated Francesco

  Read the article

• Optimize mysql table ?

  - by fabien-barbier

  Here is my actual table schema (I'm using Mysql) : Table experiment : code(int) sample_1_id sample_2_id ... until ... sample_12_id rna_1_id rna_2_id ... until ... rna_12_id experiment_start How can I optimize both part : sample_n_id and rna_n_id (all are bigint(20) and allow null=true) ? About values : we can have : ex : sample_1_id = 2 , Sample_2_id = 5 , ... Note : values can be updated. Ideas ? Thanks.

  Read the article

• error in mysql syntax

  - by fusion

  while executing the following query, i get an error that there's an error in the syntax near line 9. since i'm using mysql workbench, i can't really figure out what could be wrong: CREATE TABLE IF NOT EXISTS `proquotes`.`thquotes` ( `idQuotes` INT NOT NULL AUTO_INCREMENT , `vAuthorID` VARCHAR(8) CHARACTER SET 'utf8' NOT NULL , `vAuthor` VARCHAR(45) CHARACTER SET 'utf8' NOT NULL , `cQuotes` MEDIUMTEXT CHARACTER SET 'utf8' NOT NULL , `cArabic` MEDIUMTEXT CHARACTER SET 'utf8' NOT NULL , `vReference` VARCHAR(100) CHARACTER SET 'utf8' NOT NULL , PRIMARY KEY (`idQuotes`) , INDEX `vAuthorID` () , CONSTRAINT `vAuthorID` FOREIGN KEY () REFERENCES `proquotes`.`author_info` () ON DELETE NO ACTION ON UPDATE NO ACTION) DEFAULT CHARACTER SET = utf8;

  Read the article

• what is the purpose of this mysql query ?

  - by Harbhag

  SELECT id, CONCAT(lastname,', ',firstname) AS fullname, lastname, firstname FROM " . TABLE_CONTACT . " WHERE CONCAT(firstname,' ', lastname) LIKE '%$goTo%' OR CONCAT(firstname,' ', middlename,' ', lastname) LIKE '%$goTo%' OR nickname LIKE '%$goTo%' ORDER BY fullname"; Can anyone please tell me what is purpose of above query ? I am new to mysql so unable to understand it. Thanks

  Read the article

• Why MAMP sets to 600 MySQL file permission?

  - by SergioP

  I usually put MAMP MySQL /db/db-site-name folder under SVN. When MAMP starts, it gives the drw------- (600) permission to all the files and dir in that folder. I have a problem because one of these folder is .svn one, that have to be drwxr-xr-x (755), otherwise I can't access to SVN working copy with my client. Can anyone help me to set MAMP properly?

  Read the article

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