Search Results

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

Page 302/599 | < Previous Page | 298 299 300 301 302 303 304 305 306 307 308 309  | Next Page >

• Get insert statement query

  - by Karthick

  Hi, Is there a way to get the insert statements for a table via some query in MySql? for ex: if the table name is Cards,which has 5 rows, i need to get the insert statements for that particular table. Thanks.

  Read the article

• Is there anyway to change the database server without stopping the database?

  - by Tattat

  I have a database in data center, which is running MySQL, and I want to change the database from data center to host in my company. At that time, I don't want to stop the data base in the data center, is there anyway to this kind of integeration? Thank you...

  Read the article

• what does select @@identity do?

  - by every_answer_gets_a_point

  i am connecting to a mysql database through excel using odbc what does this line do? Set rs = oConn.Execute("SELECT @@identity", , adCmdText) i am having trouble updating the database: With rs .AddNew ' create a new record ' add values to each field in the record .Fields("datapath") = dpath .Fields("analysistime") = atime .Fields("reporttime") = rtime .Fields("lastcalib") = lcalib .Fields("analystname") = aname .Fields("reportname") = rname .Fields("batchstate") = "bstate" .Fields("instrument") = "NA" .Update ' stores the new record End With it is ONLY updating .Fields("instrument") = "NA", but for all other fields it is putting NULL values

  Read the article

• How Assigning query return value to local a variable, and how to use that in where condition?

  - by Ayyappan.Anbalagan

  I am using mysql stored procedure; I need to assign query retuned value to local variable. And i have to check the condition using the local variable..... or It my query Select Meterial_Id from hemaepdb.transaction where CustId=1; Instead of Meterial_Id i need to get the Meterial_name from Material table.....

  Read the article

• give preference to print array values in php

  - by Bharanikumar

  Hi , I have country table, i fetch all values and moved into array , these value i like to populate into combo/dropdown list , here i want to do some magic things, that is , for my site most of the users coming from uk,us,Australia,Romain and few, So i like to populate by my preference , is there any array will do this magic work, else is it possible mysql query , So final question is , Populate country name into combo based on my prefernce , Thanks

  Read the article

• In 64 bit systems, a 32 bit column occupies less space than a 64 bit one?

  - by estourodepilha.com

  In MySQL running on a 64bit OS, every column occupies at least 64 bits? A bit would occupy a whole byte? or a whole word?

  Read the article

• Skip all databases and run only specific one

  - by Ergec

  I have a sql file generated by "mysqldump --all-databases" . There are many databases in it. What I want to do is to update my local database but only a specific one, not all. I tried to use "mysql -database=db_name < file.sql" but it updated all databases. Is there a way to skip all databases except the one that I want.

  Read the article

• How to check how many characters in variable, and add space between characters in that var?

  - by Camran

  I have a 'price' variable that contains some integer number from a MySQL database. I want to check how many numbers the 'price' variable contains, and add a space in the variable depending on how many numbers. See below: Example: If 'price' is 150000 I would like the output to be 150 000 (notice the space). OR, if it is 19000 I would like it to output 19 000... How would you do this the easiest way?

  Read the article

• SQL select from last inserted

  - by arik-so

  Hello, in MySQL, I have table. One column has auto-increment. When I insert something mysql_query('INSERT INTO `table` SET `column` = "data";'); Now, what I want is, without further queries, to get the value of the auto-incrementing column, maybe like this: mysql_query('insertion = (INSERT INTO `table` SET `column` = "data"); SELECT `auto_incrementing_column` FROM `table`.insertion'); Please tell me how something like that is done. Thanks in advance!

  Read the article

• Online booking system with php

  - by Felicita

  Im looking for any tutorial for online booking and reservation using php and mysql. I cant find so much from google.

  Read the article

• how to get latest entry of a item when item have multiple rows?

  - by I Like PHP

  i have an table tbl_exp id| exp_id|qnty| last_update 1 | 12 | 10|2010-05-18 19:34:29 2 | 13 | 50|2010-05-19 19:34:29 3 | 12 | 50|2010-05-19 19:34:29 4 | 15 | 50|2010-05-18 19:34:29 5 | 18 | 50|2010-05-20 19:34:29 6 | 13 | 70|2010-05-20 19:34:29 now i need only latest entry of each exp_id id| exp_id|qnty| last_update 3 | 12 | 50|2010-05-19 19:34:29 6 | 13 | 70|2010-05-20 19:34:29 4 | 15 | 50|2010-05-18 19:34:29 5 | 18 | 50|2010-05-20 19:34:29 please suggest me the mysql query to retrive above result?? thanks!

  Read the article

