Search Results

Search found 20838 results on 834 pages for 'mysql num rows'.

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

• Select log lines from today in mysql

  - by ripper234

  I never remember how to do this properly - can you help me fix this query? SELECT * from log where now() - EventTime < '1 day' Note - this question seems identical but there's no solution there for mysql.

  Read the article

• MySQL Backup Procedure

  - by mouthpiec

  Is there a way to backup an MySQL database so that if something wrong occurs, it will be easy to recreate the tables with the same data?

  Read the article

• 6 digit numeric column in MySQL

  - by Vatsala

  Say I want to maintain a 6 digit ID column for a table in my database -is it possible to specify this at the DB level in MySQL?

  Read the article

• Index a mysql table of 3 integer fields

  - by Doori Bar

  I have a mysql table of 3 integer fields. None of the fields have a unique value - but the three of them combined are unique. When I query this table, I only search by the first field. Which approach is recommended for indexing such table? Having a multiple-field primary key on the 3 fields, or setting an index on the first field, which is not unique? Thanks, Doori Bar

  Read the article

• Getting MySQL code from an existing database

  - by nix

  I have a database (mdb file) that I am currently busy with. I would like to know if it is possible to generate MySQL code that would be used to create this database?

  Read the article

• mysql query fails.It gives me invalid result

  - by user2941349

  I have to write mysql query for fetching result from my database with a specified date and code like ABH18 or ABH17 or ABH19.I write the querly like below. select * from tbl_transaction where trans_name like 'ABH19%' or trans_name like 'ABH18%' or trans_name like 'ABH17%' or trans_name like 'ABH15%' and date_of_vazhipad='2013-11-20' and trans_status='Completed successfully.' There are no result in the DB satisfying all above conditions.But i got result with different dates.But i want to ensure the date_of_vazhipad='2013-11-20' so that the query may work properly Thanks in advance

  Read the article

• mysql master/slave failover

  - by myhusky

  Is there any product that make mysql master/slave failover process easier? something that can happen automatically, rather than manually fix it.

  Read the article

• MySQL 5.1 Schema Installer

  - by sergiogx

  I need to make an installer for a MySQL 5.1 Database, but I'm totally a noob when it comes to installers. I've been looking at NSIS and learned a little but I don't really know how to use it to just to execute a script. Anyone out there has experience installing database schemas in multiple computers? thanks

  Read the article

• how to number the datas from mysql

  - by udaya

  Hi This is a doubt on mysql select query let me axplain my doubt with a simple example consider this is my query SELECT dbCountry from tableCountry tableCountry has fields dbCuntryId dbCountry and dbState I have the result as dbCountry india america england kenya pakisthan I need the result as 1 india 2 america 3 england 4 kenya 5 pakisthan the numbers 12345 must be generated with the increase in data and itis not a autoincrement id How can i get it is it something like loop

  Read the article

• MySQL greatest value in row?

  - by noryb009

  Hi! I'm using MySQL with PHP. This is like my table: (I'm using 3 values, but there are more) id | 1 | 2 | 3 1 | 3 |12 |-29 2 | 5 |8 |8 3 | 99|7 |NULL I need to get the greatest value in a certain row. If should get: (id - output) (1 - 2), (2-2), (3-1). Is there any queries for this? I've been trying, but I can't get it to work right.

  Read the article

• is there mysql corelib site for building queries?

  - by mjeason

  Maybe i have the wrong context but... Is there a corelib site for mysql like http://corelib.rubyonrails.org/ for ruby on rails RoR? Would be nice to have 1 stop shop. thx.

  Read the article

• Store html into MYSql database

  - by jouzef19

  hello I'm try to store String (that contain html ) to mysql database by using Longtext data type. but its always says "You have an error in your SQL syntax". (note : i tried to store normal text , and its work)

  Read the article

• Sorting MySQL table by next due date

  - by Zagga

  Hi folks, I have a MySQL table that stores (amongst other things) a persons date of birth. Is there any way to sort the table so the next due birthday is at the top? I have the date stored in standard yyyy-mm-dd DATE format and seperate year, month and day fields so I can sort it by the first birthday of the year (ORDER BY month, day) but I can't seem to get any further. Any help would be greatly appreciated. Zagga

  Read the article

• does mysql undo changes if you kill thread?

  - by every_answer_gets_a_point

  i ran a delete rows query. it was taking too long so i killed the thread from administration. did it undo the changes to the table/?

  Read the article

