Search Results

Search found 14874 results on 595 pages for 'mysql connector'.

Page 113/595 | < Previous Page | 109 110 111 112 113 114 115 116 117 118 119 120  | Next Page >

• convert date string to mysql datetime field

  - by mjr

  I have a bunch of records with dates formatted as a string such as '04/17/2009' I want to convert them to a mysql datetime field I plan to use a foreach loop to read the old date value and insert the newly formatted value into a new field in each record what would be the best way to convert that string...I thought php might have a way to do it automatically? thanks

  Read the article

• How to change date formate in mysql stored procedure insert statemant "22-12-2010" to "2010-12-22"

  - by Ayyappan.Anbalagan

  I send the registration date parameter to mysql database like "22-12-2010". But my sql date date type is in another formate how can i change the date formate like "2010-12-22" also i have to insert this into table. Give code in c#,asp.net code behind either sql query statement! Cheerss!!!!! **Thanks A.Ayyappan**

  Read the article

• mysql composite unique on FK's

  - by m2o

  I want to implement the following constraints in mysql: create table TypeMapping( ... constraint unique(server_id,type_id), constraint foreign key(server_id) references Server(id), constraint foreign key(type_id) references Type(id) ); This throws a 'ERROR 1062 (23000): Duplicate entry '3-4' for key 'server_id'' when I issue an insert/update that would break the constraint. Is this type of constraint even possible? If so how? Thank you.

  Read the article

• Fastest way to check array items existence in mySQL table

  - by Enrique

  User writes a series of tags (, separated) and posts the form. I build an array containing the tags and delete dupes with array_unique() php function. I'm thinking of doing: go through the array with foreach($newarray as $item) { ... } check each $item for existence in the tags mySQL table if item does not exists, insert into tags table Is there a FASTER or MORE OPTIMUM way for doing this?

  Read the article

• SQL Server query replace for MySQL Instruction

  - by pojomx

  Hi, I'm new to SQL Server, and used mysql for a while now... SELECT A.acol, IF(A.acol<0,"Neg","Pos") as Column2 From Table I want to do something like that on SQL Server, but there doesn't exist the IF instruction. How do I replace that if, in a SQL Server 2008 Query?

  Read the article

• Which global variable of mysql are equivalent of Sql Server

  - by Shantanu Gupta

  I am looking for few global variable in mysql which are equivalent of sql server. I want the whole list eg. Sql Server Equivalent @@error --- @@Identity --- etc. Basically right now I want to know what are the equivalent variable of @@error and @@identity. But it will be helpfull if u could provide some other variable also

  Read the article

• Export unicode data from mysql

  - by Nayn

  Hi Folks, I have some data in one of my mysql table stored as utf8. The data is some japanese text. I need to export it to excel. Could you tell how to do it? Exporting by SELECT ... INTO OUTFILE returns some plain text file. I'm not sure how to read it back in excel so that japanese character would show properly Thanks Nayn

  Read the article

• Search MySQL Database

  - by McCrum

  Hey, I have put together an iPhone web app and i'm currently reading and displaying data from a MySQL database. I have added a search bar to this page and was wondering what the best way would be to search the content on the page. http://j.mp/c6lV8c

  Read the article

• MySQL Select names with last names starting with certain letter

  - by Brian

  I have a MySQL database with a field Name which contains full names. To select all people with last names starting with a particular letter, let's say A for this example, I use the following query: SELECT * FROM db WHERE Name LIKE '% A%'. However, this also selects users who have a middle name starting with A. Is there anyway to alter this query so that only a last name starting in A will be selected?

  Read the article

• Large PHP arrays or MySQL temporary memory tables?

  - by Mads Jensen

  How would you temporarily store several thousands key => value or key => array pairs within a single process. Lookups on key will be done continuously within the process, and the data is discarded when the process ends. Should i use arrays? temporary MySQL tables? Or something in between?

  Read the article

• mysql db image convert to file

  - by ntan

  Hi i am writing a converter from Oracle to mysql In Oracle the images are stored in db. I want to read the content of the image and save to file system I suppose that i have to read the blob entry and using php file commands create the file (am i right) What about image type. Should i save as jpg (what if the store image is not jpg) Any suggestion are welcome

  Read the article

• Upload Excel or CSV file to MySQL with PHP

  - by Tony

  I'm looking to allow users to upload an Excel or CSV file to MySQL for a contact management system. Need to be able to allow users to map their columns so that they are imported into the correct column in the table. Anyone know of a good site or tutorial on this?

  Read the article

