Search Results

Search found 14956 results on 599 pages for 'mysql dba'.

Page 251/599 | < Previous Page | 247 248 249 250 251 252 253 254 255 256 257 258  | Next Page >

• Using mysql i need to retrieve which are inserted last in every category.

  - by Fero

  Hi, My prob in brief: I have two tables namely category and product. table: category id category 1 cat1 2 cat2 3 cat3 4 cat4 table: product id productName category 1 test1 1 2 test2 2 3 test3 3 4 test4 4 5 test5 2 6 test6 2 My prob is: I need products which are inserted last in every category. How to solve this. thanks in advance

  Read the article

• How do you fix a MySQL "Incorrect key file" error when you can't repair the table?

  - by Wayne M

  I'm trying to run a rather large query that is supposed to run nightly to populate a table. I'm getting an error saying Incorrect key file for table '/var/tmp/#sql_201e_0.MYI'; try to repair it but the storage engine I'm using (whatever the default is, I guess?) doesn't support repairing tables. how do I fix this so I can run the query?

  Read the article

• mysql : possible to put IF statment in LEFT JOIN ?

  - by Haroldo

  Ok so i want to get an artists info from the db, but i want to know if they have any forthcoming events. To do this i need to traverse 2 tables, where events_artists is a 2 col link table... (this doesnt work but is what id like to do) SELECT art.*, events.event_id FROM art LEFT JOIN events_artists ON art.art_id = events_artists.art_id LEFT JOIN events ON events_artists.event_id = events.event_id IF ( {criteria} ) what should i be doing here to get this to work?!!

  Read the article

• Can I lock tables in an IF statement in MySQL?

  - by MalcomTucker

  This is throwing a syntax error - --from body of a stored proc IF (name = in_name) SET out_id = temp; ELSE LOCK TABLE People WRITE; INSERT INTO People (Name) VALUES (in_name); UNLOCK TABLE; SELECT LAST_INSERT_ID() INTO out_id END IF do I have to lock any tables I need at the start of the SP?

  Read the article

• MySQL ORDER BY returns things in (apparently) random order !?

  - by Luke H

  The following query: SELECT DISTINCT ClassName FROM SiteTree ORDER BY ClassName is returning things in no apparent order! I get the same result whether I quote column/table names, or use DISTINCT or not, or add ASC or DESC. I assumed the indexes might be broken, or something like this, so tried dropping and recreating. Also tried REPAIR TABLE and CHECK TABLE. The table collation is set to latin1_swedish_ci. All the textual columns are set to use UTF-8 and collation is set to utf8_general_ci What could be causing this?

  Read the article