• What is the efficient way to make a permission system?

  - by WEBProject

  Currently im just using something like: in the DB Table: access: home,register,login and then in each page: if(!Functions::has_rights('content')) { Functions::noAccess(); } is there more efficient way to do it, php & MySQL? i may want to gain access even to several parts a page, for example: user can read a page, but doesnt comment to it, and I dont want to build a separate system to each module. Thanks in advanced, Tal.

  Read the article

• how to write a bat file to execute the .sql fiel

  - by ganuke

  I want to execute query in side the db.sql file using MySQL 5.1 in windows environment. Can any one help me to this. I want to do this by runing a bat file.

  Read the article

• InnoDB - Two foreign keys on the same column from one table

  - by makeflo

  Hey Guys, i have a project table which has a image_id field and a newsimage_id field. Both are linked to the image table. But InnoDB doesn't allow me to set a foreign key for both fields to the same column (id). Is there a way I can do this or is it not possible? I'm using MySQL through MAMP. Thanks in advance!!

  Read the article

• Foreign keys - temporarily bypass?

  - by Industrial

  Hi, I have just started to learn about the pros of foreign keys in database design (mySQL / innoDB) and I wonder if there's any way to temporarily bypass the foreign key when doing a specific delete query, to just delete in the parent table, and not from the linked child tables. Thanks

  Read the article

• From Now() to Current_timestamp in Postgresql

  - by xRobot

  In mysql I am able to do this: SELECT * FROM table WHERE auth_user.lastactivity > NOW() - 100 now in postgresql I am using this query: SELECT * FROM table WHERE auth_user.lastactivity > CURRENT_TIMESTAMP - 100 but I get this error: operator does not exist: timestamp with time zone - integer How can I resolve ?

  Read the article

• How can i fetch all data from any table of a test DB and DUMP it on the production db in same tablen

  - by Parth

  How can i fetch all data from any table of a test DB and DUMP it on the production db in same tablename(structure)? in Mysql using PHP code? Please help me..

  Read the article

• difference between cn.execute and rs.update?

  - by every_answer_gets_a_point

  i am connecting to mysql from excel using odbc. the following illustrates how i am updating the rs With rs .AddNew ' create a new record ' add values to each field in the record .Fields("datapath") = dpath .Fields("analysistime") = atime .Fields("reporttime") = rtime .Fields("lastcalib") = lcalib .Fields("analystname") = aname .Fields("reportname") = rname .Fields("batchstate") = "bstate" .Fields("instrument") = "NA" .Update ' stores the new record End With the question is why is there a need to run cn.execute after this? havent i already updated the rs with rs.update?

  Read the article

• How should I go about adding slashes to only single quotes and ignoring double quotes?

  - by atwellpub

  How should I go about adding slashes to only single quotes and ignoring double quotes? I am using php. I would only like to escape single quotes to prevent my php mysql queries from breaking. Thank you!

  Read the article

• How would Sphinx Search index / handle JSON files?

  - by ming yeow

  I have a mysql database that stores mainly JSON objects. I am thinking of using Sphinx to search through it - but i was wondering how would i index and retrieve these json objects?

  Read the article

• What is the best way to send data from Java to PHP?

  - by Daeyun

  I want to access a MySQL database from Java, but remote connection is disabled by the host. So I will send the data to PHP and then PHP will locally access the database. The data is pretty big (about 2~4kb) I've never done this before. What should I do?

  Read the article

• mysql_fetch_row() not a valid result resource

  - by user1717305

  I am confused, I don't know what's wrong. I'm about to transfer all data from my first table to the other. Here is my code: $getdata = mysql_query("SELECT Quantity, Description, Total FROM ordercart"); while($row = mysql_fetch_row($getdata)) { foreach($row as $cell){ $query1 = mysql_query("INSERT INTO ordermem (Quantity, Description, Total) VALUES ($cell)",$connect); } mysql_free_result($getdata); } I get the error: Warning: mysql_fetch_row(): 5 is not a valid MySQL result resource.

  Read the article

• Why is this SQL query throwing Warnings?

  - by user355367

  $resultnx = mysql_query("SELECT * FROM `emails` WHERE `email` = '{$email}'"); $num_rows = mysql_num_rows($resultnx); gets this warning Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in ....

  Read the article

• Using Hidden Iframes to run PHP scripts - good? bad? opinions?

  - by jon

  I am a little bit new to the PHP/MYSQL arena, and had an idea to be able to interact with my Database by using a hidden Iframe to run PHP pages in the background(iframe) on events without having to leave the current page? Good? Bad? Common Practice? Opinions?

  Read the article

• problem in creating a trigger

  - by mohanish

  Hi Bill I am facing a problem in creating a trigger and i am not sure why this is erroring out.can you please help me. I have described the problem in this link below http://forums.mysql.com/read.php?99,365942,365942#msg-365942.

  Read the article

< Previous Page | 298 299 300 301 302 303 304 305 306 307 308 309  | Next Page >