Search Results

Search found 18606 results on 745 pages for 'mysql comments'.

Page 128/745 | < Previous Page | 124 125 126 127 128 129 130 131 132 133 134 135  | Next Page >

• PHP+MySQL Update TimeStamp and get NOW() back

  - by Ben

  Is it possible to merge these two mysql queries into one? I want to get NOW() returned to a php variable. mysql_query('INSERT INTO translate (IDRef, RefType, Lang, Text, LastChangeTS) VALUES ('.$id.', \''.$reftype.'\', \''.$lang.'\', \''.$text.'\', NOW()) ON DUPLICATE KEY UPDATE text = \''.$text.'\', LastChangeTS = NOW()'); mysql_query('SELECT LastChangeTS FROM translate WHERE IDRef = '.$id.' AND RefType = \''.$reftype.'\' AND Lang = \''.$lang.'\'');

  Read the article

• Update Mysql database with dataset changings? (C#)

  - by Ases

  I'm changing my dataset in my program. And when my job was finished, I'm connecting to mysql database. I don't want to do this job again, how can I send changings to database like this mydatadapter.Update(dataset, " table"); I found this code, but I can't run it :S

  Read the article

• mysql get last auto increment value

  - by Mick

  Hi I have a field in mySql table called jobnumber which auto increments with each new entry. What I want to do is when a user views my form, get the value of the next 'jobnumber' . But I want to do this before any entry is made to the table. IE so when a user looks at a form it will display something like 'this is job number 6954' I have tried $rr = mysql_insert_id() but this only work after I have made an entry Can anyone help please thanks

  Read the article

• MySQL 5.0.22 export dump file not importing - syntax errors

  - by user348033

  Hello, I backed up my db with mysqldump from phpMyAdmin. Using MySQL 5.0.22. Made no changes to database file. Import fails. Found many instances of extra spaces using notepad, but now cannot find any other such extraneous spaces. Error is 1064. Any suggestions on how to import file properly? Thanks.

  Read the article

• MySQL friends table

  - by asmo

  I have a MySQL DB in which I store data about each user. I would like to add a list of friends for each user. Should I create a table of friends for each user in the DB or is there a better way?

  Read the article

• Archive Parent / Child Table Hierarchy in MySQL

  - by Eric J.

  If I have a Parent and Child table in MySQL related by a foreign key, is it possible using a SQL statement to move certain rows from Parent and the related rows from Child into archive tables (e.g. Parent_Archive and Child_Archive) in an atomic manner?

  Read the article

• graphical relationship map for doctrine/mysql?

  - by ajsie

  i wonder if there is gui tools for creating a graphical map for the relationship between models/objects (doctrine) or tables (mysql)? it would be better than draw it manually. i´ve already have the models/objects and tables created.

  Read the article

• Import MySQL database into a MS SQL Server

  - by marionmaiden

  I have a .sql file from a MySQL dump containing tables definitions and the data to be inserted in this tables. How can I convert this database represented in the dump file into a MS SQL server database?

  Read the article

• MySQL connection timeout

  - by NikolayGS

  I'm running program at apache tomcat server, that should be on permanently, but every morning(the client part isn't accessible at night) i receive error message (in apache tomcat console) that MySQL server is off. So is there any way to prevent this? Thanks in advance!

  Read the article

• mysql command for update

  - by Mac Taylor

  hey guys i need to add a special text to all rows in my mysql table , how to add some text to the end of all rows' content in a table just for one field i used this code : UPDATE `blogs` SET `title`= `title`+ 'mytext'; but didnt work for me

  Read the article

• MySQL vs PostgreSQL on Windows

  - by luke101

  I am torn between postgreSQL and MySQL but I am forced to install the choosen one on windows. I especially need asp.net membership and i will be installing NHibernate as well.

  Read the article

• How do you debug MySQL stored procedures?

  - by Cory House

  My current process for debugging stored procedures is very simple. I create a table called "debug" where I insert variable values from the stored procedure as it runs. This allows me to see the value of any variable at a given point in the script, but is this is there a better way to debug MySQL stored procedures?

  Read the article