• php mysql search in 2 columns in 2 tables.

  - by andrew fishwick

  Hey, I have two tables in one DB, one called Cottages and one called Hotels. In both tables they have the same named fields. I basically have a search bar that i want it to search in both of the fields in both of the tables. (the two fields being called "Name" and "Location" SO far I have $sql = mysql_query("SELECT * FROM Cottages WHERE Name LIKE '%$term%' or Location LIKE '%$term%' LIMIT 0, 30"); But this only searches the Cottages table, how can I make it search both the cottages and hotel tables? Andy

  Read the article

• MySQL How to select friends from a friendship table?

  - by Thomas Puthoor

  Hi I have a simple database for storing friendship, with just two columns person_a, person_b , denoting that person_a and person_b are friends. From a big list like this what query should I run to get say get all friends of 'sam'. Thank you.

  Read the article

• Why is this loop over mysql resultset slow? (1.4ms per cycle)

  - by pawpro

  The $res contains around 488k rows the whole loop takes 61s! that's over 1.25ms per cycle! What is taking all that time? while($row = $res->fetch_assoc()) { $clist[$row['upload_id']][$row['dialcode_id']][$row['carrier_id']]['std'] = $row['cost_std']; $clist[$row['upload_id']][$row['dialcode_id']][$row['carrier_id']]['ecn'] = $row['cost_ecn']; $clist[$row['upload_id']][$row['dialcode_id']][$row['carrier_id']]['wnd'] = $row['cost_wnd']; $dialcode_destination[$row['upload_id']][$row['carrier_id']][$row['dialcode_id']]['other_destination'] = $row['destination_id']; $dialcode_destination[$row['upload_id']][$row['carrier_id']][$row['dialcode_id']]['carrier_destination'] = $row['carrier_destination_id']; } Now resultset of 10 rows, smaller arrays and performance 30 times higher (0.041ms) not the fastest still but better. while($row = $res->fetch_assoc()) { $customer[$row['id']]['name'] = $row['name']; $customer[$row['id']]['code'] = $row['customer']; }

  Read the article

• Are there drawbacks to altering MySQL table data types?

  - by Tower

  Hi, I'm wondering that how much worried I should be about data types. I can easily jump from TINYINT to SMALLINT and from SMALLINT to INT, but are there any drawbacks to this? Obviously situations like from text to int will have consequences, but I'm talking about situations like INT-BIGINT, TINYTEXT-TEXT, etc.

  Read the article

• How to create time to be store as mysql TIMESTARMP type, in PHP.

  - by lovespring

  the best way, you think. thanks.

  Read the article

• Making a function for selecting from MySQL, how is mine?

  - by Doug

  This is my first time. I will appreciate any thoughts, tips, and what not. How can I improve this? Ultimately, I don't want so many selects in my script. function mysqlSelectCodes($table, $where, $order, $limit) { $sql = "SELECT * FROM $table WHERE $where ORDER BY $order LIMIT $limit" or die(mysql_error()); }

  Read the article

• mysql query to find every occurrence of a non-ascii character in a table column and replace it with

  - by Gaurav

  I have a column that contains HTML strings and has characters like ® and ™ in it. I want to replace all such characters with their HTML equivalent. Is this possible?

  Read the article

• How I can change prefixes in all tables in my MySQL DB?

  - by SkyFox

  My provider installed to my site Drupal CMS. Now I need copy all my data from old site. I have tables without prefixes in my old DB, but in new DB all tables have "dp_[table_name]" prefix.

  Read the article

• Changing the current count of an Auto Increment value in MySQL?

  - by RD

  Currently every time I add an entry to my database, the auto increment value increments by 1, as it should. However, it is only at a count of 47. So, if I add a new entry, it will be 48, and then another it will be 49 etc. I want to change what the current Auto Increment counter is at. I.e. I want to change it from 47 to say, 10000, so that the next value entered, will be 10001. How do I do that?

  Read the article

• Need to get the mysql query to show the next row every day.

  - by tom

  I've set up a query to return notes for every day. now only the first row (id=1) shows. I'd like visitors to the site to see the next row on the next day, and so forth.

  Read the article

• Retrieving last 10 row inserted in mysql table without auto increment column?

  - by Hari kanna

  Retrieving last 10 row inserted without auto increment column?

  Read the article

• how to pass int values in mysql query string?

  - by pamela

  here my code- $sqlpin = "SELECT pinId FROM tblpin WHERE pinId = '$pin_no', status = 0 "; status is int type. it is showing parse error.

  Read the article

• Which of the two ways should I use to insert tags into mysql?

  - by ggfan

  For each ad, I allow users to choose up to 5 tags. Right now, in my database, I have it like... Posting_id TagID 5 1 5 2 5 3 6 5 6 1 But i was thinking if I should make it like... Posting_id TagID 5 1 2 3 6 5 1 Then first option is much easier to insert and retrieve data. But if I have 100 posts with 3 tags each, that's 300 rows...so ALOT more rows The second option requires using explode() impode(), etc but it is much cleaner. Which option should I do and why? thanks!

  Read the article

• Mysql query to get distict hotel id with minimum price and star?

  - by user1325929

  Current table hotel_id | price | star 1100 | 1999 | 3 1100 | 1565 | 3 1100 | 2000 | 3 1101 | 2010 | 4 1101 | 2050 | 4 1102 | 5599 | 5 1102 | 6599 | 5 Required result: distinct hotels with minimum price and it's star hotel_id | price | star 1100 | 1565 | 3 1101 | 2010 | 4 1102 | 5599 | 5 I wrote query as SELECT DISTINCT hotel_id, min(price),star FROM MyTable. It is giving only 1 row instead of 3

  Read the article

• MySQL: what data type to use for hashed password field and what length?

  - by z-boss

  I'm not sure how password hashing works (will be implementing it later), but need to create database schema now. I'm thinking of limiting passwords to 4-20 characters, but as I understand after encrypting hash string will be of different length. So, how to store these passwords in the database?

  Read the article

• Will extending the size of a varchar field in MySQL affect the data thats inside it?

  - by barfoon

  I am going to be extending the column from VARCHAR(350) to VARCHAR(800) - will affect any of the strings that are inside the column already?

  Read the article

• MySQL stored procedure to INSERT DELAYED but CREATE TABLE first if needed?

  - by dkamins

  I'm planning on doing a lot of INSERT DELAYED into MyISAM tables. But the tables might not exist yet. Let's say e.g. a new table will exist for each day. So instead of detecting absence of table in my client and creating then retrying the insert, it seems like a good case for a stored procedure ("function"). Is this possible, and what would it look like? Are there any downsides to this approach?

  Read the article

• Is there any difference between SQL running in code vs the MySQL command line?

  - by MJB

  I have a SQL update statement I am running from inside a PHP program. It is prepared and then executed. When I run it in PHP, it reports a constraint violation. When I run the exact same statement from the command line (which I am getting via dBug()), it works with no errors. This sounds impossible, so I keep looking for differences between the statements. The only thing I can see is that when I execute it with an array of arguments, they all appear to be chars, when some should be integers. Any suggestions for where to look? I can post the code, but that does not seem like it would be helpful, because the code works.

  Read the article

• What obstacles and limitations will I face by choosing Linux + Mono + C# + MySQL for a web applicati

  - by z-boss

  Is this combination possible at all? If yes, will I still need to buy Visual Studio? Will I be able to use MySQLi via C#? Thank you.

  Read the article

• How do I update my primary key in MySQL?

  - by Wesley

  Ok, this is probably really simple, but I just can't figure it out. I have a primary key in a table that goes from 1-5,000. I need to manually update that id (for other table update purposes) so that it says 5,000-10,000. Can't I manually update this column? Please help!!! Thank you

  Read the article

< Previous Page | 247 248 249 250 251 252 253 254 255 256 257 258  | Next Page >