How to put MySQL code into source control?
- by Jader Dias
I know I can copy all my MySQL code manually to files and then put those files into source control. But is there any way to do this automatically?
Search Results
Search found 14956 results on 599 pages for 'mysql dba'.
Page 126/599 | < Previous Page | 122 123 124 125 126 127 128 129 130 131 132 133 | Next Page >
-
-
MySQL: how to index an "OR" clause
- by JoséMi
I'm executing the following query SELECT COUNT(*) FROM table WHERE field1='value' AND (field2 = 1000 OR field3 = 2000) There is one index over field1 and another composited over field2&field3. I see MySQL always selects the field1 index and then makes a join using the other two fields which is quite bad because it needs to join 146.000 rows. Suggestions on how to improve this? ThanksRead 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
-
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
-
Checking if mysql user exists
- by sergiogx
How can I check if a user exists? Im doing an installer for a mysql database, and I need to check if a user exits, if not create user, if yes delete user and create it again. this so i can execute the script without worries. thanks.Read the article
-
Mysql - NOW() function calling
- by Ockonal
Hello, I'm using php for making queries for mysql. Here is one: UPDATE `subscribers` SET `curDate` = NOW() WHERE `e_mail` = "$resEmail" curDate - DateTime type. The problem is that after this query curDate of given email is 0000-00-00 00:00:00 What's wrong?Read the article
-
Easy mysql question regarding primary keys and an insert
- by MPX
In mysql, how do I get the primary key used for an insert operation, when it is autoincrementing. Basically, i want the new autoincremented value to be returned when the statement completes. Thanks!Read the article
-
Convert a mysql date (datetime) into a better date format using php
- by dave e
I some php code which gets info from a mysql database. The problem is that the date is coming out in the format : 2010-02-03 22:21:26 Does anyone know a simple solution to make the date more user friendly format. e.g 2nd march 2010 at 22:21. ThanksRead the article
-
How to simulate "MYSQL has gone away" error?
- by Lost_in_code
I'm running lots of cron job and once in a while there is a MYSQL has gone away error. I've now written some code to handle the error, but how do I simulate the error on my localhost so that the code can be tested thoroughly?Read the article
-
How do I prevent sql injection with php and mysql
- by herrturtur
I have a form into which the visitor can enter data, and I want to store this data in a mysql database via the $_POST variable. What do I need to prevent sql injection?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
-
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
-
Best way to fetch last 4 rows from a result set using mysql
- by PHP-Prabhu
Can any one please let me know, that, i need to fetch last 4 rows from a result-set using mysql. The result-set returns totally 6 records. but, i need the records to be fetch from last4...i.e, Record-3 Record-4 Record-5 Record-6Read 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
-
migrate a portion of a mysql table to SQLite
- by daniel
I have a mysql table set up like so: user_id | document 44 [blob] 44 [blob] 44 [blob] 46 [blob] I'd like to export all of user_id 44's data to an SQLite3 file. Best way to go about this without writing a script that reads the data and dumps it into a SQLite file?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
-
Accessing Mysql with JQuery without using php
- by user326175
Hi, I'm very new to JQuery, but I was told the one of the cool things about it is you can query a mysql database right from an html page(or in my case a smarty template)with out needing php. I have not found any examples of this so I am asking if someone has one? ThanksRead the article
-
MySQL: SUM in WHERE clause
- by checcco
Hi guys, I've got this table CREATE TABLE `subevents` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(150) DEFAULT NULL, `content` text, `class` tinyint(4) NOT NULL DEFAULT '1', PRIMARY KEY (`id`) ) ENGINE=MyISAM Each row can have a different value in the 'class' field. I'd like to select any number of rows, ordered randomly, as long as the sum of the values in the 'class' field is equal to 100. How could I accomplish it directly in the MySQL query without doing it later in PHP? Thanks everybody!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
-
store Current Date & time in MySql Using ASP.net
- by Khilen
I want to store the current date & time which can be get by System.DateTime.Now in asp.net but while storing in Mysql it gives Error of Invalid Time.Read the article
-
Mysql Trigger to select and delete
- by Karthick
Hi, Is this possible, can a trigger in mysql can do a select first and then based on its result do a delete?, both on the same table. Am struggling to get it right. There are duplicate entries in a table, i need to have a trigger which selects and then deletes. Any ideas or thoughts will be really helpful.Read the article
-
Getting rows which include a value with MySQL
- by sundowatch
I have a MySQL query which gets including some vars like that: messages TABLE receiver cols user1 rows : 1,3,5 user2 rows : 2,3 user3 rows : 1,4 I want to get rows which includes '3' value. So I will get 'user1' and 'user2'. I tried that but naturally it doesn't work. mysql_query("SELECT * FROM messages WHERE receiver='3'"); How can I do this?Read the article
-
MySQL select/where statement
- by expo101
I have a webapplication linked to a mysql database with the following fields: field 1:trip_id field 2:trip_destination field 3:trip_description field 4:trip_duration In the webapplication I have a listbox based on the following: ListBox value =1: trip duration 1 - 5 days ListBox value =2: trip duration 6 - 10 days Listbox value =3: trip duration 11 -20 days ListBox value =4: trip duration over 20 days How do I put this in the sql select statement?Read the article
-
MySQL - What is the correct primary key method
- by Hammerstein
I'm starting to develop an application using MySQL and although I've developed apps before using databases, I've normally gone to the incrementing id method. The other day I was reading a posting somewhere and saw someone being picked apart for this, for not properly "normalising the database". I'm not a big database person, but I wanted to make sure I'm doing this right. Any ideas, help / guidance?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