• Not able to create a datasource registration with WAMP MysQL 5.0 in DBArtisan

  - by Alf Christophersen

  I try in a test version of DBArtisan to set up a datasource and register both servere as localhost, database to use, my username and password, but, when testing the connection, I get message that connection failed. Hooking up from eg. Delphi and other utilities run nicely. But not DBArtisan, Is MySQL 5.0 not supported yet ?? Or is it WAMP that is the culprit naming the service wampmysqld insted of just mysqld ??

  Read the article

• Grails MySQL MaxPoolSize

  - by Bob Herrmann

  How do I increase the maxPoolSize in Grails when using mysql? It appears to be using a default connection pool only 8 connections.

  Read the article

• Php + mysql transactions examples

  - by Donator

  I really haven't found normal example of php file where mysql transactions are being used. Can you show me simple example of that? And one more question. I've already created a lot of programming and didn't use transaction, maybe I can put any php function or smth to header.php that if one mysql_query fails, then others too? Thank you.

  Read the article

• MYSQL and Array with PHP for create Tag Cloud

  - by asilloo

  Hi, I'm trying to make a Tag cloud for every user in own page, I'm using PHP5 and Mysql, My table named "tags" and I want to make a array but in short way. The table like below, The array can be like for user1 array={[car,1],[cat,null],[pen,1],[dvd,1],[cd,null]} Username totaltag tag1 tag2 tag3 tag4 tag5 admin 5 car cat pen dvd cd user1 1 1 1 user2 1 2 12 1 user3 3 2 10 1

  Read the article

• mysql insert with auto-increment column

  - by czuroski

  Hello, I am trying to insert data into a mysql table from a csv file. I am using the infile sql command, but I am having trouble because the first column of the table is an id that is set as an auto increment field. what do I have to set my first column value to in order to get this to work, or can I do it at all? Thanks

  Read the article

• MySql query BETWEEN two Strings sometimes doesn't work

  - by bucabay

  I have a mysql query where a subquery is: BETWEEN '5.00' AND '10.00' And this returns no results. However when I use Floats or Ints: BETWEEN 5 and 10 it works The BETWEEN query also works for other values AS strings, but just not for 5 and 10. EG: BETWEEN '4' AND '5' works. How could this be?

  Read the article

• i want to fire atrigger after data has been inserted in a tablein mysql

  - by bhard

  dear all, i want to fire a trigger after my table has been filled woth reords ,i dont want to fire a rowwise trigger.please tell how can we do that in mysql.

  Read the article

• MySQL - Update the same column twice

  - by uzioriluzan

  Hello, I need to update a column in a mysql table. If I do it in two steps as below, is the column "col" updated twice in the disk ? update table SET col=3*col, col=col+2; or is it written only once as in : update table SET col=3*col+2; Thanks

  Read the article

• how to activate trigger after all the bulk insert(s) in mysql

  - by JPro

  I am using mysql and there are bulk inserts that goes on to my table. My doubt is if I create a trigger specifying after insert, then the trigger will get activated for every insert after, which I do not want to happen. Is there any way to activate a trigger after all the bulk inserts are completed? Any advice? Thanks.

  Read the article

• have mysql select statement return fully qualified column names like table.field

  - by handsomeGun

  is there a way to have a mysql select statement return fully qualified column names like "table.field" without using AS for every single field? like so: SELECT * FROM table1 LEFT JOIN table2 on table1.f_ID = table2.ID and the result would be: "table1.ID", "table1.name", "table2.ID", "table2.name", ...

  Read the article

• Can JavaScript connect with MySQL?

  - by Anonymous the Great

  Can JavaScript connect with MySQL? If so, how? Easy rep! :D

  Read the article

• PHP Array in MySQL IN() function?

  - by Trez

  Is it possible to assign php array in MySQL IN() function? for example, $numbers = array('8001254656','8886953265','88864357445','80021536245'); $sql = mysql_query("SELECT * FROM `number_table` WHERE `number` IN ($numbers)"); Any Ideas? Thanks,

  Read the article

• Unique text field in MySQL and php

  - by Jonathan

  I've created a salt using; md5(rand(0,10000000)); (there is probably a better way?) There doesn't seem to be possible to make a text field unique in MYSQL. So how do I check if the salt has already been used for a previous user? Or should I generate the salt based on the current date/time? as it is impossible for 2 users to register at exactly the same time correct?

  Read the article

< Previous Page | 124 125 126 127 128 129 130 131 132 133 134 135  | Next Page >