• finding if an anniversary is coming up in n days in MySql

  - by user151841

  I have a table with anniversary dates. I want a query that returns me rows of anniversaries coming up in the next 10 days. For instance: birthdate --------- 1965-10-10 1982-05-25 SELECT birthdate FROM Anniversaries WHERE mystical_magical_mumbo_jumbo <= 10 +------------+ | birthdate | +------------+ | 1982-05-25 | +------------+ 1 row in set (0.01 sec) I'd like to keep the query in the form x <= 10, because I'll use that number 10 in other parts of the query, and if I set it to a variable, I can change it once everywhere by changing the variable, and not have to re-write the query.

  Read the article

• I need some advice from Experts on how to develop a PHP site with MySQL

  - by mouthpiec

  Hi, I need some advice from experts :) I will develop a website using PHP and I will use also MySQL. I bought some server space from a Virtual private server including all the service needed. How should I develop the site? Shall I develop it on my machine at home (using for example Wamp), and when ready transfer all the files to the server? If so what is the best method to transfer also the database? Thanks in advance!!

  Read the article

• Find column that contains a given value in MySQL

  - by shuby_rocks

  Hello all I have a table in a MySQL database. I am given a value that occurs as a cell value in that table but I do not know which cell is it i.e. the row and column of that cell. What is the most efficient way to find the column to which that value belongs? Thanks in advance.

  Read the article

• Sort MYSQL Data By Number of Entries

  - by Belgin Fish

  Hi, I'm wondering how I can sort mysql data based on the number of entries. I'm doing this so I can have a page of the top purchases, so it would have to retrieve all the product_id's from a table, and then sort them by the most times one shows up, limiting it to 10 or something. Thanks!

  Read the article

• Mysql select multiple colomn from non related tables

  - by Ajith

  I have two table in mysql named rootpath with only one field 'root' and savecatogory with fields brandid,categoryid,name.There is no relation between these two tables.Now how can retrieve root,brandid,categoryid using single query.Please help me.

  Read the article

• Get top rated item using AVG mysql

  - by user1876234

  I want to find top rated item using AVG function in mysql, right now my query looks like this: SELECT a.title, AVG(d.rating) as rating FROM in8ku_content a JOIN in8ku_content_ratings d ON a.id = d.article_id ORDER BY rating DESC Problem is that it takes AVG of all items and the result is not accurate, what should be changed here to get correct result ? Tables: in8ku_content [id, title] in8ku_content_ratings [id, article_id, rating]

  Read the article

• How can we detect Mysql Injection?

  - by jasmine

  A site has blocked with google. There is a site for this issue: http://25yearsofprogramming.com/blog/20070705.htm How can we detect mysql injection? Thanks in advance.

  Read the article

• How to make db structure for multiple input in MySQL and PHP

  - by bob

  Below is my current structure for MySQL database id | item_name | item_files ------------------------------------------ 1 | Item A | file1.zip,file2.zip,file3.zip 2 | Item B | file3.zip Example I create simple form to fill up Item Name and Multiple upload files then store it to db. Question :- How to design the db structure for accept the multiple files? There have a way which I don't want to use explode, implode to get the file1.zip file2.zip file3.zip

  Read the article

• Warning: mysql_query(): 3 is not a valid MySQL-Link resource

  - by Pieter

  I got this odd error and I can't figure out where it came from: Warning: mysql_query(): 3 is not a valid MySQL-Link resource in (...) What's up with the 3? I don't get it. Has anyone experienced this error themselves?

  Read the article

• summing the sum in mysql

  - by JPro

  Hi, Say If I get a resultset in mysql as : ID count(posts) 101 2344 102 3245 103 232 104 23 Is there any way to get the tota count of count(posts) in the query itself, like this? ID count(posts) 101 2344 102 3245 103 232 104 23 ------ 5844

  Read the article

• mySQL convert varchar to date

  - by Jeff V

  I need to convert a varchar value of 1/9/2011 to a date in mySQL and I want only the month and year. So that I can then use the PERIOD_DIFF function (so I would need the above to be converted to 201101). I've tried various ways using the STR_TO_DATE function: SELECT STR_TO_DATE(CYOApp_oilChangedDate, '%m/%Y') FROM CYO_AppInfo But I get weird results... (for example: 2009-01-00) What am I doing incorrectly?

  Read the article

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