Search Results

Search found 14142 results on 566 pages for 'mysql workbench'.

Page 294/566 | < Previous Page | 290 291 292 293 294 295 296 297 298 299 300 301  | Next Page >

• Can php query the results from a previous query?

  - by eaolson

  In some languages (ColdFusion comes to mind), you can run a query on the result set from a previous query. Is it possible to do something like that in php (with MySQL as the database)? I sort of want to do: $rs1 = do_query( "SELECT * FROM animals WHERE type = 'fish'" ); $rs2 = do_query( "SELECT * FROM rs1 WHERE name = 'trout'" );

  Read the article

• Is there a way to figure out which web page is associated with which query?

  - by GregoryD

  I'm running a LAMP stack. When I go into phpmyadmin, I can see that there are quite a number of sleeping connections which probably should be closed. Is there a way, using either Apache or MySQL, to determine on which pages those connections are created?

  Read the article

• UPLOAD DATA IN DATA BASE

  - by rajson

  HI friends, i wish to store image and resume of user in the data base. i am using mysql data base and php5. i want to know that which field i set means data type.and how i set the range (maximum size) for uploaded data.

  Read the article

• Porting from MS Access

  - by lacqui

  I've recently been given a MS Access .mdb database file and asked to make it usable in a Linux system. What I'm looking for is a way to convert the Access database to an open-source database such as MySQL or PostGres. I don't have MS Office, and it's a one-time project for a volunteer organization so I don't want to spend money if it's avoidable. I'm running Vista x64, and have a Linux virtualbox, so something usable in either one will be good.

  Read the article

• System date capturing in to data base

  - by user335103

  i create a registration form in my jsp project.mysql be the database.i want to insert system date automatically in datebase in the registration time.

  Read the article

• Data pagination with "saved" search

  - by TiuTalk

  I'm creating a page that's a search result... When you're viewing one of the results, at the bottom of the page, I need to insert "Next result" and "Previous result" links, like a pagination... But from [I think] a saved search, right? How you people would do this? Obs.: I'll use CakePHP (PHP) and MySQL

  Read the article

• When using SELECT can you modify the value of a returned field based on other fields?

  - by user570759

  When using MySQL SELECT can you change the value of a returned field based on other fields? For example, if I have this select: SELECT city,state,country FROM table Now if city is empty AND state is empty, I want the value of country to returned empty as well (whether country actually has a value or not). Example table: id | city | state | country ----------------------------- 1 | Here | There | MyCountry 2 | | | YourCountry So with the above table, I want the results for id=1 to return Here,There,MyCountry but the results for id=2 should be empty,empty,empty Thanks

  Read the article

• Calculating average (AVG) and grouping by week on large data set takes too long

  - by caioiglesias

  I'm getting average prices by week on 7 million rows, it's taking around 30 seconds to get the job done. This is the simple query: SELECT AVG(price) as price, yearWEEK(FROM_UNIXTIME(timelog)) as week from pricehistory where timelog > $range and product_id = $id GROUP BY week The only week that actually gets data changed and is worth averaging every time is always the last one, so this calculation for the whole period is a waste of resources. I just wanted to know if mysql has a tool to help out on this.

  Read the article

• Problem in importing the CSV file containing multiple commas in a sigle field

  - by kakaajee

  Hi Experts, I am having an issue with importing a large(60MB) CSV file in MYSQL DB. The problem arises when an address field has multiple comma seperated values e.g. home no, street no, town etc. I tried to use BigDump for it but, the problem did not solved because of a single field containing multiple comma separated values. Any idea, suggestion or solution from experts how to handle it? Please reply, because I am sick of it. Thanks

  Read the article

• What is wrong with this SQL syntax?

  - by Finbarr

  UPDATE files SET filepath = REPLACE(filepath, `sites/somedomain.com/files/`, `sites/someotherdomain.com/files/`); I have a table called files with a field called filepath. MySQL returns this error: Unknown column 'sites/somedomain.com/files/' in 'field list'

  Read the article

• mysqldump problem with case sensitivity? Win->linux

  - by acidzombie24

  When i dump a table with uppercase letters using mysqldump it comes out as lower case in my dump.sql file. I found a report here in 2006, almost 4 years old http://bugs.mysql.com/bug.php?id=19967 A solution here suggest making linux insensitive. I rather not if possible. Whats the easiest way to copy a win32 db into linux?

  Read the article

• WHERE condition accross multiple rows

  - by Chris G

  I have this table... -------------------------------------- | user_id | status | status_date | -------------------------------------- | 1 | Current | 2012-08-01 | | 1 | Referral | 2012-03-14 | | 2 | Referral | 2012-04-23 | | | | | -------------------------------------- How would I query to find a distinct user_id who has a referral date before 2012-06-30 AND either a current date of after 2012-06-30 or no current status record at all? Database is MySQL.

  Read the article

