Search Results

Search found 23821 results on 953 pages for 'mysql group by'.

Page 138/953 | < Previous Page | 134 135 136 137 138 139 140 141 142 143 144 145  | Next Page >

• have mysql select statement return fully qualified column names like table.field

  - by handsomeGun

  is there a way to have a mysql select statement return fully qualified column names like "table.field" without using AS for every single field? like so: SELECT * FROM table1 LEFT JOIN table2 on table1.f_ID = table2.ID and the result would be: "table1.ID", "table1.name", "table2.ID", "table2.name", ...

  Read the article

• How do you debug MySQL stored procedures?

  - by Cory House

  My current process for debugging stored procedures is very simple. I create a table called "debug" where I insert variable values from the stored procedure as it runs. This allows me to see the value of any variable at a given point in the script, but is this is there a better way to debug MySQL stored procedures?

  Read the article

• MySQL LINES TERMINATED BY

  - by Brian

  What are the potential choises for LINES TERMINATED BY in MySQL. I have a CSV file that I am trying to upload and neither \r\n, \n, not \r work.

  Read the article

• seperated mysql statement query in php

  - by stone

  So, I can run the following statements from within mysql itself successfully. SET @fname = 'point1'; SELECT * FROM country WHERE name=@fname;` But when I try to pass the query through php like this and run it, I get an error on the second line $query = "SET @fname = 'point1';"; $query .= "SELECT * FROM country WHERE name=@fname;";

  Read the article

• PHP and MySQL search with extra counts along the way

  - by Barry Connolly

  I am building a PHP and MySQL search as so SELECT * FROM Properties WHERE Locaion = 'Liverpool' I want to count how many of each property type there are and display them at the side of the page to use as filters (like Rightmove.co.uk). This is what I am have come up with but can't get it to work SELECT *, count(PropertyType = 'house') AS HouesTotal, count(PropertyType = 'Apartment') AS ApartmentTotal FROM Properties WHERE Location = 'Liverpool' Can anyone help?

  Read the article

• MySQL Order by ASC almost 20 times slower than DESC [closed]

  - by Salman Akram

  Possible Duplicate: MySQL ORDER BY DESC is fast but ASC is very slow Order by DESC is super fast and Order by ASC takes almost 20 times more time. How could it be caused and how could it be solved?

  Read the article

• how to activate trigger after all the bulk insert(s) in mysql

  - by JPro

  I am using mysql and there are bulk inserts that goes on to my table. My doubt is if I create a trigger specifying after insert, then the trigger will get activated for every insert after, which I do not want to happen. Is there any way to activate a trigger after all the bulk inserts are completed? Any advice? Thanks.

  Read the article

• Storing MySQL GUID/UUIDs

  - by thr

  This is the best way I could come up with to convert a MySQL GUID/UUID generated by UUID() to a binary(16): UNHEX(REPLACE(UUID(),'-','')) And then storing it in a BINARY(16) Are there any implications of doing it this way that I should know of?

  Read the article

• What Mysql query will return this result?

  - by Lost_in_code

  I have two tables A,B which are related to each other (simplified): A: +-------+---------+ | id | type | +-------+---------+ | 1 | apple | | 2 | orange | | 3 | banana | +-------+---------+ B: +-------+---------+-----------+ | id | a_id | rank | +-------+---------+-----------+ | 1 | 1 | 0.0 | | 2 | 1 | 7.7 | | 3 | 2 | 3.3 | | 4 | 2 | 8.8 | | 5 | 2 | 1.1 | | 6 | 3 | 3.3 | | 7 | 3 | 5.5 | | 8 | 1 | 9.5 | +-------+---------+-----------+ What mysql query will return the following result? Result +-------+---------+-----------+ | id | type | rank | +-------+---------+-----------+ | 1 | apple | 9.5 | | 2 | orange | 1.1 | | 3 | banana | 5.5 | +-------+---------+-----------+

  Read the article

• PHP & MySQL question user submitted data?

  - by comma

  I was wondering how can I allow users to enter HTML and CSS to the there profiles safely using PHP and MySQL like they do on MySpace.

  Read the article

• Mysql query for within a specific date

  - by Ajith

  I need to retrieve data from within a specific date range.Anybody can help me to create a query to getting the information within date range 12-12-2009 to 12-15-2009 from a mysql table.(including 12 and 15)

  Read the article

• MySQL: Digits (1.75) to Friendly Time (1 hour and 45 minutes)

  - by Nick

  In my MySQL database, I have a float field named "HoursSpent" with values like "0.25", "1.75", "2.5", etc. Is there a way that I can have my SELECT statement format those values in a friendly format like this?: 0.25 = 15 minutes 1.75 = 1 hour and 45 minutes 2.5 = 2 hours and 30 minutes The "HoursSpent" field is supposed to only have values in 0.25 increments, but if somebody were to put something random like 0.16, it would be nice if the SELECT statement handled that by rounding it up to the nearest 0.25 (so in this case 0.16 would become 0.25, or 15 minutes).

  Read the article

• mysql :ordering table with day names

  - by Meko

  Hi.I am trying to get day of names with and correct order like Monday ,Tuesday.. But in my table I have records that after Monday comes Friday or I have Thursday between two Tuesday .I want to order them like Monday ,Monday ,Tuesday ,Tuesday, Wednesday so on .But I don`t want to group them. I used this query but it does not make order select Day_Name from mydb.schedule where Room_NO=(510) And Week_NO =(1) it outputs Monday Monday Tuesday Wednesday Wednesday Tuesday Thursday Thursday Thursday how can I correct it?

  Read the article

