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.
Search Results
Search found 20931 results on 838 pages for 'mysql insert'.
Page 337/838 | < Previous Page | 333 334 335 336 337 338 339 340 341 342 343 344 | Next Page >
-
-
manage user permissions in php
- by user420528
i am creating a marks management system using php & mysqlwhere the concerned faculty will be able to login and enter the marks of the students. i can go with a simple table but the problem is there are 288 different subjects for which marks must be entered. So creating a mysql table with so many subjects does not look good for me. please suggest me the best way to manage user permissions so that only the corresponding faculty will be able to enter marksRead the article
-
Data pagination with "saved" search
- by TiuTalk
I'm creating a page that's a search result... When you're viewing one of the results, at the bottom of the page, I need to insert "Next result" and "Previous result" links, like a pagination... But from [I think] a saved search, right? How you people would do this? Obs.: I'll use CakePHP (PHP) and MySQLRead 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
-
Why does this properly escaped SQL query fail?
- by Jason Rhodes
Here's the query: INSERT INTO jobemails (jobid, to, subject, message, headers, datesent) VALUES ('340', '[email protected]', 'We\'ve received your request for a photo shoot called \'another\'.', 'message', 'headers', '2010-04-22 15:55:06') The datatypes are all correct, it always fails at the subject, so it must be how I'm escaping the values, I assume. I'm sure one of you will see my idiot mistake right away. A little help?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
-
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
-
My team member not supporting to use Crystal report in asp.net web application.
- by Ayyappan.Anbalagan
My team member not supporting to use Crystal report in asp.net web application. specially Crystal report with mysql database. Is there any other report available?Read the article
-
Maximum number of records in a database table
- by pepernik
What is the upper limit of records for MySQL database table. I'm wondering about autoincrement field. What would happen if I add milions of records? How to handle this kind of situations? Thx!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 to show only few lines from a body text
- by saquib
Hi, I have a mySql database i want to display only 10 words from its body field which contain html codes, How i can do that, is there any php function to do that.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
-
reading into table: comma values and quotes SQL
- by every_answer_gets_a_point
i have a string like this something = "something, something1, "something2, something else", something3" i need it to be read into a table like this: field1 = "something" field2= "something2" field3 = "something2, something else" field4 = "something3" please notice that the double quotes in the something string signified that the string inside the quotes is to be placed in one field anyone know how to do this with an insert into statement or some other way? the answer can be purely sql or can be vba with sql. thanks!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
-
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
-
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
-
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
-
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
-
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
-
What do I need to be able to use Joomla as an online application development enbironment
- by howdyworld
I develop applications using PHP and MySQL. They're not trivial, though they're not too complex. As an example to that I have written an online application to enable football administrators manage the player, competition and judiciary processes. Separately to that I have used Joomla to create websites for small businesses. I'd like to be able to use Joomla as my online application development environment. Is there a way I can use Joomla for that?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
-
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 valuesRead 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
-
Looking for a tutorial about dynamic mysql calendar
- by jasmine
Im Looking for a tutorial recommendation about dynamic mysql calendar. Thanks in advanceRead 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
