Search Results

Search found 63884 results on 2556 pages for 'mysql error 1064'.

Page 132/2556 | < Previous Page | 128 129 130 131 132 133 134 135 136 137 138 139  | Next Page >

• MySQL auto increments disappeared

  - by Lizard

  I have a mysql database with 60 tables most of the tables have primary keys (expect pivot tables) all these primary keys had the attribute AUTO INCREMENT Then over night some how all the primary keys had that attribute removed, and the default value set to 0. I have no idea how this may have been caused. Any suggestions?

  Read the article

• Load data infile in a stored procedure- MySQL

  - by Pankaj

  Is there any way, i can use 'Load data infile' in a stored procedure. I am using mysql. LOAD DATA LOCAL INFILE 'C:\\MyData.txt' INTO TABLE tempprod fields terminated by ',' lines terminated by '\r\n'; SELECT * FROM product p;

  Read the article

• Restoring MySQL database from physical files

  - by Abdullah Jibaly

  Is it possible to restore a MySQL database from the physical database files. I have a directory that has the following file types: client.frm client.MYD client.MYI but for about 20 more tables. I usually use mysqldump or a similar tool to get everything in 1 SQL file so what is the way to deal with these types of files?

  Read the article

• mysql connector/net ssl shutsdown the server

  - by Simon

  Hello, when I try to connect my server throw connector/net using ssl with pfx certificate I had problem with establishing the connection. I get connection timeout. And the server probably fall down (I dont know it for sure, becouse I dont manage the server). On the Windows XP works all right, but on Windows 7 dont. Please, where is problem? In Windows 7 or on the server (mysql 5.0)? Sometimes I get "Calling interface SSPI Failed" error, but not everytime. Sometimes is only connection timeout error. Thank you a lot for any help. Regards, simon

  Read the article

• How to increase mysql table comments length?

  - by opensas

  Seems like max table comments length in mysql is only 60 characters. I'm developing an aplicacion in php symfony, which automatically generates sql ddl sentences, and in many cases those comments are far beyond 60 characters. Is there some way to increase that limit? thanks a lot

  Read the article

• how to store "2010-03-26 10:13:04 Etc/GMT" mysql?

  - by kkchaitu

  Hi All, I would like to store "2010-03-26 10:13:04 Etc/GMT" value in column of type datetime. when i try to insert it i got exception SQLException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '10:13:04 Etc/GMT', at line 1 how to insert data time with time zone. Thanks in advance. please help me its urgent.

  Read the article

• 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

• 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

• Prepared Statements in MySql 5.1

  - by Ronen

  This one is really puzzling. I can't seem to be able to run any prepared statement on MySql 5.1. Any simple select I'm writing runs fine but when I'm trying to run it from a prepared statement I'm getting Query returned no result set. What Am I doing wrong? Exmaple: prepare s from 'select * from t'; execute s; Thanks!

  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

• Syntax error, unexpected T_CONSTANT_ENCAPSED_STRING in PHP

  - by pmms

  mysql_connect("localhost","root",""); mysql_select_db("hitnrunf_db"); $result=mysql_query("select * from jos_users INTO OUTFILE 'users.csv' FIELDS ESCAPED BY '""' TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' "); header("Content-type: text/plain"); header("Content-Disposition: attachment; filename=your_desired_name.xls"); header("Content-Transfer-Encoding: binary"); header("Pragma: no-cache"); header("Expires: 0"); print "$header\n$data"; in the above code in query string i.e string in side mysql_quey we are getting following error Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING in C:\wamp\www\samples\mysql_excel\exel_outfile.php on line 8 in query string '\n' charter is not identifying as string thats why above error getting

  Read the article

• ALTER TABLE error

  - by Travis

  Can someone explain to me why I am receiving the following error? I want to rename the column "exerciseID" to "ID" in a mysql table using the following syntax. ALTER TABLE `exercises` CHANGE `exerciseID` `ID` INT( 11 ) NOT NULL AUTO_INCREMENT However I receive the following error: MySQL said: #1025 - Error on rename of './balance/#sql-de_110e' to './balance/exercises' (errno: 150) Any suggestions would be much appreciated

  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

• 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 Text Storage?

  - by mii

  I was wondering if you where to have an article or articles with huge amounts of text, what would be better when creating the database structure for the articles text? And why? What will be the advantages or disadvantages if any?. I was thinking of using one of the data types below to hold the articles text for the MySQL database. VARCHAR TEXT MEDIUMTEXT LONGTEXT

  Read the article

• MySQL query String contains

  - by arik-so

  Hello. This may sound easy, but I've been trying - in vain, apparently - to figure out how I can make a query with MySQL that checks if the value (string $haystack ;) ) in a certain column contains certain data ( $needle ;) ), like this: mysql_query(" SELECT * FROM `table` WHERE `column`.contains('{$needle}') "); In PHP, the function is called substr($haystack, $needle), so maybe: WHERE substr(`column`, '{$needle}')=1 Thanks in advance!

  Read the article

• Error querying database.

  - by user296516

  Hi, Once I have successfully connected to the database, i have a line that must insert values. mysqli_query($edb, "INSERT INTO elvis_table (name,email) VALUES ('$name','$email')" ) or die('Error querying database.'); It works fine on my computer ( xampp ), but once I upload it onto a server, it starts giving an error. Yes, I have a database with a corresponding table and fields on a server, it connects to the database fine, but gives an error on this line... Thanks!

  Read the article

• mysql count query

  - by S.PRATHIBA

  Hi all, i have the following table: mysql select * from consumer1; Service_ID | Service_Type | consumer_feedback 31 Printer -1 34 Printer 0 31 Printer 0 34 Printer 1 34 Printer 1 34 Printer 1 34 Printer 1 34 Printer 1 34 Printer 1 34 Printer 1 34 Printer 1 34 Printer 1 34 Printer 1 34 Printer 1 34 Printer 1 34 Printer 1 34 Printer 1 34 Printer 1 34 Printer 1 34 Printer 1 I need a query such that I need THE COUNT(Service_ID)=2 AS Service_ID is 31 and 34.Please help me and give me some suggestions.

  Read the article

• MySQL :- select by month

  - by Pankaj

  how can i get record from table using month/year? I have a table like Project Name - varchar DueDate -datetime Status -boll DueDate is project due date, i want record corresponding to month/year,not full date, i mean record for specific month. How can i do this 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

• MySQL best usage in Tomcat?

  - by mabuzer

  Which one is better way of using MySQL in Tomcat : A) assign a DB connection for user as long as it's session is valid. [OR] B) open connection to DB, on every request come to server and when it's done close that. ?

  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

• 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

• PHP MYSQL Endless Loop

  - by Neb

  Hi, I have a problem with my php/mysql script. It should only output the while loop once but I am getting unlimited loops and an endless page. $query = mysql_query("SELECT * FROM users WHERE username ='".base64_encode($_SESSION['username'])."' LIMIT 1"); $result = mysql_fetch_array($query); if(empty($result)){ echo "No user... Error"; }else{ while($row = $result){ ?> <a href="index.php?user=<?=$row['id']?>"><?=base64_decode($row['username'])?></a> | <a href="javascript:void(0);" id="logout">Logout</a> <?php } } I have tried a similar script with these same lines and it works perfectly $result = mysql_fetch_array($query); if(empty($result)){ echo "No user... Error"; }else{ while($row = $result){ //Something } }

  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

< Previous Page | 128 129 130 131 132 133 134 135 136 137 138 139  | Next Page >