• MySql query taking too long - django on webfaction

  - by fallhunter

  I use django on webfaction, and I've got a "MySql query taking too long" message, the sql is SELECT (1) AS `a` FROM `main_userprofile` WHERE `main_userprofile`.`id` = 98 This is a rather simple sql, why the query taken too long?

  Read the article

• Coldfusion 8 access to MySQL database without datasource

  - by proyb2

  My webhosting doesn't allow us to access and modify the datasource, but having CF8, anyone have done access to mysql before? Do I need to use PHP?

  Read the article

• Remote MySQL in AIR

  - by YourComputerHelpZ

  I use Aptana Studio 2.0 to create an Adobe AIR 2.0 webapplication. I have to contact my MySQL database from my server to be able to use my application. I tried, but it failed. Does AIR have these abilities anyways, and how? If not, what are the alternatives?

  Read the article

• mysql5.58 unstart server in mac os 10.6.5

  - by EdwardLau

  MySQL 5.5.8 uninstall MAC OS 10.6.5,restart computer is message “/Library/StartupItems/MySQLCOM” has not been started because it does not have the proper security settings. i set sudo /Applications/TextEdit.app/Contents/MacOS/TextEdit /usr/local/mysql/support-files/mysql.server Locate the configuration defining the basedir and set the following : basedir=/usr/local/mysql datadir=/usr/local/mysql/data bug i click the mysql preference start mysql server isn't start and i sudo chown -R root:wheel /Library/StartupItems/MySQLCOM and restart again ,not warning message but mysql server not start ,why?

  Read the article

• SubSonic template with MySQL

  - by jstevenson86

  When I run the custom tool to create the cs files for SubSonic all the templates now inject a letter g to the top of the cs files. To get this to compile I need to remove the g from the ActiveRecord.cs, Struts.cs, Context.cs and StoredProcedures.cs. Anyone else run into this? I am using MySQL.

  Read the article

• How to insert Search Query into MYSQL - Check for Double Words

  - by elmaso

  Hi, what is the best method to insert a search query into MySql and check for double words? (for showing up the last searches and a collection of searches)

  Read the article

• can we use join inside join in mysql?

  - by I Like PHP

  i have 3 tables structure is below tbl_login login_id | login_name 1 | keshav tbl_role role_id | login_id( refer to tbl_login.login_id) 1 | 1 tbl_stuff stuff_id | role_id( refer to tbl_role.role_id) 1 | 1 i need data in follow format stuff_id | login_name 1 | keshav how to use JOIN to retrive the above data in mysql?

  Read the article

• MySQL - query to return CSV in a field?

  - by StackOverflowNewbie

  Assume I have the following tables: TABLE: foo - foo_id (PK) TABLE: tag - tag_id (PK) - name TABLE: foo_tag - foo_tag_id (PK) - foo_id (FK) - tag_id (FK) How do I query this so that I get a result like this: ========================== | foo_id | tags | ========================== | 1 | foo, bar | | 2 | foo | | 3 | bar | -------------------------- Basically, I need all of foo's tags in one column, comma separated. Possible in MySQL?

  Read the article

• minus value in mysql table not worked

  - by Richa Media and services

  in my mysql table i want to use minus value. if i do 0 -1 = -1 but he work as 0 -1 = 2147483647 what i do for it.

  Read the article

• PHP code to convert a MySQL query to CSV

  - by Reilly

  What is the most efficient way to convert a MySQL query to CSV in PHP please? It would be best to avoid temp files as this reduces portability (dir paths and setting file-system permissions required). The CSV should also include one top line of field names. Cheers.

  Read the article

• ADO.NET Data Services for MySQL

  - by Shalan

  Hey! I've searched high and low for this, and no luck. Is there a way that CRUD methods for a MySQL install (Linux box) be exposed via ADO.NET WCF Data Services? I would really love to leverage this in my WPF app :) Thank u!

  Read the article

• Start for mysql Query PHP

  - by Belgin Fish

  Hi, I'm currently looking to have a mysql query retrieve data and have and a start and limit. So like, select * from table where x = x START AT ID X LIMIT X thanks :)

  Read the article

• Log all queries in mysql

  - by public static

  Hi, Is it possible for me to turn on audit logging on my mysql database? I basically want to monitor all queries for an hour, and dump the log to a file.

  Read the article

< Previous Page | 109 110 111 112 113 114 115 116 117 118 119 120  | Next Page >