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
2 answers

logging into sql

I am a student learning sql and working an assignment to set up a database in mySQL 5.5 community version. The command I am given does not work as detailed. Here is what I have done so far: This is the command that I am told to use after setting up…
1RacerTn
  • 63
  • 1
  • 8
0
votes
1 answer

How can I get mysql to use indexes with a simple AND + OR query?

This is using MySQL 5.5. I cannot seem to convince MySQL to use indexes for these queries and they are taking anywhere from 2-10 seconds to run on a table with 1.1 million rows. Table: CREATE TABLE `notifiable_events` ( `id` int(10) unsigned NOT…
Aaron Zeckoski
  • 5,016
  • 8
  • 25
  • 48
0
votes
2 answers

Mysql tables into one table

CREATE TABLE emp_u ( id INT NOT NULL AUTO_INCREMENT, emailAddress VARCHAR(100) NOT NULL, username VARCHAR(30) NOT NULL, passwd VARCHAR(40) NOT NULL, title CHAR(4) NOT NULL, …
user1509201
  • 99
  • 1
  • 3
  • 8
0
votes
0 answers

Error occurs with while Loop PHP / MySQL NuSOAP

I have created a PHP / MySQL based web service. I wrote client.php as mentioned here and server.php as below:
Prash278
  • 59
  • 1
  • 6
0
votes
3 answers

MySQL specify every column in query rather than using SELECT *

Possible Duplicate: Which is faster/best? SELECT * or SELECT column1, colum2, column3, etc I recall reading a number of years ago that in the scenario where you wanted to select everything from a MySQL table it was more efficient and better…
crmpicco
  • 16,605
  • 26
  • 134
  • 210
0
votes
3 answers

mysql query showing 9 results

i have a problem. I'm running following query. I have only one record in my database but i'm getting 9 results. SELECT c.id, c.rk FROM cv AS c, employee AS e , cvCat AS cv_cat WHERE c.status=1 AND c.empIDFK = e.id AND cv_cat.categoryFK…
Lalajee
  • 139
  • 1
  • 9
0
votes
2 answers

Can you check to see if there will be any results

I'm displaying Spotlight post on search page. When a user enters a keyword to search for a post I like to bring a Spotlight post using that keyword. If there is no post with that keyword then I would want to just bring any Spotlight post from…
Lalajee
  • 139
  • 1
  • 9
0
votes
4 answers

Mysql - joins - too many rows are being returned - one for each of the joined table but dont want that

I have this kind of mysql db (table name/fields) tbl_users: id, title, approved tbl_photos: id, user_id, title, filename I have one row in users, and three photos (all with user_id = the id of the user) doing this: select tbl_users.*,…
user1190646
-1
votes
2 answers

how to simplify this sql

I have a problem in my sql expression, I want to put different columns in a main select,these different columns has the same where clause. Here is my sql example: SELECT t.*, (SELECT monitor_value FROM sub_message s WHERE…
Dodge_X
  • 37
  • 8
-1
votes
4 answers

Mysql Query On Joins

I have two tables Table1 SNO RECEIVER USER1 USER2 1 133 44 45 2 144 66 77 3 155 77 33 AND TABLE 2 RECEIVER USER 133 44 133 45 144 88 144 55 …
Shakini
  • 3
  • 3
-1
votes
1 answer

Error 1064(42000) Creating a Table in msql5

CREATE TABLE Message( MessageID int unsigned not null auto_increment primary key, naiveUserID int unsigned(7) NOT NULL, Title varchar(20), bodyOfText TEXT(2000) ); I keep trying to run this simple create table blurb on a Mysql5…
user3020163
  • 13
  • 3
-1
votes
1 answer

mysql select user who have not posted on site

I would like to select users who have not posted a job. I have tried this: SELECT e.id, e.companyName, ee.emailAddress, ee.firstName, ee.surname FROM employer as e, country as country, employerUser as ee , countryRegion as re, job as j…
user1509201
  • 99
  • 1
  • 3
  • 8
-1
votes
4 answers

Determining which users uploaded an image?

I have a database of users that I have allowed to upload their images to their profiles. There is no indication in the database that each has uploaded an image to their profile and that is exactly what I need to know. Is there any way that I could…
Lovelady09
  • 9
-2
votes
1 answer

MySQL Leaderboard Table

I'm trying to figure out how to Select a specific number of rows from a MySQL table based on WHERE clause. I have a table with 10 dummy users, I want to get 2 previous and 2 next users of specific user with their ranks. user_id | …
Muhammad Talha
  • 165
  • 1
  • 8
-2
votes
3 answers

MySQL ORDER BY field with a toggle

I have a mysql result that looks like this: | compare | field1 | field2 | much more | ----------------------------------------- | new | x1 | y | ... | | old | x1 | y | ... | | old | x2 | y | ... …
Paladin
  • 1,637
  • 13
  • 28
1 2 3
…
15
16