• binlog_format = STATEMENT and CURRENT_TIMESTAMP with MySQL replication

  - by xma

  Hi, can a MySQL slave instance have different row values for the same ID when binlog_format is set to STATEMENT and we insert something like: insert into foo values(CURRENT_TIMESTAMP) As I understand it, the slave read the SQL statement and execute it thus, if the replication is lagging, could lead to differences for the same row. Right or wrong ? How can I avoid this situation ? Thank you.

  Read the article

• Connecting VB.NET to a MySQL Database

  - by Bubby4j

  I have a VB.NET application and I need it to be able to display rows from a MySQL database. How would I do this?

  Read the article

• MySQL 5 left join unknown column

  - by NP

  I had the below query working in mysql 4.1, but does not in 5.0: SELECT * FROM email e, event_email ee LEFT JOIN member m on m.email=e.email WHERE ee.email_id = e.email_id The error: 1054 (Unknown column 'e.email' in 'on clause')

  Read the article

• Primary key in MySQL: INT(n) or UUID as varchar(36)

  - by SODA

  Does it make sense to use UUID as primary key in MySQL? What would be pros and cons of using UUID instead of regular INT, beside trouble of hand querying?

  Read the article

• How to validate a single checkbox using PHP & MySQL

  - by BeepU

  I was wondering how can I validate a single checkbox using PHP and MySQL. Here is the HTML. <input type="checkbox" name="privacy_policy" id="privacy_policy" value="yes" />

  Read the article

• mysql join table - selecting the newest row

  - by cmancre

  Hi, I have the following two MySQL tables TABLE NAMES NAME_ID NAME 1 name1 2 name2 3 name3 TABLE STATUS STATUS_ID NAME_ID TIMESTAMP 1 1 2010-12-20 12:00 2 2 2010-12-20 10:00 3 3 2010-12-20 10:30 4 3 2010-12-20 14:00 I would like to select all info from table NAMES and add most recent correspondent TIMESTAMP column from table STATUS RESULT NAME_ID NAME TIMESTAMP 1 name1 2010-12-20 12:00 2 name2 2010-12-20 10:00 3 name3 2010-12-20 14:00 Am stuck on this one. How do I left join only on the newer timestamp?

  Read the article

• Scanning a mysql table from the bottom

  - by ming yeow

  When i run a mysql select statement, it takes very long because i have already previously deleted a very large number of rows. Is there a way for the table to start scanning from the bottom, as opposed to from the top?

  Read the article

• Conditional sorting in MySQL?

  - by serg555

  I have "tasks" table with 3 fields: date priority (0,1,2) done (0,1) What I am trying to achieve is with the whole table sorted by done flag, tasks that are not done should be sorted by priority, while tasks that are done should be sorted by date: Select * from tasks order by done asc If done=0 additionally order by priority desc If done=1 additionally order by date desc Is it possible to do this in MySQL without unions? Thanks.

  Read the article

• Efficiently store last X items in an MySQL Database

  - by Saif Bechan

  I want to store the last 3 items in an MySQL database in an efficient way. So when the 4th item is stored the first should be deleted. The way I do this not is first run a query getting the items. Than check what I should do then insert/delete. There has to be a better way to do this. Any suggestions?

  Read the article

• How to store data which contains quotes in MySQL

  - by Nitz

  In one of my forms I use the rich text editor from Yahoo!. Now i want to store the data from that textarea in a MySQL database. The user can enter anything in that textarea, e.g. many double or single quotes. How can I store that data? Normally we store by adding that data in one variable and then put that in sql, but the quotes cause problems.

  Read the article

• mysql procedure call in codeigniter

  - by ASD

  Any simple example of mysql stored procedure and example to show how to call that procedure from codeigniter php. Any help?

  Read the article

• Set given time to 00:00:00 in PHP/MySQL

  - by hypnocode

  Hi, I'm retrieving a date from a MySQL database that shows up like this: '2010-03-09 09:11:30' How can I change the date to '2010-03-09 00:00:00'? I'm using PHP to perform the query. Thanks!

  Read the article

< Previous Page | 134 135 136 137 138 139 140 141 142 143 144 145  | Next Page >