• Error with characters in a html iframe

  - by dinero beta

  excuse my English I speak Spanish I'm trying to display multiple php and mysql registration, after that the show in an iframe the problem is that apparently in the iframe shows me errors accents and other characters for example: for example (?D?nde cuesta menos y se consume m?s?") this is what shows (?) In the original query or first does not show me that, but in the iframe shows me that error and probe with http-equiv = "content-type" and I worked What else I can do? What should I do? regards

  Read the article

• Maximum number of records in a database table

  - by pepernik

  What is the upper limit of records for MySQL database table. I'm wondering about autoincrement field. What would happen if I add milions of records? How to handle this kind of situations? Thx!

  Read the article

• Select number of rows in all tables in the database

  - by Alex N.

  I wonder if this is possible with straight SQL on MySQL. I need to do SELECT COUNT(*) FROM on each table in the database and output results in one result set. Is it possible to do with just SQL?

  Read the article

• My team member not supporting to use Crystal report in asp.net web application.

  - by Ayyappan.Anbalagan

  My team member not supporting to use Crystal report in asp.net web application. specially Crystal report with mysql database. Is there any other report available?

  Read the article

• Autopruning after a specified amount of row are created?

  - by Rob

  Basic question, sorry. Basically, I have a script that creates a MySQL entry each time someone visits the page. A logging script. However, I want to make it autoprune after, say, 100 visits. For example in pseudo code: if amount of rows > 100 { delete rows 1+ until amount of rows == 100 } So in a nutshell, each time a new row is added after 100, it needs to automatically remove the row with the smallest id (My primary key).

  Read the article

• Get insert statement query

  - by Karthick

  Hi, Is there a way to get the insert statements for a table via some query in MySql? for ex: if the table name is Cards,which has 5 rows, i need to get the insert statements for that particular table. Thanks.

  Read the article

• Is there anyway to change the database server without stopping the database?

  - by Tattat

  I have a database in data center, which is running MySQL, and I want to change the database from data center to host in my company. At that time, I don't want to stop the data base in the data center, is there anyway to this kind of integeration? Thank you...

  Read the article

• SQL select from last inserted

  - by arik-so

  Hello, in MySQL, I have table. One column has auto-increment. When I insert something mysql_query('INSERT INTO `table` SET `column` = "data";'); Now, what I want is, without further queries, to get the value of the auto-incrementing column, maybe like this: mysql_query('insertion = (INSERT INTO `table` SET `column` = "data"); SELECT `auto_incrementing_column` FROM `table`.insertion'); Please tell me how something like that is done. Thanks in advance!

  Read the article

• How Assigning query return value to local a variable, and how to use that in where condition?

  - by Ayyappan.Anbalagan

  I am using mysql stored procedure; I need to assign query retuned value to local variable. And i have to check the condition using the local variable..... or It my query Select Meterial_Id from hemaepdb.transaction where CustId=1; Instead of Meterial_Id i need to get the Meterial_name from Material table.....

  Read the article

• How to check how many characters in variable, and add space between characters in that var?

  - by Camran

  I have a 'price' variable that contains some integer number from a MySQL database. I want to check how many numbers the 'price' variable contains, and add a space in the variable depending on how many numbers. See below: Example: If 'price' is 150000 I would like the output to be 150 000 (notice the space). OR, if it is 19000 I would like it to output 19 000... How would you do this the easiest way?

  Read the article

• In 64 bit systems, a 32 bit column occupies less space than a 64 bit one?

  - by estourodepilha.com

  In MySQL running on a 64bit OS, every column occupies at least 64 bits? A bit would occupy a whole byte? or a whole word?

  Read the article

• give preference to print array values in php

  - by Bharanikumar

  Hi , I have country table, i fetch all values and moved into array , these value i like to populate into combo/dropdown list , here i want to do some magic things, that is , for my site most of the users coming from uk,us,Australia,Romain and few, So i like to populate by my preference , is there any array will do this magic work, else is it possible mysql query , So final question is , Populate country name into combo based on my prefernce , Thanks

  Read the article

• what does select @@identity do?

  - by every_answer_gets_a_point

  i am connecting to a mysql database through excel using odbc what does this line do? Set rs = oConn.Execute("SELECT @@identity", , adCmdText) i am having trouble updating the database: With rs .AddNew ' create a new record ' add values to each field in the record .Fields("datapath") = dpath .Fields("analysistime") = atime .Fields("reporttime") = rtime .Fields("lastcalib") = lcalib .Fields("analystname") = aname .Fields("reportname") = rname .Fields("batchstate") = "bstate" .Fields("instrument") = "NA" .Update ' stores the new record End With it is ONLY updating .Fields("instrument") = "NA", but for all other fields it is putting NULL values

  Read the article

< Previous Page | 290 291 292 293 294 295 296 297 298 299 300 301  | Next Page >