Stack Overflow
Stack Overflow

Questions tagged [mysql5]

The MySQL™ software delivers a fast, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server.

The MySQL™ software delivers a speedy, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server.

MySQL Server is intended for mission-critical, heavy-load production systems and embedding into mass-deployed software.

Active development for MySQL Database Server version 5.0 has ended. Most recent version is .

###Link The reference manual

Related tag

227 questions
0
votes
1 answer

How to select efficently random Rows from a table without a numeric primary key

What is the most efficent method to extract 1000 random rows from a table with 100.000.000 of records without a numeric primary key? Using ORDER BY RAND() is excluded because highly inefficent. Looking around the best method i found is the…
user1014351
  • 437
  • 1
  • 5
  • 16
0
votes
1 answer

Configuring MySQL5 with Hibernate 4, Spring 3, JPA 2 to have 1 exception in the end

I know it looks like this subject already exists and I actually found some topic but the answer doesn't work for me. also most of them use use the original hibernate.cfg.xml and I would like to do it using JPA2 and the persistence.xml So I start a…
js.palus
  • 83
  • 1
  • 10
0
votes
1 answer

Sql Query For my case

I Have table in format mentioned below USER_ID ORDER 1 0 1 1 1 2 1 3 2 0 2 1 2 3 3 0 3 2 I want to find list of user id whose ordering is not continious. i.e userid2(have no ordering…
Sheldon Cooper
  • 236
  • 4
  • 17
0
votes
1 answer

Query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL

I was forced to update to MySQL 5 and PHP 5 as my service provider is no longer supporting older versions. I have a working site with this MySQL search that was working fine. The following is an include placed on the user's listing page. When I take…
Steve Whitlow
  • 27
  • 2
  • 10
0
votes
2 answers

My VIEW in MySQL its not working

i play whit CREATE VIEW's in MySQL 5, now i have a troble, how can i make sure when i use this code. SELECT * FROM view_shop_invoicer_list WHERE accept_date >= '2009-10-16 00:00:00' AND accept_date <= '2009-10-31 23:59:59' AND …
ParisNakitaKejser
  • 12,112
  • 9
  • 46
  • 66
0
votes
3 answers

MySQL date_add() how to use month into this?

Hallo all, i have this SQL SELECT DATE_ADD( '2009-'+ MONTH( NOW() ) +'-01' , INTERVAL -1 MONTH ); i can't get it to work, what i make wrong here? tanks for help.
ParisNakitaKejser
  • 12,112
  • 9
  • 46
  • 66
0
votes
1 answer

MYSQL 4 password hashing -> MYSQL 5

I have a bit of a plight. My mysql 4.1.0 database has to be upgraded (1and1) but it seems the application used PASSWORD() for hashing. With the mysql 5 upgrade PASSWORD() gives an entirely different result as such the passwords can't be correctly…
jesmaestro
  • 13
  • 1
  • 5
0
votes
2 answers

Mysql time format with auto %H:%i:%s

This is my mysql query to select time from seconds. SELECT TIME_FORMAT(SEC_TO_TIME(120),'%H:%i' ) This will return as 00:02 (HOUR AND MINUTES) I need to show time hour,minutes,seconds automatically if there is a hour and there is a minute. no need…
App tester
  • 139
  • 1
  • 11
0
votes
1 answer

Mysql5 hash generator VBA

Is mysql5 algoritm is SHA-1(SHA-1($pass)) ? Then i trying this http://vb.wikia.com/wiki/SHA-1.bas script, with function =SHA1HASH(SHA1HASH("test")) i get c4033bff94b567a190e33faa551f411caef444f2 but Mysql5 hash must be…
sd vb
  • 13
  • 4
0
votes
1 answer

Mysql Grant with option to skip a db

One of my db have tables around 10000(temporary use). But what it has done that opening phpmyadmin become slow and my version is "2.6.0-pl2". Because of this version I cannot use skip_db option of phpmyadmin. So I decided to have a new user with…
Leana D cruz
  • 5
  • 3
0
votes
1 answer

How to execute select queries, while not locking update queries

I have a table on which i get heavy select queries every few seconds. Due to this, my update queries get locked for a long time. Is there any way by which I can let my select queries execute, while not locking my update queries without converting my…
user1085195
  • 365
  • 2
  • 5
  • 16
0
votes
2 answers

Finding Duplicates Of Table data : Optimized Way?

I have a main table with 80lacs record (say TABLE : MAIN_TABLE) I want to fire many queries in which i need to find all records matching approx 10 criteria that are register in 6 months(11 lacs) I have created a composite index on 2 column (col1 ,…
chicharito
  • 1,047
  • 3
  • 12
  • 41
0
votes
2 answers

PHP MySQL PDO stored procedures and INOUT parameters

I am using some stored procedures against a datastore shared by more than one application and need to call a stored procedure that has an INOUT parameter. From documentation this would work something like $prob_param = null; $stmt =…
wmarbut
  • 4,595
  • 7
  • 42
  • 72
0
votes
1 answer

Is an UPDATE still executed if a BEFORE trigger creates an error?

If no, is there any way to cancel the UPDATE from out of the trigger?
Daniel Rikowski
  • 71,375
  • 57
  • 251
  • 329
0
votes
1 answer

full text indexing only returns 2 rows

I have a table for food and hotels like CREATE TABLE `food_master` ( `id` int(6) unsigned NOT NULL auto_increment, `caption` varchar(255) default NULL, `category` varchar(10) default NULL, `subcategory` varchar(10) default NULL, `hotel`…
arjuncc
  • 3,227
  • 5
  • 42
  • 77
1 2 3
…
15 16