About 1,938,534 results (3,013 milliseconds)
Data manipulation language (DML) statements in GoogleSQL ...
https://cloud.google.com/bigquery/docs/reference/standard-sql/dml-syntax The BigQuery data manipulation language (DML) enables you to update, insert, and delete data from your BigQuery tables. ... To delete all rows in a table, use the ...
[Feature Request] Let manage.py ignore migration dependencies
https://groups.google.com/g/django-developers/c/eDRgkvtKyRs/m/1MmZ4rEcBAAJ > 1.Create database on server / point django at it / set up router > 2. migrate <app> --database=app_db > 3. Delete all the duplicate auth_* and django_* tables
Generate Comands to Create/Drop all Indexes in a Database
https://sites.google.com/site/chilledsql/welcome/tip_category_indexes/tip_detail_indexes_generatecreatedropindexcommands Data/Database Compression - Compress all Tables and Indexes · Data/Database ... Performance - Kill all Orphan Processes on a SQL Server · Performance ...
Replicating data from SQL Server to BigQuery | Cloud Data Fusion ...
https://cloud.google.com/data-fusion/docs/tutorials/replicating-data/sqlserver-to-bigquery ... database AdventureWorks2017 , which has primary keys on all tables. To replicate a different database, such as the Data Warehouse DB AdventureWorksDW2017 ...
best way to Export Cloud SQL database
https://groups.google.com/g/google-cloud-sql-discuss/c/sfOShJ92_7Y Aug 27, 2019 ... once finished exporting all tables i'm using mysqldump to import the gz files into the staging db. the problem is , that sometimes (too often) i ...
Debezium PostGreSQL multiple connectors to the same database
https://groups.google.com/g/debezium/c/uCyoq3IGj3Q Feb 27, 2022 ... I'm looking setting up Debezium to capture changes in a PostGres database in GCP Cloud SQL. We are using the debezium mainly to stream new changes done.
Best practice: How to obfucate key in URL? Use AUTOINT vs. GUID ...
https://groups.google.com/g/cfwheels/c/6VGq8inQlg8 Up to now, I use in almost all tables an autoincrementing INT as my primary key. ... GUID as primary key, created by SQL server. 2. UUID created by the app ...
Cannot repair database - all options tried
https://groups.google.com/g/web2py/c/ztQLASakiYg/m/UtT8Yi3zH1sJ * Export the mysql-data to csv-file(s). * Drop the tables * Fix your models. * delete all the files in web2py/applications<yourapp>/databases * start the ...
Gerrit and git-filter-branch
https://groups.google.com/g/repo-discuss/c/qU3Pwm9q1C0 May 4, 2010 ... the rewritten one. I did all of the above with the Gerrit server shutdown, so nobody could modify the repository or the SQL database while I was ...
Paradox "databases" and tables
https://groups.google.com/g/borland.public.delphi.database.desktop/c/wh_d7BLBgNw with Delphi and database programming is all using MS SQL-Server. In these ... Query.SQL.Clear; Query.SQL.Add('select * from mytable.db'); Query.Open.
Replicate data to BigQuery in near real-time with Datastream ...
https://cloud.google.com/datastream/docs/quickstart-replication-to-bigquery Cloud SQL for SQL Server database ... In this section, you confirm that Datastream transfers the data from all tables of your source PostgreSQL database into ...
Importing SQL Tables, Columns & Data types into Draw.io
https://groups.google.com/g/drawio/c/YgLbamwSApo Does anyone know of a way to import all tables from a SQL database along ... A contribution has been made recently to support SQL Server and MySQL in ...
Manage datasets | BigQuery | Google Cloud
https://cloud.google.com/bigquery/docs/managing-datasets The dataset copy job overwrites all of the data in the destination dataset, including both the tables and schema. The destination table might not reflect ...
Problems with different column orders in the database
https://groups.google.com/g/jooq-user/c/4QPSmTf9Wvs Aug 30, 2023 ... But, in development I sometimes clear the database (i.e. I drop all tables ... sql-select-all/. If you're not using the asterisk, but ...
Emptying / Deleting the process engine history tables in database
https://groups.google.com/g/camunda-bpm-users/c/DIeC8-PCiUk Dec 8, 2014 ... You can use plain SQL as you suggest. You should be able to safely delete all historic process instances (and activity instances, task instances) ...
Deleting a batch from a mysql database
https://groups.google.com/g/stacks-users/c/aq2rf_la7o4 millions of reads/hundreds of samples, deleting all the records from the database can take the SQL server a very long time. But, you can prune out a bunch ...
Simplest way to clear out all records in a database
https://groups.google.com/g/ica-atom-users/c/Obxqc0AmhAw May 11, 2015 ... ... database, and craft a SQL query that will delete all descriptions - be sure the query touches all related tables, such as the i18n and slug ...
Mass Update/Delete
https://groups.google.com/g/cfwheels/c/dbAhkcNHirg/m/EbTlK4RNdIwJ I have a simple table displaying shipment records. I want to add a column of checkboxes for the purpose of mass deletion. The checkboxes have the same name ...
Large project deletion
https://groups.google.com/g/xnat_discussion/c/m-d2OtGluuo - drop the database and recreate it ( possibly by deleting all tables/views ) ... data : sql scripts are applied on the server ). So : 1- In the web ...
What 5 things should SQL Server get rid of? - Paul S. Randal
http://feedproxy.google.com/~r/PaulSRandal/~3/vWj3chcto_I/post.aspx May 10, 2010 ... Not only will the database be shrunk to the smallest possible size, but all ... Compact all data and indexes to remove all page and extent splits ...